MySQL server compacting Hello!
I have heard lately that when sb has very big mysql database and call delete
sql query many times on this database it generates many gaps in database.
That`s why database store a big space on hardware and can work lower. Is it
true?
Moreover, I have heard that in this case there is a need to compact database
(from time to time) to fill/remove gaps and this will make such database
more efficient. How to do that in phpmyadmin? Is it a thing which has to be
done by admins? Should I do it by myself? If so, how can I do this in
phpmyadmin? Should I take care for some things - which then?
Thank you a lot
Marcin |