Removing empty space from database

Removing empty space from database

Let me explain the situation.
Suppose I create a new table with an auto_increment column, and I make 3 new inserts in it.

Table: id, name
1, john
2, Alex
3, jeet

Then I delete the last record and create a new one.
Now, mysql will remove the entry at record id "3", but it will not add the new record at id "3".
The new record will be added at record ID "4".
So table will look like this:

1, john
2, Alex
4, Sam

I am thinking that if lots of deletes happen...

Removing empty space from database WordPress ...