MySQL Forums
Forum List  »  Performance

Deleted Records and Optimize
Posted by: Luis Cavazos
Date: August 21, 2015 08:08AM

Hi Everyone.

I have a table that constantly receives data about 40 records per second, this records are then process by a program every 5 seconds, the proceced records are deleted, every thing works fine, but I have to run a optimize table every few hours, because it starts to slow down all the proces.

I have noticed that even if the table has only few records for instance 60 the indexes still grow.

Is there any Way to avoid the optimize or make it free space and indexess on delete ?

Show table status results:

Name: indata
Engine: InnoDB
Version: 10
Row_Format: Compact
Rows: 16
Avg_row_Length: 97280
Data_length: 1556480
Max_Data_length: 0
Index_Lenth: 245760
Data_Free: 4194304

Thanks in advance..

Options: ReplyQuote

Written By
Deleted Records and Optimize
August 21, 2015 08:08AM
August 22, 2015 11:13AM
September 08, 2015 03:51PM
September 09, 2015 06:42PM

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.