Re: Long select time in big tables
Posted by:
Karolis
Date: October 24, 2005 05:36AM
As I am working on this, it appears to me as if the problem is related to the size of a record (row).
If a table has 500.000 small records, selecting random rows will be very fast, however if a table has the same amount of large records (100kb each or so), selecting random rows will be a lot slower.
If this is true, then the problem is probably in the amount of disk seeks MySQL has to do in order to fetch the rows.
I am wondering whether adding more disks for INNODB would speed things up?
thanks,
Karolis
Subject
Views
Written By
Posted
2340
October 24, 2005 01:14AM
1408
October 24, 2005 01:19AM
Re: Long select time in big tables
1321
October 24, 2005 05:36AM
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.