MySQL Admin

[a_jadon]

Hello There,

 

I have a very important question that is bothering me for sometime now.  I program in classic ASP working in front of MySQL database.  I had a couple of pages that executes a a couple of queries.  Note: that the 2 queries call upon 2 different tables with each have a combined records of 100. I checked my ASP connection close thoroughly but found nothing unusual.  Now, when I logged on to MySQL Administrator and checked my Server Connections I saw a few open with many being in sleep mode and just one that is active.  This is really unhealthy is that correct as I chose the Health tab and saw that there are about 468 queries running (max allowed is 1114).  I am just one user and just thought to myself what will happen if there were 100 users on my website at the same time.  The website would shut down.  I did a little test.  I erased all files on my server and left with nothing.  I logged on the MySQL admin and went to the Server Connections and saw that there are 2 (one asleep and one active). Then, went to the Health tab and saw that there were 300 (somtimes it gets upto 500) queries running, traffic is upto 10MB, Usage is over 5% and Key Efficiency Hitrate is 100%.  This tells me that it has nothing to do with ASP.  Now my question is what is the norm, if I run the ASP code will it shut my website, why are there many SQL queries running with no code present, and is it safe to run my website with these numbers in mind?

 

Thanks so much and I would appreciate any help out there.

 

Thanks

Awny

[Ken2k7]

You can use SQL - SHOW PROCESSLIST - and SQL - KILL id - to show the processes running and kill them.