CI+MySql. How to log long running queries

#1
[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.

#2
[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.

#3
[eluser]Unknown[/eluser]
Thanks for the link.
I think it's the easiest way to do this.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.