How can I access the mysql query logs in 4.7?

 

I installed mysql through unMenu; and have been using it successfully with XBMC.

 

I also installed digiKam for photo management, that uses mysql databases (one for general, one for thumbnails)

 

For some reason, digiKam takes up to 10 minutes to start up, and then takes about a minute every time I change albums to load thumbnails. I don't have that many pictures in there yet. I want to look into the mysql logs to see what's causing the problem.

 

I would appreciate all help.

 

Thanks

Apparently, in mysql the query logs are turned off by default. (Because the log file gets large very quickly. I can't stress VERY enough) What's recommended is to turn it on, optimize,troubleshoot, etc., then turn it off.

 

You can turn them on by putting this line in your my.cnf under [mysqld]:

 

log=/mnt/cache/.tmp/mysql.log

 

This code will have mysql write the mysql.log to the .tmp folder on your cache drive

 

You can change the location to whatever you like, make sure it is not on the flash drive or the memory as it gets large very quickly.

 

For info on how to edit the my.cnf, see the following post:

 

http://lime-technology.com/forum/index.php?topic=18417.msg167247#msg167247