设置mysql的general log
方法一:生成general的表
Setting MySQL General Log
This topic describes setting MySQL general log table.
Add parameters to my.cnf file (For Windows, my.ini).
Go to %MYSQL_HOME directory.
Open my.cnf (for UNIX) or my.ini (for Windows) with your text editor.
Add the following parameters in section.
general_log=1
log_output=TABLE
Restart MySQL databases.
Change the definition of "mysql.general_log" table.
Switch the engine from CSV to MyISAM. To switch the engine from CSV to MyISAM, execute the following commands (the default is ENGINE=CSV).
mysql> SET GLOBAL general_log = 'OFF';
mysql> ALTER TABLE mysql.general_log ENGINE = MyISAM;
mysql> SET GLOBAL general_log = 'ON';
Check the definition of "mysql.general_log" table. Execute the following SQL command:
mysql> show create table mysql.general_log\G;
-----------------------------------------+
| Table | Create Table
-----------------------------------------+
| general_log | CREATE TABLE `general_log` (
`event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TI
MESTAMP,
`user_host` mediumtext NOT NULL,
`thread_id` int(11) NOT NULL,
`server_id` int(11) NOT NULL,
`command_type` varchar(64) NOT NULL,
`argument` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='General log' |
+-------------+--------------------------------------------
Check if logging started. Execute the following command:
mysql> select * from mysql.general_log;
第二种方法：
mysql>set global general_log_file='/tmp/general.log';
mysql>set global general_log=on;
mysql>set global general_log=off;
查看tmp/general.log的信息，可以大致看到哪些sql查询/更新/删除/插入比较频繁了
第三种方法：
添加到my.cnf中(重启mysql生效)
general_log=1
general_log_file=’/tmp/general.log’;
页:
[1]