cPanel Server Management
For 24×7 cPanel Server Management with Monitoring, Unlimited Tech Support, Disaster Recovery, Security updates and much more Signup today!
MySQL Performance Tuning Shell Script, This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…” then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above.
In your huge traffic cPanel server you can use the following MySQL performance tuning script to optimize the mysql performance.
Currently the script handles recommendations for the following:
Slow Query Log
Max Connections
Worker Threads
Memory Usage
Key Buffer
Query Cache
Sort Buffer
Joins
Temp Tables
Table (Open & Definition) Cache
Table Scans (read_buffer)
Table Locking
Innodb Status
Mysql Performance tuning script Installation
Download latest version https://launchpad.net/mysql-tuning-primer
cd /usr/local/src
wget http://cpanelkb.net/download/cpanel-mysql-tuning.sh
chmod 755 cpanel-mysql-tuning.sh
./cpanel-mysql-tuning.sh
Check your mysql performance report now.
cPanel Server Management
AssistanZ is a pioneer in offering 24×7 cPanel Server Management Service since 2004. We offer 24×7 cPanel Server Management
cPanel Server Management
cPanel Installation and Setup
cPanel Server Optimization
cPanel Server Migration
cPanel Server Security and Hardering
cPanel Server Monitoring
cPanel Server Hack Recovery
and Much more
