Limit concurrent users in MySQL

Posted by ThaiZone, 01-15-2008, 02:49 AM
I try to search and not found the solutions to limit concurrent of db users to connect to MySQL in same time for example: Limit user root to connect to MySQL maximum 5 connections in same time There have max_connections setting but it limit for all users in all connection to MySQL. But I found that in version 4.1.x there have max_connections property in user table (Users and global privileges) of mysql database, this setting is limit connection in 60 minutes. I would like to know if there any setting or code modify for this solution that I want.
Posted by david510, 01-15-2008, 03:55 AM
Set the value as below in /etc/my.cnf file and restart mysql. set-variable = max_user_connections=5

?האם התשובה שקיבלתם הייתה מועילה

 הדפסת המאמר

קראו גם

DirectAdmin email forwarding not forwarding

Posted by river1, 06-30-2008, 07:20 AMI had email forwarding from a site that I am running on a...

Question on array sorting in php

Posted by computerwiz3491, 01-17-2008, 05:10 PMI have the following array that I printed using...

beating my head over a php/my_sql error

Posted by star_dancer, 01-16-2008, 06:15 PMI'm getting an error and I can't figure it out. I...

CACTI with cPanel

Posted by hosteur, 05-07-2007, 07:29 AMMy other box gear by DedicatedPlace and they guys still...

email from root

Posted by Saryooo, 04-18-2007, 05:39 AMDaily i am getting this kind of emails from my VPS. I...