For the first time since the beginning of my long long career, I decided today to use an advice tool to check my MySQL configuration.
I decided to launch pt-variable-advisor and mysqltuner V2 on one of my MySQL server.
Here are the result outputs :
Then I ask myself what to do with these results, just raw results without much explanations, these tools are supposed to be done for beginners…
Just one example from mysqltuner : Too many temporary tables are being written to disk. Increase max_heap_table_size and tmp_table_size If I set the size of my temporary tables at 16Mb, what that’s means, I have to increase to 32Mb, 64Mb or more ?
What is the impact of this change to the memory of my server ?
How can I be sure that the new value that I set is not really too big ?
And another one from pt-variable-advisor : innodb_flush_log_at_trx_commit-1: InnoDB is not configured in strictly ACID mode
Really ? Find me a beginner who knows the ACID properties…
If I know ACID properties, do I really need these advice ?
Two other elements have excited my mind because there is a contradiction between the two tools :
sort_buffer_size parameter :
pt-variable-advisor : The sort_buffer_size variable should generally be left at its default unless an expert determines it is necessary to change it
mysqltuner : Increase query_cache_size — there are too many low memory prunes
I don’t know what you think but if you read some news for the last few years, you know that there are several algorithms to sorting in MySQL and you know that the best query cache tuner is here (even if I’m not to agree with the latter)
So what ?
I am not trying to denigrate these tools, these advice are certainly justified in one way or another.
This is obviously very very complex to achieve this kind of tool.
I just wonder what a beginner can do with such informations ?
And I also wonder if these tools are really useful (for beginners) ?
First of all, I wish you a happy new year.
Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
I hope this enthusiasm will be increased this year, up to you !
To start the year, I propose the MySQL[plus] Awards 2011
It will only take 5 minutes to fill out these polls.
Answer with your heart first and then with your experience with some of these tools or services.
Polls will be closed January 31, so, vote now !
For “other” answers, please, let me a comment with details.
Don’t hesitate to submit proposal for tools or services in the comments.
And, please, share these polls !
Best MySQL GUI client Tool
SQLyog (47%, 85 Votes)
MySQL Workbench (20%, 36 Votes)
HeidiSQL (8%, 14 Votes)
Navicat for MySQL (7%, 12 Votes)
MySQL Administrator / Query browser (6%, 10 Votes)