MySQL Forums
Forum List  »  Data Warehouse

Re: Optimizing it even more
Posted by: Rick James
Date: May 28, 2011 10:49PM

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
* EXPLAIN PARTITIONS SELECT ... \G -- to see which PARTITIONs it picked
* 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
6206
May 27, 2011 06:14AM
Re: Optimizing it even more
3037
May 28, 2011 10:49PM
2568
May 30, 2011 08:57AM
2855
May 30, 2011 07:15PM
2899
May 31, 2011 10:09AM
2861
May 31, 2011 08:53PM
2924
June 01, 2011 08:42AM
3099
June 01, 2011 09:15AM
2955
June 02, 2011 02:13AM


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.