Hi,
Can anyone help me on this:
I have a MYSQL installed on a LINUX server.
My problem is:
The response time to a MYSQL request is sometimes very long (30s).
I have the following logs in file mysqld.log:
020529 14:52:44 22 Connect atos@was02 on
22 Init DB pve
020529 14:52:48 22 Query SHOW VARIABLES
020529 14:53:18 22 Query SELECT A_REU_Identifiant , A_REU_libelle
, A_REU_LibPhonetique , A_REU_Type , A_REU_NUMSIREN , A_UTI_Matricule ,
A_SER_Code , A_REU_Quotite , A_REU_DurMin , A_REU_DurMax ,
A_REU_SoldeInitial , A_REU_SoldeRestant , A_REU_Cout , A_REU_SoldeMin ,
A_REU_Critere1 , A_REU_Critere2 , A_REU_Critere3 , A_REU_Commentaire ,
A_REU_ComPhonetique , A_REU_IndDispo , A_REU_DateDebVal , A_REU_DateFinVal ,
A_REU_DateModification FROM E_REU_RESSOURCEUTILISATEUR WHERE A_REU_NUMSIREN
= '408024719' AND A_UTI_Matricule = '8743' AND A_SER_Code = 'RTTJournee'
020529 14:53:19 22 Query SELECT A_RRU_Reference ,
A_RRU_Reference_Client , A_REU_identifiant , A_UTI_Matricule ,
A_RRU_DateReservation , A_RRU_DateDebRes , A_RRU_DateFinRes ,
A_RRU_DateAnnulation , A_RRU_Statut , A_RRU_Commentaire ,
A_RRU_ComPhonetique , A_RRU_Debit , A_RRU_Attribut1 , A_RRU_Attribut2 ,
A_RRU_Attribut3 , A_RRU_Attribut4 FROM E_RRU_RESERVATIONRESUTI WHERE
A_REU_identifiant = '2296' AND A_UTI_Matricule = '8743'
020529 14:53:49 22 Quit
Here the response time is 35s (14:52:44 to 14:53:19) !
This happens randomly for several tries with the same request.
Regards Julien
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
