Facebook
Twitter
T
tazatek
Guest
Hello,
Plesk 8.1.1, FC4, MySQL 4.1.20 -- Fairly standard setup
Problem: I'm not getting all my MySQL logs written into the log file. Just to clarify, I'm looking /var/log/mysqld.log (and /var/log/* in general)
Is there another place place to look for logs? Is there a way to turn on verbose logging for short periods?
The only thing I see in the mysqld.log file is start/stop logging.
What I'm really looking for is the SQL statement logging (SELECT * FROM db_tbl
as well as any other "error" messages (unable to connect, bad password, etc
I know that Plesk sometimes put logs in different places, but I was unable to see them anywhere, so I suspect that I need to turn them on somewhere.
I tried a few things in the my.cnf file, but not much succes.
Any help in getting debugging logs would be appreciated.
Matt
Plesk 8.1.1, FC4, MySQL 4.1.20 -- Fairly standard setup
Problem: I'm not getting all my MySQL logs written into the log file. Just to clarify, I'm looking /var/log/mysqld.log (and /var/log/* in general)
Is there another place place to look for logs? Is there a way to turn on verbose logging for short periods?
The only thing I see in the mysqld.log file is start/stop logging.
What I'm really looking for is the SQL statement logging (SELECT * FROM db_tbl
as well as any other "error" messages (unable to connect, bad password, etcI know that Plesk sometimes put logs in different places, but I was unable to see them anywhere, so I suspect that I need to turn them on somewhere.
I tried a few things in the my.cnf file, but not much succes.
Any help in getting debugging logs would be appreciated.
Matt
