Need help with unresponsive database
I have a MYSql server running 4.0.21. I have a couple of databases with users that have access to only certain databases. For example Database1 and user DB1 has Usage on Global but All Priv. on Database1. If DB1 sends a jacked up query from php it could potentially lock up Database1, but Database2 and 3 are fine. How do I restart Database1 without affecting Database2 and 3? Right now I have to restart mysql service to get Database1 to repond again. Also is their anything I can do to prevent my php developers from having a bad query lock up databases on my server?
Thanks.
Subject
Written By
Posted
Need help with unresponsive database
April 23, 2005 10:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.