thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Activity overview
Latest activity by thinkbot-
thinkbot commented,
can you run mysqltuner.pl and post the output plus, add contents of my.cnf [COLOR="silver">- - - Updated - - - innodb_buffer_pool_size= 2.5G max_connections = 400 sort_buffer_size=256K read_buff...
-
thinkbot commented,
you set innodb_buffer_pool_size to 2G you can set it higher to 3G - this one variable in your case makes huge difference unfortunately it would be better if you went with 64-bit system, but you c...
-
thinkbot commented,
adjust max_connections=100 key_buffer = 30M join_buffer_size = 512K read_buffer_size = 128K sort_buffer_size = 256K read_rnd_buffer_size = 128K record_buffer = 1M - remove that add innodb_buf...
-
thinkbot commented,
2 basics in your case that will make huge difference: table_cache = 2048 innodb_buffer_pool_size = 900M and modify query_cache_size = 50M then restart
-
thinkbot commented,
Yes sorry use table_cache instead of table_cache_size in newer versions its table_cache_size
-
thinkbot commented,
can you copy your my.cnf here ?
-
thinkbot commented,
add this in my.cnf under [mysqld] query_cache_type = 1 query_cache_size = 30M table_cache_size = 1000 thread_cache_size = 20 join_buffer_size = 512K
-
thinkbot commented,
run mysqltuner.pl and post the result
-
thinkbot commented,
it would be better to copy more content here Make sure there are idexes on sl_id in scan_list2 table and 1 index containing 2 columns (sl_ss, sl_id) you can show us the result of those queries (y...
-
thinkbot commented,
mysqltuner.pl not tuning-primer anyway adjust: thread_cache_size = 200 max_connections = 500 sort_buffer_size = 256K read_rnd_buffer_size = 256K read_buffer_size=128K join_buffer_size=2M table_def...