CI+MySql. How to log long running queries |
[eluser]Unknown[/eluser]
Hello. Is there a way to globally log long running queries? The average time of execution of my queries is about 0.01-0.1, but sometimes it goes up to 10-15 seconds.
[eluser]Anthony Linton[/eluser]
I believe CI doesn't cover this, but just normal MySQL my.cnf settings and a log file will do the job. Checkout http://www.mydigitallife.info/2007/01/22...-database/ for a guide on doing so.
[eluser]Unknown[/eluser]
Thanks for the link. I think it's the easiest way to do this. |
Welcome Guest, Not a member yet? Register Sign In |