Re: Table as fifo

[Zsolt Kendi]

Engine: MyISAM

Primary key: 1xint(11)
Key: 1xint(11)
Key: 1xdatetime
19 column (including indexes)

Sizes (at the momentan test configutation): Rows:600195, Avg:864, Dl:525383056, Il: 36107264 no more intresting...

EXPLAIN SELECT: at this moment not important because the mysqld slowing down without any query.

bulk_insert_buffer_size: 8388608
innodb_buffer_pool_size: 8388608
innodb_log_buffer_size: 1048576
join_buffer_size: 131072
key_buffer_size: 8
myisam_sort_buffer_size: 8388608
net_buffer_length: 16384
preload_buffer_size: 32768
read_buffer_size: 8200
read_rnd_buffer_size: 8200
sort_buffer_size: 2097144
sql_buffer_result: OFF

One more important: The actual test is just do insert the rows to this table with ~100 row/sec constant speed and purged the oldest records with same speed. Nearly no more operation executed to this table. This operation take away the 50% of one CPU core. If I increase the number off row sleep in the table then cpu usage increase with.
The server is ICore2Duo 3GHz DDR2-800 memory, linux 2.6 kernel 64bit with mysql 5.1 .

Thank you for the help...