Big MyISAM table with 3500 insertions per second behaviour

[Victor Perez Roche]

Hello,

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.

Thnx