very proffesional Database Adminstration, MySQL to stop my website from keep going down
$10-100 USD
Completed
Posted over 9 years ago
$10-100 USD
Paid on delivery
i am looking for very professional database administration & MySQL who can solve the problems in very short time, my website keep going down you should tweak the PHP codes such that no too PHP process should run for
long time or force them to disconnect as soon as they don't need to access the
database anymore. As per my observation, many PHP processes was taking high load
which was almost near to 99-100%. It could have been because of the more sleep
queries. As per my previous experience with other MySQL servers, in servers where
there are high sleep queries, the SQL server will get unstable. Hence feel free to
tweak the PHP file which makes connection with MySQL/databases."
this is one example on 1 online user which take long long time while he finish his work in 3 min
23399 bigfish 20 0 191m 56m 29m R 99.6 2.7 0:18.90 /usr/bin/php
or It could be of many reasons.. May be an abusive code snippet or else. In the
same time, my website is making high number of MySQL queries too. Please see
5486 | bigfish_user | localhost | bigfish_db | Sleep | 5 |
As you can see, you need to be professional to solve this issue