View Single Post

   
  #8 (permalink)  
Old 02-28-2008, 07:02 AM
Artem Kuchin
 
Posts: n/a
Default Re: How to auto repair db on hosting with quota

Baron Schwartz wrote:
> Regards,
> Baron
>
> Yes it is. Even worse, people love to convert a top-posted thread to
> bottom-posted and verse vice-a!
>
>> I see topposting i popular in this mail list

>
> And now for the bottom-posting part of this reply...
>
>> Any idea on how to limit connection per user? (so one user
>> cannot abuse the server and take all max_connections connections
>> for himself).

>
> See http://dev.mysql.com/doc/refman/5.0/en/grant.html and look for the
> GRANT OPTION options.


Argh!!

"The MAX_USER_CONNECTIONS count option, implemented in MySQL 5.0.3, limits the maximum number of simultaneous connections that the
account can make. If count is 0 (the default), the max_user_connections system variable determines the number of simultaneous
connections for the account. "

We are still kinda stuch to 4.1. Well, its time to upgrade.

--
Regards,
Artem

Reply With Quote