![]() ![]() Query_cache_limit (> 1M, or use smaller result sets) 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. The 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 This can be done with the top command or with the Linode Longview service. 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 Users and Groups guide. Be sure to run the steps below as root or with the sudo prefix. The steps in this guide require root privileges. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |