MySQL optimizations nedeed, to resolve overloading server [url removed, login to view] will need to check the logs, and monitor the server to see any problem, and resolve it.
first this mysqltuner recommendations :
Reduce your overall MySQL memory footprint for system stability
Adjust your join queries to always utilize indexes
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
query_cache_size (> 128M)
join_buffer_size (> [url removed, login to view], or always use indexes with joins)
for this warnings:
Up for: 1d 0h 20m 53s
[!!] Maximum possible memory usage: [url removed, login to view] (95% of installed RAM)
!!] Joins performed without indexes: 3043
[!!] Temporary tables created on disk: 29% (501K on disk / 1M total)
[!!] Table cache hit rate: 11% (222 open / 2K opened)
it is also getting some errors, like
[ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/#[url removed, login to view]' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
110310 12:27:05 [Warning] /usr/sbin/mysqld: Forcing close of thread 62940 user: '
From looking at the log at /var/log/messages I see that the server is running out of swap [url removed, login to view] it is just using little swap, but sometimes it goes out of swap.
and for some reason the server becomes unresponsive every day at the same hour .
The security of the server is also [url removed, login to view] day different ips try to login as root, or using ftp. i enabled cPHulk Brute Force Protection, but i think it needs more than that.
installing the CS Firewall was recommended by my host, Softlayer. [url removed, login to view]
21 freelancers are bidding on average $170 for this job
Hello, i´m a system administrator with 10+ years of experience. My knowledge is based in IP communications, Linux and Windows servers, Security and Virtual platforms. You have a PM.
We are a Software Company with staff having over 100 Man years experience in IT Solutions ,Website Design and Web Applications in PHP/MySQL/WordPress with Linux / Windows Server.