MySQL Forums :: InnoDB :: mysql very slow after million insert/delete


Advanced Search

mysql very slow after million insert/delete
Posted by: riccardo roasio ()
Date: February 09, 2009 08:27AM

Hi,

i have a mysql innodb database on which i need to made a lot of insert and delete (like 8 million/day).

I notice that after some time mysql seems to became very slow.

If i run an 'optimaze table' on it all return normal.

There is a way to solve this problem?


Thanks in advance,
Riccardo

Options: ReplyQuote


Subject Views Written By Posted
mysql very slow after million insert/delete 8341 riccardo roasio 02/09/2009 08:27AM
Re: mysql very slow after million insert/delete 3587 Rick James 02/11/2009 12:49AM
Re: mysql very slow after million insert/delete 4728 riccardo roasio 02/11/2009 02:32AM
Re: mysql very slow after million insert/delete 3651 Rick James 02/13/2009 12:07AM
Re: mysql very slow after million insert/delete 3147 riccardo roasio 02/13/2009 03:25AM
Re: mysql very slow after million insert/delete 3471 Rick James 02/19/2009 01:39AM
Re: mysql very slow after million insert/delete 3059 riccardo roasio 02/20/2009 05:22AM
Re: mysql very slow after million insert/delete 2637 aftab khan 02/23/2009 09:03AM


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.