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! :)