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

How are you connecting to the database? Is from localhost using a tcp connection? The local socket? Connecting from a remote server? — Niall Donegan, Jan 11 '11 at 18:37

score 2 · Accepted Answer · answered Jan 12 '11 at 05:07

2

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

answered Jan 12 '11 at 05:07

blueben

3,517
1
16
15

i do have connections to a few other servers within my network connecting via IP - would that explain it? – robjmills Jan 12 '11 at 09:11
It could. Are the queries in the writing to net state queries that get sent to remote machines? – blueben Jan 12 '11 at 09:15
just seen one - doesnt appear to be for a remote connection as host is localhost and db/user are both local – robjmills Jan 12 '11 at 10:04

MySQL writing to net

1 Answers1