MySQL Forums
Forum List  »  Optimizer & Parser

Re: Speed problem
Posted by: Rick James
Date: August 27, 2010 08:03AM

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 -- Suspect this the most.
and surround them with [ code ] and [ / code ]

"then it is flashing" -- ?

Options: ReplyQuote

Written By
August 25, 2010 03:33AM
Re: Speed problem
August 27, 2010 08:03AM

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.