Hello.
May be this would be helpful: http://dev.mysql.com/doc/mysql/en/user-resources.html Jan Pieter Kunst <[EMAIL PROTECTED]> wrote: > Hello all, > > Suppose I have a LAMP server which functions good enough for daily use > by humans, but is occasionally brought to its knees by an automated > website-downloader, when such a download involves a lot of database > searches, which uses up all the available MySQL connections. > > Is there anything to do in the MySQL layer of the server to mitigate > this problem? I was thinking of a setting like 'database xxx can have > only n percent of the maximum number of connections at any given > time', but such a setting doesn't seem to exist. > > Any ideas? > > Thanks, > Jan Pieter Kunst > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
