MySQL multiple instances: can you specify a separate general_log/general_log_file option?

Posted by gravyface on Server Fault See other posts from Server Fault or by gravyface
Published on 2012-06-19T17:46:11Z Indexed on 2012/07/10 15:18 UTC
Read the original article Hit count: 388

Filed under:

mysqld-multi

|

general-log

|

general-log-file

Have two working MySQL instances as well as the default instance.

I have general logging enabled on the default; this is working fine.

On the second instance, I've added:

general_log = 1

general_log_file = /path/to/log/file

under [mysqld1].

Restarted the instance (using mysqladmin and confirmed it was not running with mysqld_multi report 1), started it back up again, and the only data in the log file are the connect statements from when mysqld_multi report 1 was executed.

Are all the instance #1 queries just being logged to the default instance general log file? The default instance is quite busy and has identical database names, tables, etc. so it's difficult to figure out right now.

© Server Fault or respective owner

Related posts about mysqld-multi

MySQL multiple instances: can you specify a separate general_log/general_log_file option?

as seen on Server Fault - Search for 'Server Fault'
Have two working MySQL instances as well as the default instance. I have general logging enabled on the default; this is working fine. On the second instance, I've added: general_log = 1 general_log_file = /path/to/log/file under [mysqld1]. Restarted the instance (using mysqladmin and confirmed… >>> More
mysqld_multi stop doesn't seem to work

as seen on Server Fault - Search for 'Server Fault'
mysqld_multi stop 1 followed by (repeatedly, a few moments later) mysqld_multi report 1 returns: Reporting MySQL servers MySQL server from group: mysqld1 is running The instances work fine and when I reboot, I have to start the instances to get them to come back up (a separate issue I need to… >>> More
How to turn off the binary log for mysqld_multi instances?

as seen on Server Fault - Search for 'Server Fault'
MySQL supports running multiple mysqld on the same server. One of the ways is to use mysqld_multi. If the default MySQL server instance (as configured in the [mysqld] section in my.cnf) uses log-bin, it enables the binary log for all the other instances ([mysqld1], [mysqld2], etc). How can we override… >>> More

Related posts about general-log

Getting the general log to work in MySQL 5.6.8

as seen on Server Fault - Search for 'Server Fault'
I can't get the general log to work in this version of MySQL. I added the following lines to /usr/my.cnf: general_log = 1 general_log_file = "/var/log/mysql.log" Then restarted the server: [root@localhost ~]# service mysql restart Shutting down MySQL.. SUCCESS! Starting MySQL. SUCCESS! The… >>> More
General logging won't work in MySQL

as seen on Server Fault - Search for 'Server Fault'
I saw on SF that there's an option in MySQL to log all queries. So, in my version (mysql-server-5.0.45-7.el5 on CentOS 5.2) this appears to be a case of enabling the 'log' option, so I edited /etc/my.cnf to add this: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql old_passwords= log=/var/log/mysql-general… >>> More
MySQL multiple instances: can you specify a separate general_log/general_log_file option?

as seen on Server Fault - Search for 'Server Fault'
Have two working MySQL instances as well as the default instance. I have general logging enabled on the default; this is working fine. On the second instance, I've added: general_log = 1 general_log_file = /path/to/log/file under [mysqld1]. Restarted the instance (using mysqladmin and confirmed… >>> More
How to extract all IDs accessed from a mysql general log using the linux commandline?

as seen on Stack Overflow - Search for 'Stack Overflow'
This should be a trivial question for anyone who's good with bash/sed/awk. Unfortunately, I'm not, yet :) I've got a general log from MySQL which contains some queries that have a common parameter, they query on a specific id field. The queries look like update tbl set col='binary_values' where… >>> More
Quartz.Net Windows Service Configure Logging

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
In this blog post I’ll be covering, Logging for Quartz.Net Windows Service 01 – Why doesn’t Quartz.Net Windows Service log by default 02 – Configuring Quartz.Net windows service for logging to eventlog, file, console, etc 03 – Results: Logging in action … >>> More