MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizer struggling with smaller dataset
Posted by: Rick James
Date: April 02, 2010 11:19PM

There's a dozen possible answers. Rather than trying to enumerate them, 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 ]

Options: ReplyQuote

Written By
Re: Optimizer struggling with smaller dataset
April 02, 2010 11:19PM

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.