[MySql] 쿼리 로그 남기기

from : http://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log

Here is a summary:

If you don't want or cannot restart the MySQL server you can proceed like this on your running server:

• Create your log tables (see answer)

• Enable Query logging on the database (Note that the string 'table' should be put literally and not substituted by any table name. Thanks Nicholas Pickering)

SET global general_log = 1;
SET global log_output = 'table';

• View the log

select * from mysql.general_log

• Disable Query logging on the database

SET global general_log = 0;