var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
How to tell which script is using so many MySQL resources?
I posted this a few days ago but my thread got hijacked.
If I run "top" or "ps -ax" I can see there is huge amount of MySQL activity on my server.
It looks like this -
27936 ? D 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server1.hostago.com.pid --skip-locking
mytop will just tell me what user is using MySQL, which isn't really much use to me.
Is there perhaps a MySQL log which shows which files are making the MySQL calls?
I posted this also in another thread.
You can check mysql to see which user and which database is using resources on your server with this command:
watch -n 1 "uptime; free -m; mysqladmin processlist "
It will show also the time that the database is used, and the insert methods.
It can be an idea to check the database, and after this repair it, because the issue with mysql can be because of some tables that got broken.
Hope this will help you!
Rails in DA
- Ruby on Rails plugin for Directdmin |
- Tomcat Manager plugin for Directdmin
- PostgreSQL plugin for Directdmin |
IP Deny Manager
- IP Deny Manager plugin for Directdmin
- Manager your DirectAdmin server "deeper"
Order now at