Max MySQL Connection On Shared Host
May 31, 2009What is the standard number on maximum mysql connection on most shared host providers and which one give the highest number.
View 11 Replies
ADVERTISEMENT
Host For Remote MySQL Connection
Feb 21, 2008I have developed a desktop system that uses MySQL data.
I want to use a host to access the data but my current provider only allows access to MySQL data via a web server.
Can anyone suggest a host that would provide direct connection to a MySQL database?
Shared Host , Reliable Mysql
Apr 16, 2009I know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one.
I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc.
What I don't like about Dreamhost:
a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads).
b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership.
c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail.
What I like about Dreamhost:
a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too).
b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage.
So, who is my next low-cost host?
a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this?
b) I wouldn't mind moving to a reseller account
c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage]
d) I'd like to stay in the $10-20ish a month range
Reliable Shared Host Plan With PHP 5.2.+ With PDO Drivers & MySql 5.+
Dec 14, 2007I switched to HostGator because they had PDO drivers enabled on shared hosting plans with PHP 5 & MySql 5. The problem is that every time they update PHP (4 times in 8 months now) they don’t include PDO in the build and its takes day to get past level 1 support and get it fixed.
So I’m looking for a “Reliable” host. I had a hard time when I switched to HG finding shared hosting plans with PDO enabled.
Cheap Dedicated Server With 1Gbps Shared Connection
Jul 14, 2008I currently have godaddy dedicated server and the 100mbps connection is shared with other servers, and I pay about $120 a month. I normally get an average of 30mbps out of it. Do you guys know of any cheap hosting companies that offer dedicated servers with a 1Gbps shared connection? And the main point I'm trying to get to is, do you guys know of any web hosts that would be faster than an average of 30mbps, even if they're only 100mbps shared connections? I'd really appreciate any potential hosts you guys can direct me to that are pretty fast.
View 3 Replies View RelatedMySQL Connection
Jun 8, 2007I have a database server – mysql.xx.com which is the main MySQL server in H-Sphere.
I've created a database from mysqladmin interface.
I can use the database without a problem but when I’m trying to access the database from another server that I’ve just installed, the PHP application says that it can not connect to the database.
Another thing is that if I move the php app with the same configuration file under a shared account under another H-Sphere server, it's working perfectly.
I’ve read the H-Sphere documentation about an option to enable remote access to the mysql server which I can’t find anymore under our H-Sphere 2.5 Patch 8.
I’ve done a lot of searching to see how can I make that PHP application to connect to mysql.xx.com but it seems that although I’ve run the command grant all …. Command for that database, it still doesn’t work.
One final thing – from that new server if I run "mysql –h mysql.xx.com –u user –p" I can connect to the database and do a use database, show tables etc.
From iptables on mysql.xx.com I see that it accepts connections from outside.
This issue of not getting that PHP application to connect to mysql.xx.com can be related to the fact that H-Sphere is using the server or what should I try further?
MySQL Connection Fluctuates
Oct 1, 2009I'm trying to diagnose where my problem is coming from.
I have a site hosted with Integra Telecom. The site is connecting remotely to a MySQL database hosted on Media Temple.
My problem is that the site's connection to the MySQL database seems to be fluctuating throughout the day. Sometimes the site is up, sometimes it's down.
When it was down, I got the error: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
So is the problem with Integra Telecom or is my problem with Media Temple?
Mysql Persistent Connection
Nov 3, 2009Currently mysql.max_persistent and mysql.max_links are set to -1 which means unlimited
to optimize mysql, should i keep this unlimited or is it good to limit this? If i have to limit it, what is the best value that I can put there?
Windows - MySQL Too Many Connection..
Jul 15, 2008I have win2003 server and running plesk 8.4, there is a website on it and it gives me error with mysql max_connection even I set the limit 1 million or 10000 no matters.
View 3 Replies View RelatedZymic.com MySQL Connection
Mar 18, 2008We have a front end server for the website Zymic.com (a free web hosting community), a mysql server and a main server for hosted websites. The problem lies between establishing a connection from the Zymic.com server to the database server - to sum it up, the connection just "hangs". We have never had this problem before, never edited anything which would cause a problem, its completely spontaneous.
My administrator has spent endless hours trying to debug the problem, here are some notes he gave me:
1. Ping to the mysql machine works fine.
2. Telnet to port 3306 of the mysql machine works great too – meaning NOT a network issue.
3. Strace on the connection shows it hangs when it calls the server and waits endlessly for response.
4. The mysql machine listens to the IP and port 3306 and connects great to the hosting server via SSH.
5. It's NOT a max connection issue but something to do with the mysql socket itself.
Here is a test from another site on the server to the mysql server:
[url]
Code:
<?php
mysql_connect('75.126.138.74', 'wkscript', 'PASSWORD') or die(mysql_error());
mysql_select_db('domains_data') or die('SELECT ERROR : ' . mysql_error());
?>
LiteSpeed - Connection To Mysql
Dec 21, 2008I have setup LiteSpeed and I have got a problem with php and mysql.
It seems php can't connect to mysql. At every script which use mysql(like phpbb3, phpbb2 etc) I getting errors
SQL ERROR [ mysql4 ] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]
phpBB : Critical Error
Could not connect to the database
Lost Connection To MySQL
Dec 7, 2007MySQL Error : Lost connection to MySQL server during query
I get this error around 10 times a day and the MySQL server goes down
Here are my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 650
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Remove Server MySQL Connection
May 13, 2009I bought a VPS to run a part of a application I have and it needs to connect to my database in cpanel. I have set everything up properly and allowed the remote server to connect to my server, I updated the DB connect file with the correct mysql server username and password. But when I try and run the script I get this error.
Quote:
Client does not support authentication protocol requested by server; consider upgrading MySQL client in
I'm not 100% sure what to do. I don't understand why it wouldn't work because it works perfectly on the main server with my scripts. But I get that error message on the remote server.
Allow User To Remote Mysql Connection
Aug 15, 2008how to allow user to remote mysql connection from his localhost ( in linux server with WHM )
my user wants to connect to the mysql from his localhost
Failcnt Error #422: Cannot Initialize Connection To Remote Host
Dec 23, 2008my site is working fine for somedays and suddenly its stoped and hanged and also my PPP is not working , and file manager in PPP its give me this error
VZAgent returns error #422: "Cannot initialize connection to remote host"
and the suppord admin said I have problem in failcnt
[root@server ~]# cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
1592: kmemsize 18353610 18355203 65536000 65536000 0
lockedpages 0 0 256 256 0
privvmpages 166455 171964 262144 262144 119810
shmpages 4885 4885 131072 131072 0
dummy 0 0 2147483647 2147483647 0
numproc 150 150 600 600 0
physpages 101554 108439 0 2147483647 0
vmguarpages 0 0 196608 196608 0
oomguarpages 101554 108439 196608 196608 0
numtcpsock 141 141 600 600 0
numflock 7 8 300 330 0
numpty 1 1 16 16 0
numsiginfo 0 1 384 384 0
tcpsndbuf 2350036 2625064 32768000 36864000 0
tcprcvbuf 2310144 2129920 32768000 36864000 0
othersockbuf 32976 573000 32768000 36864000 0
dgramrcvbuf 0 4284 1024000 1024000 0
numothersock 32 32 600 600 0
dcachesize 642510 653661 8192000 8192000 0
numfile 2636 2663 20000 20000 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 228 228 700 700 0
I want to know what is my ram site and why that all errors?
Lost Connection To Mysql Server During Query
Aug 12, 2007some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1
I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.
Is there any idea why and how to fix?
Cpanel Mysql Remote Connection USE EXIST DB
Jun 29, 2009A have set up a cpanel with remote mysql server.
My demo config:
cpanel:
centos VPS with cpanel WHM (demo)
mysql:
debian VPS
the configuration is OK, it works.
We have got 200 customers, and we will to change to cpanel.
The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
Connection To MySQL Hangs 2-3 Times/hour
Jan 10, 2007I just got a new server and discoverd very strange problem. It happends 2-3 times every hour. When I try to access some webpage which connects to MySQL, I get page header and then page hangs for some 1 minute. After some 1 minute everything is back to normal. I can open several windows with different websites hosted on my server and the same problem is in all windows. At the same time I can access al websites without MySQL connections.
I have Fedora Core5
MySQL version 5.0.27
MySQL Remote Connection Problem After A Heavy Usage
Aug 8, 2008I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously.
Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts).
After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
Bastille Firewall Causing Mysql Connection Errors
Jan 27, 2008The main function of my dedicated server is the vBulletin forum that we run.
Ever since I had bastille firewall installed and configured on my server we have been getting regular vBulletin errors.
Everything runs pretty smoothly most of the time, we can carry lots of connections without any issues, server has plenty of free RAM and CPU is never overloaded even during peak hours. I have been told bastille firewall (iptables) is configured correctly, all ports that need to be open are open.
But about twice per day we have a MySQL "disconnect" that lasts about 30-60 seconds per incident. For example we will start getting the following message via e-mail, and it will amount to 20-30 e-mails like this during the 30-60 second incident. After that, the e-mails and problems will go away, until next time.
vBulletin Database Error!
mysql_connect(): Can't connect to MySQL server on 'sql.datacolony.com' (4)
/hsphere/local/home/site/site.com/forum/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Saturday, January 26th 2008 @ 07:53:05 PM
Script : [url]
Referrer : [url]
IP Address : 92.3.190.54
Username :
Classname : vb_database
The server is running CentOS 4.6, PHP 4.4.7, MySQL 5.0.45. The vBulletin software has been patched to the latest version. The vBulletin people are not sure why this could be happening.
Well we never believed that the firewall was causing the issue BUT it only started happening on the day the new firewall was installed. So we tried stopping the firewall for a full week and the MySQL database errors stopped happening, completely. So I'm convinced the problem is the firewall blocking MySQL connections but I can't figure out why?
There are no entries in the MySQL .err logs pertaining to this. Can't figure this out, any help or ideas is appreciated since the people who installed the firewall are not sure either.
Looking For New Linux Shared Host
Jun 27, 2008Requirements:
No less than 2GB storage
No less than 10GB transfer
SSH access (mandatory)
php5/mysql
pop/IMAP (IMAP is a biggy for me)
ruby on rails (would be nice)
multiple subdomains
datacenter located in texas or surrounding region
Under $12/mo. No signup fees. Month to month payments.
Is this doable?
Recommend A Shared Host
Jun 8, 2009after posting here at WHT ive really learnt much about overselling and cpu usage.
now with some questions again,
1GB space
around 50gb transfer
around $6 a month
hosted in USA
very well established company that would never shut down like tomorrow.
just list the hosts down and let me consider them.
How To Pick A Shared Host
Apr 1, 2009I've used two different shared hosts in the past. First host had little to no support and got slower and slower as time went on. Second host, has been fine for my personal blog and portfolio site, but the load time is way slow at certain times of the day.
How in the world do you find a shared host that is actually going to be fast? I know you don't want a host that is over-selling, but how do you know a host is overselling? I assume any host that is less than $10/mo and has unlimited everything is going to be oversold, but how do you find one that is going to be responsive. Trial and Error? I've been trying to read the reviews on sitepoint, but I feel like a lot of the time the reviewer is unaware of site load times.
I don't mind doing the research myself, but I can't figure out where to look or how to look.
All I want from my host is fast load times, all the time. I don't have huge traffic, I do have a lot of files, and it's very important when someone comes to my site it loads as fast as possible.
Obviously cheaper is nicer, but I don't mind spending a little extra to have a server that loads fast.
Recommend A Shared Host
Feb 11, 2009Does anyone have any recommendations for a GOOD shared/reseller host? Geekstorage has had good reviews here, but I've been sorely disappointed in the frequent downtime I've had on two separate servers. Looking to move elsewhere soon if I can find someone else.
So -
Price isn't really an issue. I need at least 20GB of storage. Bandwidth also not an issue.
Shared Host For My Fansite
Oct 8, 2009I had a fansite on Dreamhost but they wont host us anymore. Probably my fault but i didnt see putting pictures in a zip wrong, since uploading pictures to my gallery singley can be tedious.
Anyway i now have myqsl backups for wordpress and coppermine. The coppermine gallery has around 15,000 images. Its a fairly new site which got 200 uniques roughly a day.
I need a cheap shared host, since i have 2 servers already (but my friend is unable to tell me the details due to health) So im looking for a cheap shared host, that i will pay a yearly sum. I also need this host to restore my fansite since i have no clue what to do with these backups. So my rough budget is 1-3 dollars per month. I have looked around on
Last night i got messed around by ServerRhino - i wont post again what happened but basically i paid for a year package, waited as long as i could before i had to go to bed for the ftp login, i wake up to find ive been refunded with no explaination. All this has made me very angry as i thought il wake up today and have my site back.
The main thing im looking in the host is good support and cheap enough. I also may want to host a second site on it in the future.
Recommendations? Windows ASP.NET Shared Host?
Sep 7, 2008I'm looking for a good ASP.NET Windows shared host. Here is my current experience thus far:
- WebStrikeSolutions - Excellent web host but doesn't offer MSSQL as part of base package.
- WebSecureStores - Excellent host that does offer MSSQL as part of base package but hasn't updated their website in over a year and hasn't released support for .NET 3.5.
- DiscountASP.NET - Excellent web host, CP is a little wimpy, doesn't offer MSSQL as part of base package.
For me, the essential features are:
- Reliable, reasonable performance (especially uptime).
- Includes MSSQL databases (limited number, but at least 3-5).
- Can handle CMS sites like DotNetNuke without significant slowness.
Deal With Outages On Shared Host
Mar 24, 2009I run and maintain many websites on a shared server (ICDSoft)
While I am extremely happy with their service and support, the outages are still a problem when they happen. Especially for the e-commerce customers.
They are beginning to ask what do we do in this situation? Generally I reply, there is nothing to do but wait in this situation.
Shared Host <$5/mo - 10+ Addons, 1gb+ Bandwidth
Jun 7, 2009I tried to put as much as possible into the title
I've had asmallorange for like 6 years now, was great host but lately uptime seemed to suffer a bit. Searching for some new one to try.
Could You recommend a cheap less than $5/mo shared hosting?
What I need:
highest uptime available, 99.8 or above would be great
use more than 10 websites with them, addon domains feature.
bandwidth above 1 gig, maybe above 5, not sure.
support doesn't matter that much, cause I almost never ned to contact them, lol
another thing I'd prefer is to use company's details in WHOIS info - that's really kind of important. Don't like Godaddy's $10 service. Just don't want to pay.
Shared Host With .jar And .mp3 Files Support
Mar 3, 2009I am a mobile site developer so tht i need a shared linux host for uploading contents like java applicaations,.jar files,.mp3 files etc any one please help me to find a suitable host with monthly paying suuport
View 12 Replies View RelatedOffshore Clustered Shared Host
May 9, 2008Anyone know some cheap offshore clustered shared host?
View 4 Replies View Related