MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Split big MyISAM tables to small ones, but performance is worse
Posted by: wei huiling
Date: August 12, 2008 09:50PM

I have a big table in MyISAM storage with 25m records. The table is frequently update, to reduce the value of Table_locks_waited, I split this big table into 10 small ones according to the user ID: t1, t2...t10. Each table has the same format, and only the data are also similar. Each small table has 2.5M records, the storage engine is also MyISAM. There are no other tables using MyISAM in my database.

I tested with two threads: thread1, thread2.

1. Both thread1 and thread2 read data from table t1, the average response time is 140ms.
2. Thread1 read data from table t1, thread2 reads data from table t2, the average response time is 340ms.

Do I need special configuration on it?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Split big MyISAM tables to small ones, but performance is worse
5932
wei huiling
August 12, 2008 09:50PM
Re: Split big MyISAM tables to small ones, but performance is worse
2660
Rick James
August 30, 2008 12:54AM


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.