Index in space usage section in MySQL -


i worried index. file size 25mb, when export sql, file size grows 57mb.

does have idea index? , disadvantages?

mysql - spaceusage

it depends on doing. possible index(es) take more (or more) actual data.

you should revise indexes have , whether necessary , used queries, , drop ones not referred anything.

it typical newbie mistake when create lots of indexes every field - can that, waste lot of space needlessly.

while indexes speed searches, many indexes may expensive upkeep, , make updates , inserts slower.


Comments

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

javascript - firefox memory leak -