It is recommended that every tables in MySQL databases are checked at least once a day on a busy server. but it would be not convenient enough for the database administrator to login to the server everyday or launching other programs to optimize the databases one by one for table by table.
You can Automate the optimization on a Webmin Cpanel by following this...
go to System >> Scheduled Cron Jobs. Then click on Create a new scheduled cron job.
use this commands.
Execute cron job as: root
Active?: YES
Command: mysqlcheck -Aao --auto-repair -u root -p[password]
* no space between -p and the password *
The above command will analyze (-a), optimize (-o), and auto repair (–auto-repair) all (-A) databases on the server. You can set the Simple schedule at the time you prefer, I suggest you look at the traffic log, and choose the period that your server usually receive the least traffic.
-a, --analyze [Analyze given tables]
-o, --optimize [Optimize table]
-A, --all-databases [Check all the database]
--auto-repair [If a checked table is corrupted, automatically fix it. Repairing will be done after all tables have been checked, if corrupted ones were found]
After filling in the whole form, click on Create, and Youre done.
Netiquette describes the rule for online behaviour in newsgroups, forum communities and chatrooms.
Netiquette derived from the two words Internet and etiquette.
Members of an online community usually enforce netiquette and moderators of the community often set the ground rules to use.
Examples of netiquette Rules:
*Respect everyone online. Do not spread rumors or send hateful or harmful messages. Don't use inappropriate and offensive language.
*Think before you type, make sure what you write cannot be misinterpreted. Use emoticons or abbreviations to teasing, convey humor, or other emotions while online.
*Avoid spamming. Chain letters, Unwanted junk mail and jokes can be annoying and time consuming.
*Don't type in all CAPITAL letters. This is considered shouting by the online community.
*Don't be pest and annoy people while online. People may have work to do and can't continue to communicate with you at that particular time.
