INNODB Engine with
innodb_table_per_file , so every table has it's own
.ibd file instead of ibdata1 file.
When i Entered 512 Record in my users table its size get increased to 200kb from 96 kb but when I deleted all rows using Command
DELETE FROM USERS;
.ibd file didn't reduce not even by a single byte.
BUT When i delete rows using command
TRUNCATE TABLE USERS
.ibd file got reduced to it's initial size which was on creation that is 96 kb.
Now i Want to know that is here any way to reduce
.ibd files when i use
DELETE FROM USERS WHERE ... command