thinkbot

Total activity 275
Last activity December 07, 2023 02:26
Member since December 06, 2023 17:39

Following 0 users
Followed by 0 users
Votes 0
Subscriptions 67

Comments

Recent activity by thinkbot

run mysqltuner.pl and post results
- View comment
- thinkbot
- April 16, 2014 21:24
- 0 votes
adjust and restart query_cache_size = 150M table_definition_cache = 7000 key_buffer_size=1000M innodb_buffer_pool_size = 1000M remove those: net_buffer_length=8K query_cache_min_r...
- View comment
- thinkbot
- April 16, 2014 21:32
- 0 votes
You need to run mysql for a little bit more time than 1min, as recommendation says "MySQL started within last 24 hours - recommendations may be inaccurate" [--] Up for: 1m 10s (210 q [3.000 qps], ...
- View comment
- thinkbot
- April 22, 2014 22:02
- 0 votes
adjust: max_connections = 100 key_buffer = 25M join_buffer_size = 1M read_buffer_size = 128K sort_buffer_size = 256K table_cache = 6000 thread_cache_size = 100 connect_timeout = 5 query_cache_size...
- View comment
- thinkbot
- April 17, 2014 09:26
- 0 votes
copy here full my.cnf and full mysqltuner.pl result for now you can adjust in my.cnf innodb_buffer_pool_size = 50M innodb_log_buffer_size = 16M and restart service mysql restart
- View comment
- thinkbot
- April 16, 2014 21:35
- 0 votes
check your slow log and review the queries
- View comment
- thinkbot
- April 25, 2014 20:44
- 0 votes
adjust query-cache-type = 1 query-cache-size = 50M
- View comment
- thinkbot
- April 16, 2014 21:55
- 0 votes
MySQL on SSD would be great improvement definitely, but you must remember that SSDs have limited writes
- View comment
- thinkbot
- April 05, 2014 19:58
- 0 votes
run mysqltuner.pl and post the result
- View comment
- thinkbot
- March 31, 2014 13:24
- 0 votes
adjust my.cnf innodb_buffer_pool_size = 800M table_open_cache = 7000 key_buffer_size = 3500M thread_cache_size = 20 then restart
- View comment
- thinkbot
- April 16, 2014 21:44
- 0 votes