Limit Concurrent Users In MySQL
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.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
How Many Concurrent Users On The Average VPS Plan
I'm on a vps using Dell PowerEdge Servers and 750 GB of transfer. I have concurrent users settings to where i now have them at "50" and I'm wondering how much higher i can go without troubles. My app is a perl cgi script in flat files and 95% of visitors will pass through my domain without seeing my webpage. They are only there approx 1 second, maybe 2 as they are quickly redirected from this platform. My host has a custom solution installed to check for apache stalls every few minutes and it will restart apache when it sticks - and it will stick from time to time. Just now i do about 75000 per day but plan to double to 150,000 next week and soon after will triple to 225,000 visitors per day. Should i increase concurrent users now in prep for the increase to 150k or at what level. Please give some suggestions for concurrent settings at future traffic levels. This host has a multiple server set up in case one fails - i should be good, i think. 75000 150000 225000 300000 400000 500000
View Replies!
View Related
Maximizing Linux (CentOS) For Maximum Concurrent Users
I am running lighttpd and eccelerator. I have stripped the php-cgi. I have tried forking anywhere from 50 to 300 to 1000 fastcgi children with PHP_FCGI_CHILDREN (through lighttpd, I'll attempt to do with same with spawn-fastcgi and fpm) Server stats: Intel Core i7 920 12GB DDR 250GB 7.2k RPM SATAII 16MB Cache I am using to lighttpd's lighttpd-status to estimate concurrent connections. When I refresh the panel, it shows that there are around 100-150 connections and around 150 requests/s in the last 5 seconds. My vmstats show that CPU is 98% idle. Blocks written/read is neglible. MySql key_buffer set to 2gb and I'm pretty sure it's not mysql. The overwhelming majority of requests do not access mysql. EDIT: Uh oh, I just realized that tcp_mem could be a huge bottle neck. I just set it to: net.ipv4.tcp_mem = 4096000 87380000 4194304000 It was previously: net.ipv4.tcp_mem = somenumber somenumber 393,216 <<<--- WTF! x1000 for my read values (it's an access server only). I can't benchmark the server right now so let me know if you have any suggestions besides this. I do think that this was the problem. When under load images could not be accessed either.
View Replies!
View Related
Limit Users In PureFTP
Is there any option to limit users only to upload (No other permissions like permission change, directory access etc, only upload) in FTP.. I am using PureFTP.. I have seen options to do it in ProFTP, like below, <Limit APPE MKD XMKD READ DIRS> AllowUser username1 AllowUser username2 </Limit> Is there any option to set in PureFTP ?
View Replies!
View Related
Cpanel Users Limit?
I'm in the process of taking a mid range dedicated server with cpanel. I was just wondering what sort of limit cpanel has with the number of users? For example 10,000 very small websites using sub domains 1000 average sites with top level domains? Or is cpanel limit not an issue and it's more down to what the server can handle in terms of it's usage?
View Replies!
View Related
Limit Traffic For Shell Users
How can I limit the traffic for shell users? e.g. I create 5 users and each of them uses the ssh server as a proxy. I want each user to create only 5GB traffic a month. How can I do this? I've already tried iptables but they can only limit the traffic created by the user who started the ssh server
View Replies!
View Related
How To Limit Users RAM/CPU Use
I have a dedicated server with CentOS and cPanel/WHM I want to know how would I limit each user usage of RAM and or CPU I see HUGE web hosts are doing that , they give you 9999999 diskspace and 99999999 bandwidth but they limit your RAM & CPU use to a tiny number I want to know how could I do that in order to keep my resources good .
View Replies!
View Related
Limit Mysql
i dont want clients taking the servers I/O and server load over 4.00 when they do major update ect... querys on sql. is there a way to limit the ammount they can do?
View Replies!
View Related
Users Cannot Connect To MySQL Via Phpmyadmin
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.% Would allowing access to localhost will help and how can I do that for all users?
View Replies!
View Related
Mysql Open Files Limit
I been having a heck of a time just with this one cpanel server and open files limit. At first using open_files_limit did not work so I changed it to open-files-limit that seemed to work but now it rejects the value and sets its down to 65535. Then system open files limit is 500000. I try to set it to any value about 65535 in my.cnf and here is usual error: 090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535 090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535 When I run something like the tuning-primer it shows: Current open_files_limit = 120510 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine But Im not sure if it is just reading my.cnf or something. I am still getting complaints from users about lost connections and I see the errors in error log. Ive looked everywhere and cant seem to find a solution to this.
View Replies!
View Related
Mysql Open File Limit
I am trying to increase my open file limit on my CentOS release 4.6 VPS. I have tried modifying my /etc/security/limits.conf with the following: @mysql soft nofile 4096 @mysql hard nofile 4096 @mysql soft sigpending 4096 @mysql hard sigpending 4096 Even is a mannual set it with "ulimit -n 4096 mysql" it will not stick. Any ideas what I can do to get this limit increased permanently?
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
Preventing Users From Connecting To Other Users Database
On my server, users can connect to any database as long as they have the database user and password. This makes it easier to hack any database on the server. What I want to do is to make the users can only connect to their own databases and not other's. I tried changing the localhost ip address but it didn't work ( I assume I didn't do it the right way)
View Replies!
View Related
Max Concurrent Connections
i have a vps, and im current use lighttpd, but i want move to litespeed Standard. And i see they limit Max Concurrent Connections =150 on standard version. but what is Max Concurrent Connections? where can i find it. and is it the number connection via port 80 (netstat -nt | grep :80 | wc -l)?
View Replies!
View Related
[Apache2] Enable/disable Concurrent Connections
Currently I use WHM/cPanel latest on a few boxes, I have (at least to my knowledge) copied the exact compile settings between servers, yet some of my servers allow me to do concurrent file downloads (using DownThemAll or another "accelerator") whilst others only let me make 1 connection. These servers also don't show me the final filesize while downloading. So my question is, what did I set/unset to cause this to happen? It's been bugging me for a month or so now and no amount of recompiling has fixed the issue (aside from a clean install of the OS/cPanel). I can provide a list of modules and other config settings if required.
View Replies!
View Related
Host With Max Concurrent SQL Connections
Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeouts So far i have contacted the below providers and asked them how many concurrent connections on mysql database they support hostgator - 25 connections powweb - 20 connections hostmonster - 30 connections Servage - 20 connections anhosting - 50 connections How is most reliable and i can count on ? I want to tranfer my domain.
View Replies!
View Related
Linux Cisco VPN Client - Two Concurrent Connections Possible?
Server: Dell 2950 onboard NIC only CentOS 4.6 Is it possible to run two concurrent VPN connections using the Linux Cisco VPN client? We need to have one server be able to communicate over two different vendors gateways. Do we need to possibly add an additional NIC to the server first? When we try to connect to another profile we get the error: Initializing the VPN connection. Secure VPN Connection terminated locally by the Client Reason: A connection already exists.
View Replies!
View Related
15,000,000 Concurrent Sessions Using Only 2 Dedicated Servers
I was looking at some load balancers hosting companies offer and some of the load balancer specs say they can handle up to 15million concurrent sessions(users online at the same time), so does this mean if i had a site like wikipedia that had 15 million users online at the same time, would i be able to do this with only 2 dedicated servers, or will the Cpu's not be enough?
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
Unprivileged Users
I have a few system administrators having full access to the Windows 2003 servers. I fear some of them might be messing up with the server like opening websites on the server or downloading files on the server. I want to create unprivileged users to login to the server so that they can do the basic tasks like reading the log files etc. Can anybody give me the steps for the same?
View Replies!
View Related
SFTP Users
we have a WHM account... we have different accounts on that...and for each account, there are add-on domains underneath that. (i hope you know what i mean) and we set it up to use only SFTP to connect to server. no FTP. after we have set it up that way, it seems that we can only connect to SFTP using 1 user/pass for each account... that is the same user/pass we use for Cpanel of each account. say, i have Account A... under Account A, i have addon domains: A1.com, A2.com, A3.com... setting SFTP only on that server, all those addon domains of Account A, can only use 1 user/pass to login to SFTP which is the cpanel access also of Account A. question is.... is this behavior correct?? how can we create a different user for each add-on domain?
View Replies!
View Related
Online Users ...
I hope this is in the correct section. Secondly, here is my issue that I am hoping someone can help with. I run a fairly successful video streaming site with several thousand members, and several thousand videos. I am trying to determine how many users I have online at any given time. Does anyone know of a piece of software/code out there that can provide me with this information in real time?
View Replies!
View Related
New Users And Subdomain
I am a server admin. Recently, when I set up new user account, there's something strange in FTP.. ( Please check the image for detail ) Besides, all the new set up subdomain cannot use (no matter new or old user) and 404 error occur.
View Replies!
View Related
MidPulse Users
Does anyone have an experience with this host? In my search I found several favorable comments. I've been collecting different hosts names to consider from those of you kind enough to post them on your signatures. I'm with A Small Orange and am looking for a backup host, or will change the DNS to the backup if they are better. Others I am considering are Aspire and Known Host. I'll need a shared plan. My site is anywhere from 350 to 450MB's. I try to get twice the space I need because I can have a spike here and there since clients are always downloading my voice files for their projects.
View Replies!
View Related
LiteSpeed Users
Does LiteSpeed webserver provides me bandwidth usage? Someone told me that he was using 8 mbits connection and after jumping to LiteSpeed, bandwidth usage has decreased to 3 mbits.
View Replies!
View Related
LP - Users Apache
I have installed LP on my system, but I have one problem... The sites main apache runs well, but I can't get the users apache to start. The two should be run from different ports?
View Replies!
View Related
My Users Said His IP Is Blocked
My user said he can not view his site from his IP address. His friend from the same ISP also canot access the site. But i can access from my ISP. So I think probably his IP address has been baned. Therefore, how can I check that? and how can i make his IP range available back?
View Replies!
View Related
Blurstorm Users
Does anybody have a working Blurstorm number? I've tried 850-445-6937 which I found on the internet, but no answer. Long story short. Signed up to host my website. Credit card charged and approved, but I never received a user name/password confirmation. I'm not able to log on to anything. It has been 4 months and they charge my cc every month which I dispute with the cc company. I can't cancel the web account. My next step is to cancel my credit card. I have emailed 4 times, left messages at the above number, talked with the chat line. No response. This company is a scam. Number one rule in chosing a host company, always make sure they have a working customer service number (call it and talk with someone).
View Replies!
View Related
Users Too Quick To Judge
I find it worrying when new or relatively new users post "[XYZ]VPS PROVIDER IS A SCAM" or "[XYZ]VPS ROBBED ME" in a topic because they didn't get the instant ticket response or fast enough setup time on their $10 VPS.. I'm planning on setting up a budget UK based VPS service myself some time soon, and users would do well to remember that a lot of hard work goes in to the management and set up of such providers. This kind of negative publicity can not be taken back once posted. A quick google search will throw this kind of a post up and cause irrepairable and often, completely unnecessary harm to a business..
View Replies!
View Related
Users Password Hacked
In my linux vps (cpanel based) hackers have hacked the password of the user ( website owner ) and he have uploaded some hack files(PHP) through FTP. Sometimes the hacker uploads perl/CGI scripts and sends spam mails .This happens frequently in server. How the hacker gets the users password? How can i prevent my users and server from this security issue?
View Replies!
View Related
HostDime VPS Users
I've searched around these forums (VPS specifically) and cannot find any recent "reviews" or opinions on HostDime's VPS offerings. Anyone using them? They seem to have the most bang/buck and I'd like to get a more recent review opinion on them.
View Replies!
View Related
Not Needed Users In Cpanel
I'm running a CPanel server and wondering which of these users are safe to remove and whats the best way to do that? Code: bin:x:1:1:bin:/bin:/sbin/nologin daemon:x:2:2:daemon:/sbin:/sbin/nologin adm:x:3:4:adm:/var/adm:/sbin/nologin lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin sync:x:5:0:sync:/sbin:/bin/sync shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown halt:x:7:0:halt:/sbin:/sbin/halt mail:x:8:12:mail:/var/spool/mail:/sbin/nologin uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin operator:x:11:0:operator:/root:/sbin/nologin games:x:12:100:games:/usr/games:/sbin/nologin gopher:x:13:30:gopher:/var/gopher:/sbin/nologin ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin nobody:x:99:99:Nobody:/:/sbin/nologin avahi-autoipd:x:499:499:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin ntp:x:38:38::/etc/ntp:/sbin/nologin dbus:x:81:81:System message bus:/:/sbin/nologin polkituser:x:87:87:PolicyKit:/:/sbin/nologin nscd:x:28:28:NSCD Daemon:/:/sbin/nologin rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin nfsnobody:x:65534:498:Anonymous NFS User:/var/lib/nfs:/sbin/nologin tcpdump:x:72:72::/:/sbin/nologin avahi:x:498:497:avahi-daemon:/var/run/avahi-daemon:/sbin/nologin mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin torrent:x:497:496:BitTorrent Seed/Tracker:/var/lib/bittorrent:/sbin/nologin haldaemon:x:68:68:HAL daemon:/:/sbin/nologin rpc:x:32:32:Rpcbind Daemon:/var/lib/rpcbind:/sbin/nologin
View Replies!
View Related
Detecting Proxy Users
We are starting a website in .Net for this i want to block Proxy users who using TOR , Squid , IP Hide software users etc...... for this what we need at programing level & Software , Hardware firewalls & Intrusion Detections & Intrusion Preventions will help us in prevent proxy users.
View Replies!
View Related
Quota All Users :: Unlimited
i have new vps server.. I added some new user to my server but when i went to List Accounts i found all users with unlimited Quota, i don't why? i already have Packages with specific quote for each one, even, if i made it Options Manually i have the same problem. i made a reseller and from that reseller i added user with the same problem if i loge in the cpenal for one user i have this message in the Disk Space Usage Serious problem while fetching quota data (quota): Illegal seek (0) / MB
View Replies!
View Related
Files Not Downloading To Users
I run a download website boasting many files (entirely legal, non-pornographic), the sizes of which range from 100KB to 500MB. Some users of the site seem to be complaining of the files not downloading and or being truncated (i.e: it says it has been downloaded even though it has not been fully downloaded.) Here is one reply I received: "No specific massage appears, only sign the download is complete and infact it is not. About 7 mega down loaded instead of 79 mega. I use fire fox browser and ADSL internet line speed 512" All the files however do seem to download perfectly on my computer, though I have a good 8mb line, which leads me to believe it may be something to do with a timeout setting?
View Replies!
View Related
Redirect All Users Except Me With Htaccess
I'm going to be doing some upgrades on my site and I want to redirect all users to a different page while I do the upgrades but I need to allow my self too have access. I have done this before with a htaccess rule, but I can't remember what it was and can't seem to find it anywhere.
View Replies!
View Related
Enabling Crontab For Users
I noticed on my new servers users doesnt have crontab permission.On my first server they have access.So what i need to do to enable users crontab permission automaticly on new servers?I have whm/cpanel there but it seems there is nothing about it there.
View Replies!
View Related
|
TRACKER
