Re: At Performance Limit for 2 GB RAM?
Difference between MyISAM and InnoDB
- MyISAM rows is stored in random in the data file, InnoDB has a clusted index on the Primary Key.
This could make some differences in the number of required disk acess.
Since the query is using the Primay key index, InnoDB may have read multiple rows in the same page/block, so it is likely that the next row that is required is already in the memory.
MyISAM needs to read 1 row at a time, each one is likely to require a disk access since the rows are not ordered in any way.
Maybe you can post the EXPLAIN result as well, it can probably show something that can give a better description of what is happening.
Also, the various buffer size allocated to MyISAM and InnoDB may also play a role.
Subject
Views
Written By
Posted
9010
July 20, 2005 09:42AM
3898
July 20, 2005 05:45PM
3482
July 22, 2005 01:33PM
3501
July 22, 2005 02:06PM
3801
July 22, 2005 02:13PM
2996
July 25, 2005 01:40PM
3166
July 26, 2005 03:47PM
Re: At Performance Limit for 2 GB RAM?
2989
July 26, 2005 06:55PM
3132
July 26, 2005 07:06PM
3519
July 27, 2005 09:46AM
3392
July 30, 2005 11:44AM
3635
August 01, 2005 11:18AM
3568
August 04, 2005 07:17PM
4071
August 08, 2005 09:08AM
3159
August 02, 2005 12:59AM
3356
August 08, 2005 09:26AM
3241
August 09, 2005 07:57AM
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.