MySQL Forums
Forum List  »  Optimizer & Parser

Big MyISAM table with 3500 insertions per second behaviour
Posted by: Victor Perez Roche
Date: February 20, 2006 07:55AM


I've a MyISAM with +3500 insertions per second, each row with aprox. 20 numeric fields. I've too 4 index with some aggregations.

I insert into the table data from a server that receives UDP packets, with a C program and mysql_real_query(...); sentence. I've tunned the key_buffer_size from 8Mb to 128 Mb. I use INSERT DELAYED against other server to avoid lost of data, but when the table data raises 400 Mb (aprox) and the index length raises is 280 Mb aprox, the server becomes to have "periodic sleep times" between 1000 and 1000 insertions (aprox)

I notice that the problem is related with the index, but i dont know how to solve. I've tried to increase the key_buffer_size, but the problem still remains.


Options: ReplyQuote

Written By
Big MyISAM table with 3500 insertions per second behaviour
February 20, 2006 07:55AM

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.