MySQL Forums
Forum List  »  InnoDB

Re: Incredible slow down... Why?
Posted by: Rick James
Date: September 07, 2014 10:43AM

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

Options: ReplyQuote


Subject
Views
Written By
Posted
1608
September 05, 2014 05:25AM
807
September 05, 2014 02:43PM
Re: Incredible slow down... Why?
810
September 07, 2014 10:43AM
882
September 08, 2014 07:37AM
988
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.