Hi,
I have a noticed the following behavior...
when the DB is clean and fresh... our DB handles a very high rate of inserts (~1200 per second), butwith time, when the datafile (think thats the reason but might be any other thing... maybe indexes?) increases - the rate is going down. Right now the rate of inserts per second is around 500 per second (around 40% from the starting rate).
Does anyone has any idea why is that happen? How can I solve that problem?
Thanks,
Ori Raz

Is your data being inserted in order? Do you need to occasionally reorg the object?
Dave

Thanks for the fast reply...
but in both cases my answer will be negative...
I insert the data with regular insert - no ordering.
There is no reorg on the object
once in a while (user request) there is a query to get info from table, but even without it the rate is going down...
Thanks,
Ori

Hi !
What version of MySQL are you using , and what Storage Engine ?
Is it possible to post an EXPLAIN and if possible a SHOW PROFILE ALL of your queries ?

Thanks !