How to log all mysql queries on linux?

Hi,

having linux shell and MySQL 5.1.73

i added this line into /etc/my.cnf:
general_log_file=/var/log/mysqlquery.log

and then: service mysqld reload

but i still see only this in that file:

141102 17:15:14 [Note] /usr/libexec/mysqld: Shutdown complete
141102 17:15:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141102 17:18:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141102 17:18:07 InnoDB: Initializing buffer pool, size = 8.0M
141102 17:18:07 InnoDB: Completed initialization of buffer pool
141102 17:18:08 InnoDB: Started; log sequence number 0 44233
141102 17:18:08 [Note] Event Scheduler: Loaded 0 events
141102 17:18:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution

no queries… i just want to analyse queries of several websites as when i submit data to all of thems at a time, its only submitted on very few of these websites so i neeed to debug the issue.

thank You

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.