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 much queries, so there is not much to optimize You can add key_buffer_size = 100M long_query_time=0.1 query_cache_size change to 30M table_cache change to 1000 besides that, it'...
-
probably I/O problems
-
I would bet on high I/O so check slow queries in mysql log
-
check if its not exceeding RAM memory available, copy mysqltuner results
-
You need to run it after at least several hours, the best would be 24h, then generate result
-
did you add this long_query_time=0.1 ?
-
please adjust those sort_buffer_size = 256K read_buffer_size = 128K read_rnd_buffer_size = 256K table_open_cache = 2000 thread_concurrency = 8 - remove that add innodb_buffer_pool_size = 300M j...
-
Yep, that was most likely memory issue Now it looks good [OK] Maximum possible memory usage: 346.0M (45% of installed RAM) btw. you are paying for that hostgator vps with cpanel 49.99$ ?
-
based on your current results it seems like you are using VPS with 768MB of memory Is this guaranteed RAM memory ? describe your spec in details I guess that OS is killing your mysql since you are...
-
what do you mean by LA and where do you check it ? please review slow queries, like that : cd /root/install wget