I just spent 30 minutes on a seemingly trivial task. I wanted to see what the JPA is doing to my database so I decided to turn on mysql query logging. It should be simple three step operation:
- Edit my.ini
- add “log=query.log”.
- restart Mysql
Tried it, did not work. I tried to put the my.ini file to all directories that MySQL is suposed to look into (c:\, c:\windows\, install dir). Nothing worked. Finally I checked the MySQL service startup commands and to my surprise there was
–defaults-file=”C:\ProgramData\MySQL\MySQL Server 5.5\my.ini”
I used standard MySQL installation for Windows, installed it as a service so I really do not understand that this is not mentioned in manual. Or I can not read. Anyway after I edited this file and put the “log=query.log” under [mysqld] group, restarted the server and finally the log was created in
c:\ProgramData\MySQL\MySQL Server 5.5\data\query.log