zmej.org.ua - Памятки системного администратора.

Сегодня в Интернете наткнулся на замечательный скрипт, который показывает общие настройки по серверу MySQL. Называется этот скрипт mysqltuner.pl

Скачать его можно вот по этой ссылке.

Запуск его тоже очень просто:

perl ./mysqltuner.pl

И мой результат на тестовой машинке:

#perl ./mysqltuner.pl

 

 >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>

 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/

 >>  Run with '--help' for additional options and output filtering

Please enter your MySQL administrative login: root

Please enter your MySQL administrative password:

 

-------- General Statistics --------------------------------------------------

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.0.90-log

[OK] Operating on 32-bit architecture with less than 2GB RAM

 

-------- Storage Engine Statistics -------------------------------------------

[--] Status: -Archive +BDB -Federated +InnoDB -ISAM -NDBCluster

[!!] InnoDB is enabled but isn't being used

[!!] BDB is enabled but isn't being used

[OK] Total fragmented tables: 0

 

-------- Security Recommendations  -------------------------------------------

[OK] All database users have passwords assigned

 

-------- Performance Metrics -------------------------------------------------

[--] Up for: 8h 16m 13s (9 q [0.000 qps], 7 conn, TX: 7K, RX: 557)

[--] Reads / Writes: 100% / 0%

[--] Total buffers: 298.0M global + 6.3M per thread (100 max threads)

[!!] Maximum possible memory usage: 929.2M (91% of installed RAM)

[OK] Slow queries: 0% (0/9)

[OK] Highest usage of available connections: 1% (1/100)

[OK] Key buffer size / total MyISAM indexes: 256.0M/66.0K

[!!] Query cache efficiency: 0.0% (0 cached / 4 selects)

[OK] Query cache prunes per day: 0

[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)

[OK] Thread cache hit rate: 85% (1 created / 7 connections)

[OK] Table cache hit rate: 50% (6 open / 12 opened)

[OK] Open file limit used: 0% (14/11K)

[OK] Table locks acquired immediately: 100% (12 immediate / 12 locks)

[!!] Connections aborted: 28%

 

-------- Recommendations -----------------------------------------------------

General recommendations:

    Add skip-innodb to MySQL configuration to disable InnoDB

    Add skip-bdb to MySQL configuration to disable BDB

    MySQL started within last 24 hours - recommendations may be inaccurate

    Reduce your overall MySQL memory footprint for system stability

    Enable the slow query log to troubleshoot bad queries

    Your applications are not closing MySQL connections properly

Variables to adjust:

  *** MySQL's maximum memory usage is dangerously high ***

  *** Add RAM before increasing MySQL buffer variables ***

    query_cache_limit (> 1M, or use smaller result sets)