Search code examples
mysqlmemory-managementauto-increment

database memory wastage after deletion

i have 30 or even more than this tables and all tables have their primary key set to auto-increment so whenever i perform delete operation like deleting 30 records from 10 tables then after deletion 300 memory cells will always remain blank because primary keys are set to auto-increment.So think of this same situation for very large databases,so how to solve this problem and reuse those memory cells again.

Solution

  • Well its auto incremented already so you cant help it.there is no memory wastage in this.