Optimize MySQL

You could try running the following script to see the recommendations it provides:

Code:
/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
You need to modify your /etc/my.cnf according to the mysqltuner results.

Next, you can optimize all databases with this command:

Code:
mysqlcheck --auto-repair --check --optimize --all-databases
Restart MySQL after you've done the above:

Code:
/etc/init.d/mysql restart
Please wait 24 hours and then re-run mysqltuner.pl again on the machine to see any other variable changes to make.
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Install mod_pagespeed module cPanel

A custom module for CPanel WHM using CPanel Easy Framework - allows easy installation of...

How to Install mod_geoIP for cPanel

Please do the following steps: # cd /var/cpanel/easy/apache/custom_opt_mods # wget...

Mail Security Tweaks

Cek lokasi pengiriman email terbanyak grep cwd /var/log/exim_mainlog | grep -v /var/spool | awk...

How to create backup Account via SSH?

Step 1: Log-in to the SSH as Root user. Step 2: Enter the following command string on the...

Error shell_exec() has been disabled for security reasons

Warning: shell_exec() has been disabled for security reasons in...