MySQL Forums
Forum List  »  Spanish

Re: Habilitar slow query log en MySQL 5.6 sobre Linux
Posted by: Jesús Uzcanga
Date: February 02, 2018 01:49PM

Marco, definiste long_query_time en 10 segundo, eso quiere decir que unicamente consultas que se tarden mas de 10 segundos seran almacenedas en el Slow Query Log.

Prueba bajando ese valor a 1 y lanza alguna consulta que se tarde mas de ese tiempo (usualmente la gran mayoria de las consultas se tardan menos de 1 segundo.

___________________________
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/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Habilitar slow query log en MySQL 5.6 sobre Linux
414
February 02, 2018 01:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.