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

MZ wrote:
> 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
>
>

it's good practice to reorg your table periodically specifically to
overcome the "gap" problem you're talking about.

as far as phpmyadmin, i am not sure but i think i've seen a button
somewhere to run table optimization commands. maybe ask phpmyadmin folks!

MZ wrote:
> 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

It is the Optimize table option and can be found on the operations tab of
phpmyadmin:
http://dev.mysql.com/doc/refman/5.0/...ize-table.html