MySQL Forums
Forum List  »  Performance

Re: Optimize a large MySQL Table
Posted by: Rick James
Date: June 29, 2013 02:58PM

Let's focus on these two things (not OPTIMIZE TABLE):
* performance is poor
* production server runs slower than test server

SHOW VARIABLES LIKE 'innodb%'; -- on both servers
How much RAM on each?
What kind of disk subsystem? (SATA? RAID? etc)
What queries perform poorly?
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies

Options: ReplyQuote


Subject
Views
Written By
Posted
2264
June 24, 2013 12:28AM
1085
June 24, 2013 07:35PM
Re: Optimize a large MySQL Table
1045
June 29, 2013 02:58PM


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.