MySQL Forums
Forum List  »  Performance

Re: Deleted Records and Optimize
Posted by: Rick James
Date: August 22, 2015 11:13AM

I suggest that no action is needed.

Yes, you have only a few rows in 2MB of Data + Index. The 4MB "free" always exists for larger tables; it is not hurting anything.

I suggest that OPTIMIZE TABLE will not speed up anything since your 2MB is probably always in cache (the buffer_pool).

I assume you have set innodb_buffer_pool_size to about 70% of _available_ RAM.

If you were processing rows faster, I would point you to
which discusses what to do if you have a lot more than 40/sec. (It would probably work for your case. It would eliminate the need for OPTIMIZE since does DROP+CREATE.

Options: ReplyQuote

Written By
August 21, 2015 08:08AM
Re: Deleted Records and Optimize
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.