MySQL Forums
Forum List  »  Spanish

Re: Profiler
Posted by: Jesús Uzcanga
Date: April 24, 2018 03:06PM

La unica forma the registrar todo (SELECT, UPDATE, DELETE) lo que se ejecute en un servidor MySQL es activado el "General Query Log" en el servidor, no en el gestor de BBDD.

Para activar ell General Query Log sigue estas instrucciones:

https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log

OJO: Tal como lo indican en ese post, para un servidor con muchas transacciones puede hacer crecer ese archivo mucho muy rapido asi que deben monitorear constantemente para limpiarlo de vez en cuando.

___________________________
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
294
April 12, 2018 12:10PM
Re: Profiler
133
April 24, 2018 03:06PM


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.