MySQL Forums
Forum List  »  MyISAM

Re: Myisam as the correct choice?
Posted by: Rick James
Date: May 17, 2011 11:22PM

> 204MB on disk -- that's small.
> 1GB of RAM -- that's tiny.
> Every hour tables get updated with hundreds... -- yawn! (Hundreds per _second_ gets exciting.)
> high CPU usage -- poorly optimized queries and/or missing indexes.

Nothing you say says that you must use one Engine or the other.

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 ]

If you choose to convert to InnoDB, read
http://mysql.rjweb.org/doc.php/myisam2innodb

Read this for memory allocation, but shrink down the values a bunch, since it was not written for "tiny" machines:
http://mysql.rjweb.org/doc.php/memory

Options: ReplyQuote


Subject
Views
Written By
Posted
3389
April 29, 2011 07:50PM
1677
April 30, 2011 10:34PM
Re: Myisam as the correct choice?
1382
May 17, 2011 11:22PM


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.