Hi
I have a mysql db and asp frontend runing of the db I rescently upgraded my db from access to mysql because of to much data being stored inside it anyway now whenever I proces a querie from my asp pages to the db it creates a new process or thread on the server and once the querie goes through it doesnt close it again and if I run another querie or the same one it keeps the process open and starts a new one the old one just goes to sleep, how do I flush these processes coz I have tried killing them then theyre status chages to killed and then I flush all hosts and threads tables etc. but it still keeps those processes active, is theyre a time out that I can set and what must I enable for it to work? I run mysql latest stable version on windows NT.
Thank you very much
Quinton
I have a mysql db and asp frontend runing of the db I rescently upgraded my db from access to mysql because of to much data being stored inside it anyway now whenever I proces a querie from my asp pages to the db it creates a new process or thread on the server and once the querie goes through it doesnt close it again and if I run another querie or the same one it keeps the process open and starts a new one the old one just goes to sleep, how do I flush these processes coz I have tried killing them then theyre status chages to killed and then I flush all hosts and threads tables etc. but it still keeps those processes active, is theyre a time out that I can set and what must I enable for it to work? I run mysql latest stable version on windows NT.
Thank you very much
Quinton