Re: Reduce Index space
Posted by:
Rick James
Date: January 20, 2009 02:12AM
SHOW INNODB STATUS;
gives you some cryptic information, probably including how full the pool is at the moment.
The better way to judge whether you have enough RAM is to see how busy the disk is. If all the data+index will fit into cache, SELECTs won't hit the disk (once it is all cached). At the other extreme, repeated table scans of a big table will repeatedly clobber the cache. Random access is in between -- a combination of cache:disk ratio and frequency of random SELECTs.
Subject
Views
Written By
Posted
3837
January 19, 2009 11:04PM
1855
January 19, 2009 11:56PM
1863
January 20, 2009 12:58AM
Re: Reduce Index space
1741
January 20, 2009 02:12AM
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.