|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
21/12/2007, 04h04
|
#1 |
Messages: n/a
Hébergeur: |
Can slow-query-log option only record select statement?
I want to know how to configurate slow-query-log to let it not record the
update sql. I just want to know how the slow select statement ,not the update or insert. Anybody's reply is appreciated,thanks. -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn |
|
|
02/01/2008, 18h15
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Can slow-query-log option only record select statement?
> I want to know how to configurate slow-query-log to let it not record the
> update sql. > I just want to know how the slow select statement ,not the update or insert. > > Anybody's reply is appreciated,thanks. > Sorry, I don't believe you can be that selective about it. You can set the threshold with 'long_query_time' in my.cnf -- but not to ignore updates, etc... Best regards! -- John __________________________________________________ _________________ John Murtari Software Workshop Inc. jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM) http://thebook.com/ |
|
|
|
| Outils de la discussion | |
|
|
