RE: Monitoring and analysis tool

2007-12-16 Thread Daniel Caune
> -Message d'origine- > De : Mark Leith [mailto:[EMAIL PROTECTED] > Envoyé : dimanche, décembre 16, 2007 04:53 > À : Daniel Caune > Cc : mysql@lists.mysql.com > Objet : Re: Monitoring and analysis tool > > Daniel Caune wrote: > > Hi, > > >

Monitoring and analysis tool

2007-12-15 Thread Daniel Caune
Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in administrating MySQL. We

How to trace statements executed in a procedure called by a client?

2007-06-06 Thread Daniel Caune
Hi, First of all, I would like to apologize if I didn't send my message to the right mailing list. My question is related to MySQL administration, where I don't have any particular experience. I would to trace every SQL statement executed inside a procedure that is called by a client: CREATE PR

MySQL 5, stored procedure, mysql-slow.log

2007-06-05 Thread Daniel Caune
Hi, Is there any configuration to be setup to get each query of a stored procedure, called by a client, in the mysql-slow.log or mysql.log? For the moment, I just have the stored procedure call in the log file, but I need to trace every SQL statement of this stored procedure. # Time: 07060