thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
no need, couse they are not damaged they just don't support MyISAM type repair
-
Those tables doesn't support that kind of repair, and probably don't need it, so ignore
-
from command line run mysqlcheck -A --auto-repair or from phpmyadmin repair those tables
-
add to my.cnf innodb_stats_on_metadata=0 syriainv_syriainvestmentmap SELECT count(*) as c FROM visits_stats WHERE service=5 AND ip='5.10.83.97' AND time>=1380292206 AND page=0 AND lang=1\G SELECT...
-
all your values are smaller, only max possible value for key cache increased, so the extra memory is cache/buffers, used only when needed; they can be freed by kernel, when other apps needs RAM yo...
-
add myisam_use_mmap=1 key_buffer_size = 3000M join_buffer_size=4M query_cache_type = 1 query_cache_size = 50M query_cache_limit = 1M table_cache = 3000 thread_cache_size = 50 max_heap_table_si...
-
add query cache query_cache_type = 1 query_cache_size = 30M query_cache_limit = 1M and key_buffer_size = 50M thread_cache_size = 20 the rest is fine
-
OK, 1. It seems like Hyper Threading on R910 is disabled, please enable it, you should have 80 cores each E7 - 4870 got 10 physical cores + 10 virtual (HT) = 20 per CPU, you got 4 CPUs = 80 cores ...
-
Pretty amazing setup, but config very weird, inconsistent, like a copy/paste from many different configs Before optimizing it you need to mention at least : - mysql version (and if you have possib...
-
correct those max_user_connections=75 max_connections=150 key_buffer_size = 150M join_buffer_size = 4M table_definition_cache = 1500 table_open_cache = 2500 sort_buffer_size=256K read_buffer_siz...