MySQL Forums
Forum List  »  Newbie

Re: Need help in purging MySql DataBase
Posted by: Rick James
Date: June 23, 2016 07:15PM

A table that is growing does not necessarily slow down.

With good queries and indexes, the queries should not slow down.

Without useful indexes, the queries can slow down and resources can be stolen. Furthermore, throwing hardware is unlikely to solve the problem

Please provide
* The query that is hogging the machine.
* SHOW CREATE TABLE for the table(s) involved.
* EXPLAIN SELECT ... for that query
* How much RAM? What is the value of innodb_buffer_pool_size?

After that we can discuss
* Better indexes
* Better formulation of queries
* PARTITIONing as a way of easy pruning 'old' data
* etc.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need help in purging MySql DataBase
June 23, 2016 07:15PM


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.