BIz Thread: MySQL what exactly does optimizing tables do?
 

Help keep things tidy kinda like dfragging a pc?

yeah, pretty much just like that... if you delete a lot of entries and you optimize its like defragging and its able to reclaim that empty space

yeah, pretty much just like that... if you delete a lot of entries and you optimize its like defragging and its able to reclaim that empty space

It repairs, analyzes and sorts your mysql indexes. Makes things run at their best all the time.

What's with all the biz threads lately? You made a deal with gfy to post more biz threads in exchange for getting unbanned?

:1orglaugh :1orglaugh

so chads not even real?

i am turning back to Juic D of 2001-2003

And this is not a "biz thread" exactly...

It just brings your MySQL indexes up to date. They are stored in your server's memory rather than on the hard disk. If you have a database in which many entries are being altered it is important to repair and optimize on a regular basis. If you don't and you are using INNODB tables they can lock up and be unreadable until you repair and optimize the indexes on that table. This can also cause MySQL to crash.

Can you do that via phpMyAdmin?

Thanks for reminding me... I've got a couple that are about due for a cleanup...

yeah,.. just how do you do this

and can it be a risk..
i.e.. not degragging for years then tring it once can corrupt your hd ?

phpmyadmin you can do it

I don't see it anywhere. ;(

Nevermind, found it. Is there a way to set up a cronjob for this to run once a week or so on all dbs?