MySQL Forums
Forum List  »  MySQL Administrator

MyISAM performance - reg
Posted by: suvendu mohapatra
Date: December 31, 2011 01:49AM

Hello,

I would like to ask that can mysql handle 25,00,000 records of avg. size 200KB in one table. My table type is myisam.
How to increase the table scan performance. I have tried with options like read_buffer_size and read_rnd_buffer_size. But it is taking around 3 minutes for 1,50,000 records.

Also kindly suggest the best and fastest way to take backup of the full table.
Everyday the size of the table increased by 1.5GB.

Options: ReplyQuote


Subject
Written By
Posted
MyISAM performance - reg
December 31, 2011 01:49AM


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.