How To Change 'max_user_connections' In A Dedicated Server
Nov 7, 2008
I have purchased a dedicated server because my existing host gives me a database error during high traffic. the error is
Code:
"Cannot connect to MySQL: User admin0506 has already more than 'max_user_connections' active connections"
Now in my dedicated server I have root access and a Plesk control panel with admin access. I have created a database but I don't know how to change the parameter "max_user_connections". Please help me because I am loosing lot of business due to this issue.
I have a client on a dedicated IP, today we needed to downgrade the web hosting plan. As the web hosting plan puts users on a default shared IP, this plan change also changed the dedicated IP to the shared one causing some propagation issues for a small period of time.
I have contacted WHMCS about this asking if they had a way of changing the clients plan but keeping the IP address intact as this could lead to some very undesirable outcomes. They explained that it is not their fault and to contact Parallels.
I know I can change the plan directly in Plesk however by initiating the plan change via WHMCS, everything is automated.
I wonder what is good parameter to set for max_user_connection on shared hosting. I see that some hostings set it to 20 and on some other hostings it is set to to 30 respectively 40?
I keep getting this error once in a while for my forum.
Quote:
SQL ERROR [ mysql4 ]
User xxxxx_xxxx has already more than 'max_user_connections' active connections [1203]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I've contact support team from my Hosting provider and they have help me to increase the value of max_user_connection to 50. I have made to understand by them that this problem can be resolved by using VPS or Dedicated server. As a newbie, I just want some assurance would the problem permanently resolve if I'm using VPS or Dedicated server? Which one should I use? VPS or dedicated server?
I've had an issue come up recently that I haven't had to deal with before. I'm starting to get regular errors during peak traffic times saying that I have more then the max_user_connections allowed.
I tried setting this to a higher number using ini_set. Unfortunately my host overrides this. I've talked with the host and they cannot up the 15 user maximum.
I've been with this host a while and they have great support and really great service. I understand their need to limit this because it is a shared environment.
I'm wondering if there's anything I can do on my end to help avoid this problem.
Is the only option switching somewhere that lets me have more maximum connections? At the rate I'm going this problem will continue to grow, so it needs to be solved quickly.
i am having an website like a webdirectory. BUT i am getting this error after every 5-10 mintues :
Warning: mysql_pconnect() [function.mysql-pconnect]: User USERNAME has already more than 'max_user_connections' active connections in /FIELPATH on line 93 Database error: pconnect(localhost,bstitne_netclass, $Password)failed. MySQL Error) Session halted.
PLEASE suggest how can i solve this. May be it is an server issue
Since moving over to a new server, I have had to reboot my sql server about 5 times a day due to it crashing, and I always get the error:
Warning: mysql_connect() [function.mysql-connect]: User food_user has already more than 'max_user_connections' active connections in /home/food/public_html/includes/functions.php on line 9 Not connected : User food_user has already more than 'max_user_connections' active connections
I dont understand what is causing this...I used the tweaking guide as found on here and my.cnf file looks like this:
Through my WHM, i went to "Show Mysql Processes" and heres what it displays www.brinked.com/mysql.txt
This problem has also occured on another one of my websites on the same server that makes use of mysql. Am I doing something wrong here? I dont think its the script because it ran for years on another server just fine.
I am getting the error "max_user_connections exceeded" for database user "xxxx". So every time this happens I have to feed a new database admin login to my script. There is nothing wrong with the script since it is very popular membership script. I think my host just allows low number of "max_user_connections". please advice me on a host that allows higher number of "max_user_connections"
I am currently on VPS, and am finding that my site loads slow. I don't know if it the server or if my scripts are slow/ inefficient. Is there a way to find out?
The site uses wordpress, and has changing content several times a day, running hypercache.
The mysql database is 200mb
I am wondering do I need to move to dedicated hosting?
Is 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?
Has anyone helped clients transition from one domain to another? Maybe dissolving a partnership or renaming their company... so a new domain name has been registered and a new website created.
2 Issues:
#1 Using .htaccess 301 redirect We used the following command line in their old website's htaccess file
Redirect 301 / [url]
The goal was to get people try to visit any page of their old website (i.e. OldWebsite.com/contact.html) redirected to their new website (i.e. NewWebsite.com/contact.html). Isn't that supposed to change the address bar's URL, too? For some reason, I visit their old site and I seem to be redirected to their new website but the address bar still has their old domain name? Something is going on???
#2 Having their new company name for 2 years now. People can enter her new company name in Google, MSN or Yahoo. Her new company name appears in the search results but has the old domain name associated with it. We are trying to get rid of any reference to that old domain name? What's the easiest way to do this? So what people see in search engines is:
New Company Short Meta Description www.OldDomain.com
What steps did I miss in this transition?
What steps do I have to take on their old website/old web server to control it's appearance on search engines and make sure people get to the new website?
I currently have a dedicated server at volumedrive and want to transfer my site over. I have the following setting but not sure why it doesn't work.
On the WHM, I have:
Main >> Server Configuration >> Basic cPanel/WHM Setup
Main Shared Virtual Host IP........................12.345.67.89 (IP from the new host) Hostname....................................................server.mysite.com Primary Namserver.....................................ns1.mysite.com Secondary Nameserver..............................ns2.mysite.com ___________________________________________
Main >> Networking Setup >> Hostname Current Hostname..............................server.mysite.com ____________________________________________
Main >> Networking Setup >> Nameserver IPs
Ip 12.345.67.89 ns1.mysite.com 12.345.67.99 ns2.mysite.com ________________________________________
Main >> Networking Setup >> Resolver Configuration
At the registrar godaddy, I have the existing name server set as ns1.mysite.com and ns2.mysite.com from prior server already. what other setting do I have to do to make my site working properly ?
im making a website and my friend told me that first i have to change the name of a server on the cpanel for configurate the publichtml files. i dont see where i can change it. please be specific if you are going to reply and thanks for read this.
I have a reseller package with HostGator.com , and I had one of my personal sites on it.
The site was growing too fast, and taking up too much of my reseller package, so i bought another normal hosting package from hostgator. They did a complete site copy onto the new server (same account name for site, just on a different one of their servers)
Old: (URL address blocked: See forum rules)~midnight/ New: (URL address blocked: See forum rules)~midnight/
I did this swap over 7 days ago. It was successful, everything worked, did my DNS swap and i thought that was it.
Now for the confusing part. when i type in my domain ((URL address blocked: See forum rules)) it shows up perfect, as it should, as it does with 75% of my members
BUT
For the other 25%, its showing up as the old server. I have been onto my domain supplier, and they said all is fine at their end, they are seeing the site as they should, have been onto hostgator, and it works for them, they cant understand what it can be.
Not only this, but people who can get on, might still get the old servers at times. People who cant get on, can get on from different computers in different houses (hope that makes sense)
I was about to change the site back to my reseller package and scrap the new hosting, but said i would seek advice from other webmasters first.
Has anybody ever experienced this before? How is it solved? What can i do?
Hostzio is down still, so I'm planning on moving my websites to yet another server/reselling account. I was wondering if my account with Hostzio is still active, if I can transfer the domains to another server without any problems? There would be about 10 domains I'd have to transfer from my old account to the new one.
namecheap.com to allow a nameserver change? I have sent seven e-mails and received 10 un-helpful messages. One even said, "Hello, What is the issue in whcih you are having? I want to move to yahoo.
I am currently using a shared hosting but due to increasing traffic and server load my existing host is not able to provide reliable services and I am planning to upgrade my hosting service.
While I was searching for Dedicated Servers, I learnt about Virtual Dedicated Servers but I am not very sure about their reliability? Are Virtual Dedicated Servers useful? My website current serves over 2500-3000 visitors a day resulting in 30,000 pageviews and I am expecting the traffic to grow by atleast 2 folds in the next few months as I start some PPC campaigns and Email Marketing for my website. Can a Virtual Dedicated Server cater such needs assuming my website to be more of less dynamic website written in php?
