Re: CPU usage too low
Posted by:
A R
Date: September 05, 2012 12:22AM
Thanks Rick.
The key_buffer_size is 16777216 in both machines (which have both 4Gb RAM). I notice when running a diff on SHOW VARIABLES that the storage engine for the fast laptop is MyISAM and the slow one InnoDB.
When I run SHOW TABLE STATUS both show an Index_length of 1024.
Other differences that could be relevant: slower laptop has adaptive flushing, have_profiling yes, a innodb_buffer_pool_size of 134217728 (vs 8388608 in the faster one), and a bunch of performance_schema variables absent in the faster one.
Both machines have their swappinness at 60.
I'm unclear about what these variables mean exactly, hopefully it helps.
Subject
Views
Written By
Posted
13193
September 02, 2012 04:52PM
4627
September 03, 2012 01:33PM
Re: CPU usage too low
3292
September 05, 2012 12:22AM
2860
September 05, 2012 03:35AM
2824
September 05, 2012 08:12AM
2516
September 25, 2012 05:20PM
3221
September 25, 2012 05:35PM
2831
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.