for example, right now i have 4 mysql servers running, and this is what my process list looks like.
they're not all running that intensively, so i'm not sure why they're all trying to hog as much CPU as possible. (yes, they're all pointing to separate datadirs, socket files, port numbers, etc. - the config hasn't changed since a properly running version in the past)
mysql 634 29.9 0.7 45676 16400 ? Sl Jun15 5517:59 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys
mysql 640 41.7 1.2 52836 26696 ? Sl Jun15 7693:42 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys
mysql 647 13.6 1.0 69316 21920 ? Sl Jun15 2513:04 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys
mysql 650 33.9 1.6 72804 33064 ? Sl Jun15 6240:30 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys
please reply to my thread about mysql usage - i'd like to collect some data! thanks!
http://forums.mysql.com/read.php?11,57080