MySQL Forums
Forum List  »  Performance

Each morning some SQLs are very slow
Posted by: lisheng1 zhang1
Date: May 08, 2017 03:43PM

We are using mySQL 5.5 and move to 5.7 gradually. Recently we found one problem in both 5.5 and 5.7:

In each morning we found some SQLs are rather slow (take close to a minute, typically SQLs with "LIKE '%<sth>%'" or fulltext search), later if we perform same or similar SQLs again (even with SQL_NO_CACHE), the performance is OK (within 10s). What is the cause for this initial slowness (as if mySQL periodically needs to recreate some cache)?

This happened in both 5.5 and 5.7, but we are more concerned about 5.7.

Really appreciate if you could shed some lights on this issue and suggest how to avoid the initial slowness?

Options: ReplyQuote


Subject
Views
Written By
Posted
Each morning some SQLs are very slow
108
May 08, 2017 03:43PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.