JavaSprout
Programmer
I have a problem where MySQL seems to get stuck in an infinite read. I don't know how, or worse how to find out what is causing it or how to stop it. It grinds the system gradually to a halt.
I see the number of I/O reads (from Task Manager) go up and up continually - e.g. I stopped things at 821,099 I/O Reads, and 75,845,533,586 Read Bytes.
I have been gradually tracking it down, but I'm stuck!
HELP!!!!! (I needed that)
When I take the following steps, I see the following happen.
Firstly, I open the (Windows XP) Task Manager, and select the option to display I/O Reads and I/O Read Bytes.
1) I make sure MySQL is shut down by running 'mysqladmin -u root shutdown' from a DOS window.
2) I run 'winmysqladmin' from the DOS window. This starts mysqld. In the Task Manager I see the number of I/O Read Bytes go to 2,739,356 and stop.
3) I start apache. No change.
4) I start It displays 2,742,433 read bytes and sometimes stops, and sometimes takes off! What I mean is that sometimes it just stops at this number, other times it just starts going up and up and up.
5) If it stops, I move in phpadmin to view one of my other dbs, and then maybe another. Very soon the reads take off.
It is not only in phpmyadmin where I see the problem. If I load even a page of my db driven website, I see the same problem.
System is Windows XP Home Edition, MySQL 4.0.12 and I use phpMyAdmin 2.2.4 with an Apache 1.3 server.
I am conducting some tests to see if it happens only when I am connected to the internet (hacked?), but I'm not yet sure of the results.
Can I see what is happening more?
What can I try?
What might it be?
How to stop it?
Thanks for any suggestions or help.
JavaSprout
I see the number of I/O reads (from Task Manager) go up and up continually - e.g. I stopped things at 821,099 I/O Reads, and 75,845,533,586 Read Bytes.
I have been gradually tracking it down, but I'm stuck!
HELP!!!!! (I needed that)
When I take the following steps, I see the following happen.
Firstly, I open the (Windows XP) Task Manager, and select the option to display I/O Reads and I/O Read Bytes.
1) I make sure MySQL is shut down by running 'mysqladmin -u root shutdown' from a DOS window.
2) I run 'winmysqladmin' from the DOS window. This starts mysqld. In the Task Manager I see the number of I/O Read Bytes go to 2,739,356 and stop.
3) I start apache. No change.
4) I start It displays 2,742,433 read bytes and sometimes stops, and sometimes takes off! What I mean is that sometimes it just stops at this number, other times it just starts going up and up and up.
5) If it stops, I move in phpadmin to view one of my other dbs, and then maybe another. Very soon the reads take off.
It is not only in phpmyadmin where I see the problem. If I load even a page of my db driven website, I see the same problem.
System is Windows XP Home Edition, MySQL 4.0.12 and I use phpMyAdmin 2.2.4 with an Apache 1.3 server.
I am conducting some tests to see if it happens only when I am connected to the internet (hacked?), but I'm not yet sure of the results.
Can I see what is happening more?
What can I try?
What might it be?
How to stop it?
Thanks for any suggestions or help.
JavaSprout