MySQL writing to net

Question

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

Solution

"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?

Comments

[Niall Donegan]

How are you connecting to the database? Is from localhost using a tcp connection? The local socket? Connecting from a remote server?

[robjmills]

standard PHP connection to mysql over localhost

[robjmills]

i do have connections to a few other servers within my network connecting via IP - would that explain it?

[blueben]

It could. Are the queries in the writing to net state queries that get sent to remote machines?

[robjmills]

just seen one - doesnt appear to be for a remote connection as host is localhost and db/user are both local