thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
remove this from your my.cnf safe-show-database its probably the reason why its not starting
-
The results of mysqltuner informes about completely different variables than your my.cnf
-
It seems like you didnt restart mysql after changing my.cnf so restart mysql now, and later generate mysqltuner.pl again and to your current config add innodb_buffer_pool_size = 300M
-
yes, you can also lower long_query_time to 0.2 to get more slow queries to review
-
innodb_buffer_pool_size = 200M key_buffer_size = 500M query_cache_size = 50M table_cache = 6000 [!!] Joins performed without indexes: 258302 based on that we can say that there are many non optim...
-
new my.cnf [mysqld] innodb_file_per_table=1 bind-address=127.0.0.1 local-infile=0 key_buffer_size = 50M query_cache_type = 1 query_cache_size = 50M query_cache_limit = 1M thread_cache_size = 32 t...
-
are you sure its correct ? FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO) gmake: *** [test_dynamic] Error 255 above you tried running mysql...
-
its becouse you didnt provide corret mysql root and pass you can create a file /root/.my.cnf with content [client] user=root password=mysql_pass and rerun mysqltuner and mysqlmonlite again
-
Please run mysqltuner It gives better info in your case
-
run mysqltuner and post results