Re: Determine time taken by commit statement after insert or update statement

[Jesús Uzcanga]

Hey Priya.

You can activate the slow query log

In you my.ini or my.cnf configuration file:

[mysqld]
slow_query_log = 1
slow_query_log_file =/var/log/mysql-slow-query.log
long_query_time=1

where long_query_time is the time required for any script to be looged... If you set that value in zero it will log everything.

___________________________
Ing. Jesús Alfredo Uzcanga
Twitter: @JesusUzcanga

We learn the 20% of what we HEAR,
the 50% of what we SEE,
the 80% of what we DO and
the 95% of what we TEACH.

____________________________________________________________
https://www.linkedin.com/in/jauzcanga/