MySQL Forums
Forum List  »  Performance

Re: CPU usage too low
Posted by: Rick James
Date: September 05, 2012 08:12AM

> engine for the fast laptop is MyISAM and the slow one InnoDB.

That does not mean that the tables are using different engines -- it depends on how you transferred the data. SHOW CREATE TABLE.

key_buffer_size = 16M -- much too small for MyISAM. See
http://mysql.rjweb.org/doc.php/memory

> innodb_buffer_pool_size of 134217728

That's merely wasting RAM if you are only using MyISAM. It's too small for a 4GB machine if you are using InnoDB.

> When I run SHOW TABLE STATUS both show an Index_length of 1024.

Please provide the output.

SHOW VARIABLES LIKE 'innodb%';
In particular, innodb_flush_log_at_trx_commit is probably set to a 'safe' 1 instead of a 'faster' 2. "1" causes a lot more I/O if you have small transactions.

Options: ReplyQuote


Subject
Views
Written By
Posted
13154
A R
September 02, 2012 04:52PM
4616
September 03, 2012 01:33PM
3280
A R
September 05, 2012 12:22AM
2851
September 05, 2012 03:35AM
Re: CPU usage too low
2813
September 05, 2012 08:12AM
2506
A R
September 25, 2012 05:20PM
3212
A R
September 25, 2012 05:35PM
2820
October 01, 2012 11:49PM


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.