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?
Dani
4,064
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Recommended Answers
Jump to Post@Dani
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 …
Jump to PostMySQL's own solution would be my choice.
All 6 Replies
LastMitch
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Dani
4,064
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Dani
4,064
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.