MySQLTuner, it is best to have some understanding of the process. Even when following the instructions of programs such as When altering the MySQL configuration, be alert to the changes and how they affect your database. If you are wary about updating your database on your own, following MySQLTuner’s suggestions is one of the safer ways to improve your database performance.
#Workbench mysql optimizer how to
Query_cache_limit (> 1M, or use smaller result sets)MySQLTuner offers suggestions regarding how to better the database’s performance. Run OPTIMIZE TABLE to defragment tables for better performanceĮnable the slow query log to troubleshoot bad queries
InnoDB buffer pool / data size: 128.0M/1.2M Table locks acquired immediately: 100% (62 immediate / 62 locks) Table cache hit rate: 24% (52 open / 215 opened) Thread cache hit rate: 97% (1 created / 42 connections)
Temporary tables created on disk: 25% (54 on disk / 213 total) Query cache efficiency: 0.0% (0 cached / 71 selects) Key buffer size / total MyISAM indexes: 16.0M/99.0K Highest usage of available connections: 0% (1/151) Maximum possible memory usage: 597.8M (60% of installed RAM) Total buffers: 192.0M global + 2.7M per thread (151 max threads) All database users have passwords assigned Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM Currently running supported MySQL version 5.5.41-0+wheezy1 Please enter your MySQL administrative password: Please enter your MySQL administrative login: root > Run with '-help' for additional options and output filtering > Bug reports, feature requests, and downloads at The script will return results similar to the output below: You will be prompted to enter in your MySQL administrative login and password.
MySQLTuner script assesses your MySQL installation, and then outputs suggestions for increasing your server’s performance and stability.Ĭhange the scripts permissions to be executable: chmod +x Ps -eo pcpu,pid,user,args | sort -k 1 -r | head -20 At the very least, you should familiarize yourself with the RAM and CPU usage of your server, which can be discovered with these commands: echo & ps aux | awk '' | sort -k2rn | head -n 20 In order to determine if your MySQL database needs to be reconfigured, it is best to look at how your resources are performing now. For more information on privileges see our Be sure to run the steps below as root or with the sudo prefix. The steps in this guide require root privileges.
0 kommentar(er)
