General Community > Scripting Help

Optimize database

(1/3) > >>

Mecha Dude:
I've looked at the --help output for mysql but it dosn't present what I think I need.

What is the command needed to optimize a database?

I plan to make a cron job with this.

Mecha Dude:
Ah I lucked out and found a way:
mysqlcheck -pMYPASSWORD --optimize --databases MYDB

Chris Cromer:
Does that optimize all the tables in the database?

Mecha Dude:
It does, I ran it, then went in and ran the one built into YaBB SE, and clicks was the only one that needed to be optimized (as usuall o.O).

I have it running every 2 hours, yay!

Overseer:
Is that really neccesary?

Navigation

[0] Message Index

[#] Next page