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?
View 14 Replies
One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier.
I noticed the following warning in the host's control panel:
"[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances."
Is this common at other shared hosts?
I have seen some shared hosting providers include cPanel. As far as I understand cPanel is to manage and install apps on VPS. Why would you need that on shared hosting?
View 14 Replies View RelatedI am in a shared hosting environment. Their php's setting does not have open_basedir set and safe_mode is off.
I was poking around their server and noticed that using some simple system() calls within a php script, I was able to access /etc/passwd and therefore access all their client's public_html.
I am currently calling them to let them know of the vulnerability. But out of curiosity, is it normal that I can read all the other site hosted? They do have config files with mysql pasword in it.
Has anybody successfully used nginx in a shared web hosting environment?
It seems quite powerful and looks like it would be well suited for such an environment, combined with FastCGI, looks like it could serve a lot of hits on relatively inexpensive servers.
The main problem I'm foreseeing is a demand for mod_rewrite, which may cause some support headaches.
Anything else I'm not thinking of?
(I did search but the last post I found was from 2007 with no replies, and necroposting is bad)
I'm running a shared hosting environment and I'd like to know if it's even possible to secure the Apache while it's running mod_php. I know I could go suPHP with PHP-CGI, but that'd increase drastically the server load.
So what should I do to best secure the server?
So far now I did:
- Apache:
Installed mod_security and mod_evasive.
- PHP:
Set register_globals=OFF
Set disable_functions = ini_restore, popen, exec, shell_exec, system, passthru, proc_open, proc_close
Set safemode=ON
Set open_basedir to user's directory on virtualhost
Is that would be a secure environment for my users?
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 want to install subversion on my shared environment,
i want to ask if it will waste alot of system resource or any problem?
my server is centos with cpanel
Does anyone know of any shared hosting plans that don't have any MySQL limitations? Aplus.net and Powweb are trying to shut down my accounts because of this problem, and I can't afford dedicated hosting quite yet.
View 12 Replies View RelatedDoes anyone have an opinion on the performance of XO's shared web hosting solution when you're using their built-in MySQL capability with PHP coding?
View 0 Replies View RelatedMySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that:
a) one customer could write a procedure which accessed another customer's data?
b) any customer could call a procedure created by a different customer?
c) any customer could override an existing mysql function in a way that would affect other customers?
d) any customer could write a function that bound to a system library and crash the entire server instance?
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
Pros/cons? Success stories? Security/stability? Tried w/ cPanel? Yes/no?
A good friend handed me a SLES disc awhile back and I'm loading it up now to give it a shot on a whitebox with one of my test domains and IP's. Anybody have anything to share?
I'm running SQL 2005 in my hosting environment, and plan on offering as part of my plans.
The one issue I'm having is any user can view all the databases. My main issue is I need to store client information (sorry, I only can afford one server) into the database. Basically I'm creating *all* the backend panels, management, etc in ASPNET/C#.
The database will have FTP, email, payment, etc stored it in. Should I hold off and only offer mySQL? I DO NOT want the users seeing my databases like that. They can't access them, but still. I don't know what Microsoft was thinking!
I was thinking about developing my own SQL Manager where you could execute scripts, edit/create tables, and do everything you needed right inside of your webbrowser. This is, of course, a lot of work when you can do it easily in SQL Manager express. I imagine my way would be easier since I could make a list of blocked commands, run a check on the commands the user is executing, and block them.
By the way, I'm running Windows 2008 x64 w/IIS7 and the entire panel will be custom made by me and two other programmers, with me being the lead developer.
my friend and i are working on some web-based-commerce ideas and at current we're at godaddy.com. i can only imagine the vitriol they've rightfully earned here, as we decided to be done with them when the $30 SSL license they told us we could get one night quickly became $78 because there was a new "turboSSL server" package we needed, nevermind the guy the first time said with our hosting options we only needed to go through them for the SSL license, so basically, either the first guy lied to us or the second guy tried to hustle us, either way, i dont like companies whose sales model is revealed like the plot in a horror movie, so we're looking to go elsewhere.
basically we're looking for a virtual private server setup, although actually another question i'd love to ask someone is if joomla is better served on unix/linux or windows, with a few dozen accounts needed, and by accounts i mean domains and whatnot, as right now it's basically the blanket idea that you grab the names you need, or might go to if you change your mind on company names...
so basically, with all the people here talking about bad experiences with places, are there any good experience type places where someone can get competent tech support, no hustling in sales pitches, and quality service at a nice solid price?
again, sorry to show up and start asking for things, but i'm not necessarily well versed in these arts yet... rest assured once i have some information i shall contribute to the community and help others who are in my position now
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've had my account less than 2 months. In that time, my account was actually usable, a couple of weeks. I've now been waiting for a resolution to the "Out of Space" errors for nearly 7 days. The most recent communication was this morning (one of only two responses in 7 days) stating that he would "try moving your account to a newer server. I should have another update later today." It has been 6 hours since that message and still no resolution.
BQ has a very good reputation around here. So, I was very hopeful that they would live up to that reputation. However, 7 days to resolve an issue doesn't seem all too responsive to me. Apparently, I'm not the only one who has experienced this same problem of delayed responses and slow resolution.
webhostingtalk.com/showthread.php?t=682152&highlight=bqbackup.com+out+of+space
Before you ask... yes, I used the correct email for support.
So, I have to ask... Is this typical of the support that I should expect? If I have to ever restore my data, will it take a weeks to resolve any issues that I may experience?
I am using dreamhost... I sort of like their user interface. It's definitely better than cpanel...
Recently I was told to move to PS because I am using too much CPU. I finally agreed to move even though the server was working fine...
Then I finally manage to lower CPU usage by 90%... However, I am not allowed to go back to reseller server because I am using too much memory...
If I run top this is what I see:
top - 05:48:22 up 5 days, 5:54, 1 user, load average: 3.98, 4.46, 3.43
Tasks: 30 total, 1 running, 29 sleeping, 0 stopped, 0 zombie
Cpu(s): 30.7% us, 7.5% sy, 0.0% ni, 61.1% id, 0.5% wa, 0.0% hi, 0.2% si
Mem: 417792k total, 307196k used, 110596k free, 0k buffers
Swap: 417792k total, 0k used, 417792k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM SWAP TIME CODE DATA COMMAND
31088 teguh123 16 0 20364 8956 4972 S 1.7 2.1 11m 0:00 6504 3232 php5.cgi
31232 teguh123 15 0 6108 1224 912 S 0.0 0.3 4884 0:00 276 456 sshd
31246 teguh123 15 0 2608 1384 1128 S 0.0 0.3 1224 0:00 592 228 bash
31263 teguh123 15 0 2132 1068 836 R 0.0 0.3 1064 0:00 48 280 top
1 root 15 0 1848 576 496 S 0.0 0.1 1272 0:01 32 280 init
2445 root 15 0 31584 20m 5840 S 0.0 5.0 10m 0:40 316 15m apache2-teguh12
2461 root 18 0 1616 480 420 S 0.0 0.1 1136 0:00 20 232 inetd
2572 root 15 0 3044 1156 980 S 0.0 0.3 1888 0:02 24 264 master
2582 root 15 0 3548 928 696 S 0.0 0.2 2620 0:01 276 456 sshd
2599 root 16 0 1824 756 608 S 0.0 0.2 1068 0:06 28 248 cron
2609 root 18 0 1572 468 408 S 0.0 0.1 1104 0:00 16 232 ud
31203 root 15 0 6124 1536 1240 S 0.0 0.4 4588 0:00 276 456 sshd
2577 postfix 18 0 3084 1228 1016 S 0.0 0.3 1856 0:01 40 264 qmgr
8628 postfix 18 0 3052 1172 992 S 0.0 0.3 1880 0:00 8 264 pickup
2593 nobody 18 0 2464 836 472 S 0.0 0.2 1628 0:00 428 580 proftpd
12923 dhapache 18 0 31584 15m 1212 S 0.0 3.9 15m 0:00 316 15m apache2-teguh12
23319 dhapache 15 0 31968 18m 3868 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
26387 dhapache 15 0 31904 18m 3864 S 0.3 4.6 12m 0:00 316 15m apache2-teguh12
27235 dhapache 15 0 31968 18m 3892 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
27244 dhapache 15 0 31940 18m 4048 S 0.3 4.6 12m 0:00 316 15m apache2-teguh12
28332 dhapache 15 0 31912 18m 3864 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
29108 dhapache 15 0 32008 18m 3864 S 0.3 4.6 12m 0:00 316 15m apache2-teguh12
29150 dhapache 15 0 31920 18m 3892 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
29154 dhapache 15 0 31960 18m 3864 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
29577 dhapache 15 0 31992 18m 3860 S 0.3 4.6 12m 0:00 316 15m apache2-teguh12
29636 dhapache 15 0 32024 18m 3860 S 0.3 4.6 12m 0:00 316 15m apache2-teguh12
29642 dhapache 15 0 31928 18m 3860 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
29643 dhapache 15 0 31912 18m 3864 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
30340 dhapache 15 0 31896 18m 3864 S 0.0 4.6 12m 0:00 316 15m apache2-teguh12
2596 daemon 15 0 1768 388 308 S 0.0 0.1 1380 0:00 16 248 atd
So Most of the memories, 12 M each, are taken by dhapach. Each of my site loaded within less than 1 seconds on average. However, somehow I got lots of sleeping process that just sleep for minutes eash...
I called die at the end of my program to ensure that processes finish quickly...
What's typical TOP command in dreamhost look like? Is it common to have lots of dhapache thing?
I recently took over as webmaster for my employer. We want to move to a CMS (Wordpress) for our site. We've had a shared account with Tera-Byte for years. I go to install Wordpress and it says it needs MYSQL version 4 of greater.
Tech support is willing to move me on to a newer server that has MYSQL 4, but doing so would mean copying everything over and reconfiguring anything that needs to be reconfigured (i.e., all our staff's email accounts) from scratch. Is this standard practice?
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.
any problem increasing max_user_connections ? (for example 600)
View 2 Replies View RelatedI've checked the average page download time that the Googlebot reports in Google Webmaster Tools and, from what I've seen elsewhere, I think the number is good -- less than 200 milliseconds. However, my pages are compressed and small (>1.5K). This gives me a download time of ~7500 bytes/sec for the Googlebot.
what kind of page download speeds do others get with Googlebot? What's typical/good/bad?
I believe there is a gap in my understanding of VPS with regards to just how much control you really have over the system. VPS gives you "root access" which typically means top-level access... but in reality, the true super user is a boot-up console user. Few VPS providers that I've investigated offer console access to your VPS while booting.
What, than, can be done about system upgrades or using advanced features like root filesystem encryption? Say, for instance, that my provider offers openSUSE 10.1 and I want 10.2. I would be loath to do such a thing if I can't reboot and watch things as it goes. What if the upgrade failed and you need to drop to a single-user mode to fix it?
Or maybe my real misunderstanding here is that you can't upgrade a system in a VPS if the provider doesn't offer the upgrade?
And what if I want my entire system (other than a boot partition) to be encrypted. This would include an encrypted root and swap. This also requires a password at bootup well before any services (like sshd) start.
Again, maybe the real answer is that I can't do that at all anyway and so it doesn't matter.
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:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=10
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
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 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'm trying to find at least three web hosting companies to choose from to host a Joomla websites on a shared server. Would consider dedicated if the deal was right. I have a friend of mine who wants to create a church website, and is looking for the best deal. I use Netfirms which I have never had an issue with, but I didn't want to be bias, and would like give him other options to choose from.
Is there a good WebHosting Review site, I could check out, or maybe someone could recommend their top three. I reading threw the forums here and I noticed there are not that many complaints with Hostgator. Again, I just want to see if there was anything out there better.
I've taken the scalable approach when it comes to servers for my various sites. With shared servers, I never really worried about backup or even hard drives going down. Same goes for VPS. For some reason, when I moved to dedicated servers, I outfitted them with 74GB SATA drives in a RAID setup. My understanding is that it protects me if one drive happens to fail. I've been lucky and haven't had that problem.
I'm at the point now where I'm looking to upgrade from a VPS paying around $75 per month to a dedicated server. I can stand to be down a day if a hard drive goes, if it means $75 a month in savings. My biggest concern would be suggestions on the best way to protect myself in the event of a catastrophe.
Contacted SoftLayer about possibly adding a second server for me and honoring the price I'm paying on my old server.
Finally, both the old and new site are seeing roughly 3,000 visits per day. The server I'm considering is a Clovertown 5320 1.86 dual quadcore, 4GB RAM, RAID, 2 74GB Cheetah drives,100mbps, 2000GB bandwidth. Is this overkill or the right server for the job?
