How to optimize MySQL automatically in CentOS Linux | |||
| |||
I am using CentOS Linux for service purpose. Main reason to use CentOS is cheaper hosting for private purpose. Actually MySQL requires periodical optimization process in my experiences, and I use /etc/cron.hourly usually for those kind of bath processing. I made 'koptimize' file with permission 0755.
Please type as below with database ID, and Password can perform optimization. It may require administrator permission or something similar with that.
After storing above file, you need to change file permission for automatic execution as below.
Eventually koptimize file will be executed hourly. Tags: CentOS bash cron db autorepair httpd metaWeblog API file attachment mysqlcheck mysqld timeout | |||
| |||
| |||
Login for comment |
SIMILAR POSTS Apache server unstable detection and the related server(mysql, apache) restart automatically |
OTHER POSTS IN THE SAME CATEGORY Network diagnostic tool for IPv4/IPv6 - traceroute/traceroute6 |