mysql database have larger size

Question

I have a database and that contain many tables , but all of them store text and full tables size is less than 10 MB , but the database file on server have larger than 1 GB

The tables uses MyIASM , where is the problem ?

thanks

Which database file? is it ibdata1? Do you have any InnoDB tables? Did you have any such tables before and have you deleted them? If so, have a look here: stackoverflow.com/questions/3456159/… — Jeremy Smyth
– Jeremy Smyth, Commented Aug 29, 2013 at 10:03
@Ata maybe you should look if you can keep the TEXT datatype in one table. table fragmentation is caused by deleting/updating from table that have non fixed sizes like varchar / text columns. — Raymond Nijland
– Raymond Nijland, Commented Sep 20, 2013 at 18:36

Community · Accepted Answer · 2017-05-23 12:21:31Z

2

You can use OPTIMIZE TABLE for reducing disk usage on MyISAM tables (usually after deleting lot of data from them or doing major changes in structure).

For InnoDB, that is quite more challenging, see Howto: Clean a mysql InnoDB storage engine?

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Aug 29, 2013 at 12:20

Michal Čihař

10.1k6 gold badges54 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

mysql database have larger size

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related