MySQL Forums
Forum List  »  InnoDB

Re: Incredible slow down... Why?
Posted by: Rick James
Date: September 08, 2014 09:56AM

> Someone sudjest me to go to schema inspector -> Maintenance -> Optimize tables.

I'm disagreeing with that suggestion. Instead, slow queries are bets handled by finding and fixing the root cause.

> I want to put a button into maintenance menu that performs this.

Even if there were a button, it would quickly stop being of any use.

To explain...
OPTIMIZE TABLE removes some or all of the wasted space in a table. This is like "defragmenting". Even if this improves performance (which is unlikely), the table is now cleaned up and is unlikely to be messed up again for some time. A second OPTIMIZE would not find much to clean up, hence would not be of much help.

I don't think a Stored Procedure can run OPTIMIZE, so I don't thing that would provide a way to get a "button". The other choice is to have a script (in shell, Perl, etc) that performs the function, then you execute the script.

Options: ReplyQuote


Subject
Views
Written By
Posted
1608
September 05, 2014 05:25AM
807
September 05, 2014 02:43PM
810
September 07, 2014 10:43AM
882
September 08, 2014 07:37AM
Re: Incredible slow down... Why?
987
September 08, 2014 09:56AM
850
September 09, 2014 01:58AM


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.