lundi 26 janvier 2015

My connection to a Mysql DB has been blocked after spamming queries, for how long?


I am creating a web application that depends on querying a legacy DB without an API.


It's MySql.


Off course the lack of an API eventually got me in trouble. A feedback loop while testing the app fired a bunch of (Probably a few hundred) get requests towards the database, and now i can't connect to it anymore, it simply times out.


I horrified tried to log into to it via the browser and PHPmyAdmin, and to my relief nothing was wrong, but in Status->Processes i can see this process:



Kill 25289014 myusername localhost None Query 0 ---


I reckon the DB killed all incoming connections from my user when i began to spam it from my application.


Do any of you guys know if the "block" will be lifted after a certain amount of hours. It's about 12 hours ago now.


Or if i have to contact the administrator to lift the block, or kill the kill process? My user doesn't seem to have the privilege to kill the process as there is no buttons to do so.


Thanks in Advance.





Aucun commentaire:

Enregistrer un commentaire