MySQLTuner - A commandline mysql tuner tool to assess your MySQL config
MySQLTuner
A commandline mysql tuner tool to assess your MySQL config
Screenshots
Hunter's comment
If you have one or more MySQL installations, it's a very good idea to check your configuration settings using some best practice checks.
The MySQLTuner script assesses your MySQL installation and then outputs suggestions for increasing your server’s performance and stability.
Installation is a breeze;
Download the script:
wget http://mysqltuner.com/mysqltuner.pl
Make it executable:
chmod +x mysqltuner.pl
The run it, you'll be prompted for your mysql password;
./mysqltuner.pl
It will return output similar to this; 
snip output
At the bottom you'll see the recommendations for your installation, try them, let them run for a while then rerun the tool.
Enjoy!
Link
This is posted on Steemhunt - A place where you can dig products and earn STEEM.
View on Steemhunt.com
This tool will be much helpful for both experienced programmers and those who are yet learning. But I think it will help new people more as they will be getting recommendations. Its a good practice to check those recommendations and apply as well for better code.
YOU ARE VERIFIED.
remember to hunt really your best finds on the web, we want the site to be fully of quality awesome products that people will love!
some power tips for the next hunt.. .
Awesome, bad configuration will have an impact on the security of the database itself, this MySQL tuner provides recommendations that are needed by developers for best security checks.
Really it is a very useful tool to optimize the performance of MySQL. It makes the job easier and makes it easier to understand the effects of each variable. It allows you to visualize the overall use of memory, the use of memory per thread and the maximum possible use of memory - it is really valuable and complex information to calculate!
This is a great way to make your server is optimized. simple and easy to use. Good hunt
Congratulations @dfroberg! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
Click here to view your Board
If you no longer want to receive notifications, reply to this comment with the word
STOPTo support your work, I also upvoted your post!