thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
you dont have to increase all the values recommended by this script, those are only pointers, you need to understand the impact of the change before making the actuall change Please review your sl...
-
this particular query should be immediate, probably query before that one took longer than wait_timeout allowed checkout slow query log
-
Hey, this is not an issue, you got 239 MyiSAM tables, they all fit in table_open_cache 700 buffer, there are also some temporary tables created along the way It's very good
-
There is nothing to adjust now, it just tells you that your maximum memory usage for MySQL can be 201.6M, meaning 7% of installed RAM previously it was 786.1MB [OK] Maximum possible memory usage: ...
-
replace my.cnf with this [mysqld] default-storage-engine = MyISAM local-infile = 0 max_connections = 50 wait_timeout = 30 connect_timeout = 10 thread_cache_size = 16 table_open_cache = 700 key_...
-
First please rerun mysqltuner.pl and post results here
-
You should install something more reliable for server monitoring, like munin plugin in WHM Process Manager is very basic tool for showing server utilization
-
If your all innodb databases are not used, so they will probably fit in memory MyiSAM tables all fits in buffers now, so they will work very fast You should install munin plugin for WHM to have mo...
-
You have too little RAM memory to fit main buffers replace your my.cnf with this [mysqld] skip-name-resolve myisam_use_mmap=1 max_connections = 100 max_user_connections = 50 join_buffer_size=5...
-
you can increase 2 main buffers for the future when data grows key_buffer_size = 5G innodb_buffer_pool_size = 5G except that, nothing much else to do if you can't optimize the queries anyway curr...