The following usage for mysqld doesn't seem right, and that time stamp! Anyone got any ideas why it is going crazy like that?
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25662 mysql 16 0 139m 30m 5256 S 88.9 1.7 312:17.23 mysqld
20200 apache 16 0 102m 14m 7548 S 5.0 0.8 0:01.42 httpd
I am a total newbie when it comes to mysql, Apache and Lighttpd configurations sure, but mysql totally clueless. Below is my my.conf. I am running on a machine with 2GB of memory and using InnoDB, connecting via PDO.
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Totally default to start from scratch and avoid errors, help! :)