MySQL Performance Tuning and Monitoring Scripts

MySQL Performance Tuning and Monitoring Scripts

Performance Tuning Tools
    1. MySQLTuner: a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

      wget -O

      Advanced Usage :
      Minimal usage remotely
      perl --host targetDNS_IP --user admin_user --pass admin_password
      Usage: Enable maximum output information around MySQL/MariaDb without debugging
      perl --verbose
      perl --buffers --dbstat --idxstat --sysstat --pfstat
      Usage: Enable CVE vulnerabilities check for your MariaDB or MySQL version
      perl --cvefile=vulnerabilities.csv
      Usage: Write your result in a file with information displayed
      perl --outputfile /tmp/result_mysqltuner.txt
      Usage: Write your result in a file without outputting information
      perl --silent --outputfile /tmp/result_mysqltuner.txt
      Usage: Using template model to customize your reporting file based on Text::Template syntax.
      perl --silent --reportfile /tmp/result_mysqltuner.txt --template=/tmp/mymodel.tmpl
      Usage: Enable debugging information
      perl --debug

    2. MySQL Tuning Primer Script - - This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." then attempts to produce some recommendations for tuning server variables.

      Currently it handles recomendations for the following:

        • Slow Query Log
        • Innodb Status
        • Max Connections
        • Worker Threads
        • Key Buffer
        • Query Cache
        • Sort Buffer
        • Joins
        • Temp Tables
        • Table (Open & Definition) Cache
        • Table Locking
        • Table Scans (read_buffer)

    3. mysqlreport: makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.

    4. phpMyAdmin Advisor : This tool is very similar to the tuning-primer tool. Nice and fast, and likely the most up-to-date tool.

Percona Tools for MySQL : Free online productivity tools for MySQL DBAs, SysAdmins and Developers

Performance Monitoring Tools
  1. mytop - a top clone for MySQL.

  2. innotop: you can download the latest version of innotop from Sourceforge.
  3. phpMyAdmin Monitor :

  • MySQL, linux, my.cnf, Percona, performance, MariaDB, InnoDB, Optimization, MyISAM, phpMyAdmin
  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

How to Back Up MySQL Databases From The Command Line

MySQL Databases From The Command Line While automated backups are important, sometimes you just...