Records deleted but the size of the table doesn't change

Question

I have a MySql table (MyISAM) with 25.000 records and 1.8 MB size.
The structure of the table is like this

CREATE TABLE `t_prs_info` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `exam_kod` MEDIUMINT(10) UNSIGNED NOT NULL, `mss` SMALLINT(5) UNSIGNED NOT NULL, `grp` VARCHAR(3) NOT NULL, `class` VARCHAR(2) NOT NULL, `gp` VARCHAR(1) NOT NULL, `vrnt` VARCHAR(1) NOT NULL, `xdil` VARCHAR(3) NOT NULL, `cns` VARCHAR(1) NOT NULL, `name` VARCHAR(14) NOT NULL, `surname` VARCHAR(14) NOT NULL, `cl_kod` VARCHAR(10) NOT NULL, `prs_kod` VARCHAR(10) NOT NULL, `phone` VARCHAR(10) NOT NULL, PRIMARY KEY (`id`))

When I try to execute SQL command to delete some rows

DELETE FROM t_pers_info WHERE exam_kod=1000

it deletes the records but the size of the table doesn't change.

please restart your pc and then check

sam_13
– sam_13

2012-03-07 11:45:42 +00:00
Commented Mar 7, 2012 at 11:45 — sam_13
– sam_13, Commented Mar 7, 2012 at 11:45

triclosan · Accepted Answer · 2012-03-07 11:41:00Z

1

try to do

OPTIMIZE TABLE `t_prs_info`

after deleting

answered Mar 7, 2012 at 11:41

triclosan

5,7746 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrey Frolov · Accepted Answer · 2012-03-07 11:41:03Z

1

Try to optimize your table http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

answered Mar 7, 2012 at 11:41

Andrey Frolov

1,53410 silver badges20 bronze badges

Collectives™ on Stack Overflow

Records deleted but the size of the table doesn't change

2 Answers 2

Comments

Comments

Hot Network Questions