Sponsored Content
Full Discussion: Mysql logging in Solaris
Top Forums UNIX for Dummies Questions & Answers Mysql logging in Solaris Post 302135297 by moe2266 on Friday 7th of September 2007 11:41:53 AM
Old 09-07-2007
Computer Mysql logging in Solaris

Folks;
i have mysql installed on Solaris box (sparc).
The problem is under /opt/mysql/data directory, there's a log file that grows very fast & becomes a huge size.
Is there a way to stop the logging under the data directory so i don't have the issue of running out of space?

Your help will be a greatly appreciated.
 

10 More Discussions You Might Find Interesting

1. Solaris

logging solaris 10 tcp-wrappers

I want to log tcp-wrapper events Solaris 10. I researched and saw that I could make a syslog entry in the hosts.deny, which I did below. After restarting syslog and having ssh blocking, I see nothing logging. I also do not get the email that should be generated. The file was taken from a... (2 Replies)
Discussion started by: csgonan
2 Replies

2. Solaris

Solaris 10 freezes up while logging in.....!!!!

Hi all, I have installed Solaris along with Xp ....The installation was successful... I get the Grub menu displaying Solaris along with Win Xp....After i select Solaris the following happens, "Failed to initialize inband hotplug controller" The above message repeats three times & i get the... (2 Replies)
Discussion started by: codewarrior
2 Replies

3. Solaris

Logging Connections in Solaris

Hi All, Is there a built in function/tool in Solaris that enables creation of a history file on any connection (via telnet, ssh, rsh or nfs) to Solaris machine? I would like to create a script that records IP Address, date and timestamp, and command excuted for any connection to a Solaris... (2 Replies)
Discussion started by: racbern
2 Replies

4. Solaris

Xferlog in solaris (FTP logging)

HI all, i Have a requirement for my customer fro tracking the ftp user sessions details. After some google search i got to know i need to confgure xferlog for the same.Want to know how to start the xferlog in solaris 10. Please help me :( (2 Replies)
Discussion started by: rgrandhi
2 Replies

5. Solaris

logging incoming connections on solaris 10

i've been able to log incoming telnet and ssh connections on solaris 9 using the following lines in /etc/syslog.conf # Telnet connections are logged to auth.notice auth.notice /var/adm/authlog # An entry in /etc/profile logs all telnet connections... (2 Replies)
Discussion started by: soliberus
2 Replies

6. UNIX for Advanced & Expert Users

Solaris auditing (file access logging) for specific directory only.

Hello, We need to log the operations that specific user on Solaris 10 (SPARC) is performing on one directory and it's contents. I was able to configure solaris auditing service (auditd) and it works fine. The only problem is that auditd logs huge amount of unneeded information. We need to log... (0 Replies)
Discussion started by: +Yan
0 Replies

7. Solaris

How to enable logging in Solaris 10?

hi all, i want to log every thing happen in my server is any body can provide me with articals, pdf's is that correct to log every thing in the system what is the most important thing i should i log it (4 Replies)
Discussion started by: corvinusbsd
4 Replies

8. Solaris

Solaris 2.6 failed login logging

Holla! Sorry to spam the board with all my Solaris 2.6 questions (I just found this forum). My most recent problem is that not ALL failed log-ins are getting logged in /var/log/authlog. It seems to work fine for the "su" command from a non-root user, but the actual "login" command or a desktop... (4 Replies)
Discussion started by: rrossorr
4 Replies

9. Solaris

Solaris 10 Not Logging Anything

Hello, It would appear that my server is no longer logging anything. Last time anything was written to /var/adm/messages and /var/log/syslog was Aug 26 2010. I was told there was a storm and the power went out or something around that time, but there were never any problems. I've tried... (11 Replies)
Discussion started by: gadonj18
11 Replies

10. Solaris

Connection Logging in Solaris 10 & 11 - Beginner

Excuse my ignorance as I am very new to working with Solaris. I'm looking for documentation on how to create a network log in Solaris 10 & 11. I don't wish to edit any of the logs currently the system. I simply want a log that will capture all incoming IP addresses and log them with a time-in... (8 Replies)
Discussion started by: FamousAv8er
8 Replies
OCF_HEARTBEAT_MYSQL()													     OCF_HEARTBEAT_MYSQL()

NAME
ocf_heartbeat_mysql-proxy - Manages a MySQL Proxy daemon SYNOPSIS
mysql-proxy [start | stop | reload | monitor | validate-all | meta-data] DESCRIPTION
This script manages MySQL Proxy as an OCF resource in a high-availability setup. Tested with MySQL Proxy 0.7.0 on Debian 5.0. SUPPORTED PARAMETERS
binary Full path to the MySQL Proxy binary. For example, "/usr/sbin/mysql-proxy". (optional, string, default /usr/sbin/mysql-proxy) defaults_file Full path to a MySQL Proxy configuration file. For example, "/etc/mysql-proxy.conf". (optional, string, no default) proxy_backend_addresses Address:port of the remote backend-servers (default: 127.0.0.1:3306). (optional, string, default 127.0.0.1:3306) proxy_read_only_backend_addresses Address:port of the remote (read only) slave-server (default: ). (optional, string, default 127.0.0.1:3306) proxy_address Listening address:port of the proxy-server (default: :4040). You can also specify a socket like "/tmp/mysql-proxy.sock". (optional, string, default :4040) log_level Log all messages of level (error|warning|info|message|debug|) or higher. An empty value disables logging. (optional, string, no default) keepalive Try to restart the proxy if it crashed (default: ). Valid values: true or false. An empty value equals "false". (optional, string, no default) admin_address Listening address:port of the admin-server (default: 127.0.0.1:4041). (optional, string, default 127.0.0.1:4041) admin_username Username to allow to log in (default: ). (optional, string, no default) admin_password Password to allow to log in (default: ). (optional, string, no default) admin_lua_script Script to execute by the admin plugin. (optional, string, no default) parameters The MySQL Proxy daemon may be called with additional parameters. Specify any of them here. (optional, string, no default) pidfile PID file (optional, string, default /var/run/resource-agents/mysql-proxy-default.pid) SUPPORTED ACTIONS
This resource agent supports the following actions (operations): start Starts the resource. Suggested minimum timeout: 30s. stop Stops the resource. Suggested minimum timeout: 30s. reload Suggested minimum timeout: 30s. monitor Performs a detailed status check. Suggested minimum timeout: 20s. Suggested interval: 60s. validate-all Performs a validation of the resource configuration. Suggested minimum timeout: 30s. meta-data Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s. EXAMPLE
The following is an example configuration for a mysql-proxy resource using the crm(8) shell: primitive example_mysql-proxy ocf:heartbeat:mysql-proxy op monitor depth="0" timeout="20s" interval="60s" SEE ALSO
http://www.linux-ha.org/wiki/mysql-proxy_(resource_agent) AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors) OCF_HEARTBEAT_MYSQL()
All times are GMT -4. The time now is 06:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy