Is there any way to set the long_query_time for the slow query log to less than < 1s? We consider anything over 0.5s something wrong. Or can you recommend any MySQL monitoring software that can handle a super high load without a super amount of storage space?
Featured Replies in this Discussion
@Dani ... You want ot set the ... to less than .5 second? I never seen less than .5 second before. I have a feeling you done this already but I'm not sure: You need to edit this file called: my.cnf You can edit: ... For sql you should use time in sec: ... I got that from here: ... Regardin about a MySQL monitoring software. You can try this: ... It's a freeware unless…
Is there any way to set the long_query_time for the slow query log to less than < 1s?
You want ot set the long_query_time to less than .5 second? I never seen less than .5 second before.
I have a feeling you done this already but I'm not sure:
Well, then no Zend. There must be free or open tools available to check the slow query log files. Never used any other than grep personally.
From the MySQL manual:
5.2.5. The Slow Query Log
The slow query log consists of SQL statements that took more than long_query_time seconds to execute and required at least min_examined_row_limit rows to be examined. The minimum and default values of long_query_time are 0 and 10, respectively. The value can be specified to a resolution of microseconds. For logging to a file, times are written including the microseconds part. For logging to tables, only integer times are written; the microseconds part is ignored.
Isn't it about time forums rewarded their contributors?
Earn rewards points for helping others. Gain kudos. Cash out. Get better answers yourself.
It's as simple as contributing editorial or replying to discussions labeled
OP Sponsor or