Reputation: 642
I guess I'm a little confused what's going on here. In phpmyadmin in the Status->Monitor section, when my website is not even doing anything sql based at the time, I'm getting 6000 questions and 200 connections.
This very much does not seem normal, can anyone give me some tips about what's really going on here, this can't be normal, right?
edit: Im trying to connect to about four different tables every five seconds and pull information from them, and I believe it's causing my server to crash. Is this a bad parctice?
I'm using jquery and php. I think even through bad programming I can't be hitting the 400 queries a second phpmyadmin is saying I'm hitting.
Upvotes: 4
Views: 16120
Reputation: 9007
You might be able to see which queries are running from Status > Monitor, in a particular time range taken from the moving graph. See http://www.youtube.com/watch?v=7ZRZoCsrKis starting at 6:00.
Upvotes: 6