MySQL Forums
Forum List  »  Performance

Re: Query slows down over time
Posted by: Rick James
Date: July 16, 2014 11:19AM

It sounds like you have 80GB of stuff to cache, but only 0.15GB of cache (innodb_buffer_pool_size). Increase that setting.

And provide the info I requested.

Options: ReplyQuote


Subject
Views
Written By
Posted
2337
May 28, 2014 09:35AM
1185
May 28, 2014 12:45PM
1032
May 28, 2014 01:24PM
1119
May 28, 2014 04:57PM
1169
May 28, 2014 05:46PM
1110
May 28, 2014 07:23PM
3698
May 29, 2014 05:38AM
1438
May 29, 2014 09:49AM
1280
May 29, 2014 03:12PM
1379
July 15, 2014 12:10PM
1126
July 15, 2014 12:33PM
Re: Query slows down over time
1040
July 16, 2014 11:19AM


Sorry, you can't reply to this topic. It has been closed.

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.