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
http://mysql.rjweb.org/doc.php/staging_table
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


Subject
Views
Written By
Posted
1538
August 21, 2015 08:08AM
Re: Deleted Records and Optimize
709
August 22, 2015 11:13AM
739
September 08, 2015 03:51PM
680
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.