Welcome Guest, Not a member yet? Register   Sign In
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.




Theme © iAndrew 2016 - Forum software by © MyBB