thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
Get pt-query-digest to review queries cd /root wget
-
Great, [OK] Maximum possible memory usage: 508.5M (25% of installed RAM) you can also post again all your "My Server Details" exactly "free -m" Another thing to do is optimizing your queries "...
-
No need to add more, you just need to optimize the settings a bit: [mysqld] skip-name-resolve local-infile=0 default-storage-engine=MyISAM max_connections = 100 max_user_connections = 50 max_con...
-
Correct those: key_buffer = 2G # for the future, we set it higher, normally in your case minimum 315 M, higher then MyISAM indexes size net_buffer_length = 1M - remove that line join_buffer_size...
-
[mysqld] back_log = 100 #skip-innodb max_connections = 400 wait_timeout = 120 interactive_timeout = 60 connect_timeout = 2 key_buffer_size = 1500M myisam_sort_buffer_size = 256M myisam_max_sort_...
-
still mysqltuner results missing and what hdd you have it provides most of the improtant information in one place
-
Copy your current my.cnf, exact server spec, what kind of scripts you got on the server (custom or some CMS), and mysqltuner.pl result
-
Update those: key-buffer-size = 45M # CACHES AND LIMITS # query-cache-type = 1 query-cache-size = 30M max-connections = 200 table-definit...
-
[quote="uprising, post: 1491171">I will pay $5 per server dude :| you have missed at least one 0 few tips #1 - lower max connections number [OK] Highest usage of available connections: 3% (70/200...
-
enable php display_errors and display_startup_errors, if you got 500 error you should have entry in logs anyways