I have a server that has been running at high CPU load due to MySQL activity, when i run the command mysqladmin pr
i often see a few queries with the state "writing to net". I had a look around and couldn't find much out about this other than the fact i read somewhere that this shouldnt be expected in usual MySQL activity. Any ideas what this could mean?
Running MySQL 5.0.91-community on CentOS 4.8
"Writing to net" means that MySQL is writing a packet to the network interface. You mentioned you have PHP connecting via localhost; do you have any remote network connections at all?