Best Host For Fast MySQL Connections
Aug 12, 2008for a linux web host that has extremely fast mysql connections, 100GB of bandwidth, and the amount of space has to be at least 1GB. Price doesn't really matter.
View 8 Replies
ADVERTISEMENT
Fast UK Host With MySQL Support
Apr 18, 2008I currently run a website which is hosted with storminternet.co.uk and, while I can't fault their reliability, the (lack of) performance is undermining the usefulnes of the website.
Key features of the website are:
- completely MySQL/PHP driven so the host needs MySQL support and processor power . Some of the MySQL queries are fairly complex and call upon multiple tables of large datasets.
- monthly bandwidth is much less of an issue than speed (if that's not an oxymoron) as the number of visitors is currently <250/day.
- most if not all of the visitors are from the UK
In terms of budget I would be willing to go £150+/year if the service was top quality.
Fast Host
Feb 5, 2009anyone know or can recommended a good and fast host? for share plan
View 14 Replies View RelatedIs There A Fast Web Host Out There
Dec 14, 2008Is there a webhost fast enough for providing large files (2.5GB +, going up to 10GB + larger) on my website to users worldwide?
At the moment my website is hosted in the UK and it seems to deliver download speeds of around 650kbps if only one person is downloading at a time. I have tried other web hosts, and their download speeds are never advertised, but have turned out to be even less in practise (e.g. 150kbps)
As I'm hosting large files (e.g. 1GB - 2.5GB - 8.5GB or more) on my website, I need something with unlimited speed. i.e. so that the download speed is limited only by the end user's connection.
Is there anything like this out there? I realise the files are very large in size, but I'd rather keep the process electronic than mail out hundreds of DVDs all the time.
Finding A Fast Host
May 4, 2008I have a site that is currently hosted in Australia and loads relatively quickly there , but it is very slow in Uk and France.
Eli kindly set up a trial at blurstorm but I am unhapy with the way it loads in australia which is its primary audience.
how to get my speeds up with the site? ATM there is a 2.8 mb swf file that loads in about 5 sec in aus but about 20 in europe.
Blurstorm is faster in europe(france)but unacceptably slow in Aus.
Is blurstorm considered fast servers on their reseller plans? Or do I need to upgrade my expenditure to get what I want?
Host With Fast Network
Sep 19, 2008fairly strong dedicated server probably minimum of a single processor dual core, preferably a quad-core and around 2GB+ RAM. I don't mind a metered bandwidth plan and I don't have a preference on how much bandwidth is provided but I need a fairly solid and fast network. I looked into midphase and I their plans look attractive but I've heard bad reviews on them on it being unreliable, unreliable support, and a slow network. I also recently used zenex5ive and I wasn't too happy with their network either. I've looked at a bunch of providers but I can't figure out which ones would suit me best. Anybody have any suggestions that you think would match my criteria? I mostly need the specs above and a fairly fast network with good pricing...
View 14 Replies View RelatedHost Which Would Set Up Server Or VPS Fast (up To 1-2 Hours)
May 19, 2008Somebody posted a video in my website which got viral. Many big websites (like gizmodo) embeded it and I've maxed out my 100mbit/s connection. Traffic is increasing and my website started crashing.
I want to move that video to other server ASAP so my website would stop crashing.
Do you know any host which would set up server or VPS fast (up to 1-2 hours)?
Fast And Large HD Space Host For Cheap
Jul 28, 2008Who knows a good host that offers PHP5, mySQL 5, and at least 1 TB of hard drive space for a cheap hosting account.
I am setting up a digital asset management tool and I need alot of hard drive space for a few of users to be able to download large image files.
Which is why i need massive amounts of hard drive space.
If anyone knows of anything, please PM me or post it here. I will be checking this thread periodically.
OH and by cheap I mean less then $100/month.
I would guess the server could be either VPS or Shared or if you know of a dedicated server company, then that would be awesome too.
VPS Recommendation With Fast Mysql And Redundancy
Nov 20, 2008I have a mysql based e-comm site that works only with older version of php and mysql. My shared host does not meet this requirements, so I have to go with a dedicated or vps.
I am looking for a server to have a fast mysql query.
Is there any vps providers that offer redundancy of the server, meaning if the server crash there should be a standby sever to take over?
Fast MySql Access- Localhost
Aug 2, 2008I've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast!
However, now I'm trying to find a shared hosting package that has fast MySQL service.
I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt.
Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
Mysql Version Best Stable And Fast
Jan 26, 2007Which version of Mysql is proven to be the most fastest and stable
View 3 Replies View RelatedWhat Is A Fast Host That You Users Can Post Adult Content?
May 8, 2008looking for a a quality webhost where users can post adult content. Know any?
View 6 Replies View RelatedHost With Max Concurrent SQL Connections
Apr 23, 2008Iam 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.
MySQL Max Connections
Jan 16, 2008My PHP application is starting to reach max mysql server user connections limit (currently set to 60). I listed mysql process list in phpmyadmin and found there lot of queries with status "LOCKED" these hang there for a long time(not always just sometimes - twice a day) and then connection limit is reached. It causes load average about 40 for as long as 10 - 20 minutes
I think it may be bacause of query structure. There are some queries with many inner joins...
Here is typical situation from phpmyadmin's process list:
1. select ... from table_1
inner join table_2
inner join table_3
inner join table_4
inner join table_5
This show status : "Copying to tmp table" in phpmyadmin
2. update table_2 set ....
This shows status: Locked
3. select ... from table_2
This shows status: Locked
Seems then when temp table is being created the table_2 is locked and it cannot make update to table_2. or maybe it's locked because of just that update on table_2.
I want to avoid of creating temp tables... Can it help if I'll make separate selects without large table joins ?
MySQL Max- Connections
Jan 7, 2007I'm currently using MySQL 4.1.12 for Windows 2003, and I need to know how much possible connections can MySQL achieve? I'm currently around 650. I'm having 4 new servers online, and that will bring my total concurrent connections to 1000+.
how high it can go?
MySQL Connections
May 24, 2007I notice that most hosting have limit of mySQL connections.
If the max mySQL connections is 50 and I run a forum on this hosting,about how many people can visit my website at one time?
Fast Webhost, Little Disk Space, With Php, Mysql, Phpmyadmin, And Alot Of Bandwidth
Apr 1, 2008The most important requirement is that the webhost must be fast. It must have alot of bandwidth.
The disc space is not so important. 200 MB would be enough.
It must have PHP, MySQL and phpmyadmin installed.
Must be accesable through FTP.
There are offcourse more requirements. But the main thing is that i want it to be fast.
My pages will be only informative and exists of just mainly text and an image every now and then.
Do you know any fast webhosts that is good to handle websites with large amounts of visitors?
I'm looking for something around 6 dollars per month.
I dont know much about webhosting at all, so i'd appreciate any help i can get
Also i see websites where you can register a domain. But the prices vary, isn't a domain just a domain? What makes this price difference?
Closing Mysql Connections
Feb 18, 2007from what I view, wait_timeout is used for disconnecting connections. However, it applies to tcp/ip connection only. So, in my database connection, if I am using mysql server as localhost, that variable is not applied? In that case, how can I close connections automatically after xxx seconds?
View 8 Replies View RelatedMysql Connections Topping Out Within Seconds
May 13, 2009i have a small cluster (one web and one db) setup and i host a rather popular group of 4-5 sites that allow users to dynamicly create their own mobile chat communitys automaticly. each site gets its own mysql db created and populated automaticly.
this is all fine,
but in the last 24hours weird things have begun happening, previously i had the sql max_connections set to 500 and this was perfectly adquate for the demand but now even when i set the connection to 4000+ they are all maxxed out within 5-10 minutes, and mysql processlist shows thousands of unauthenticated user connections sitting at login status,
i have gone through the sites and all their mysql configs are fine so i cant see what the issue is.
server specs below
db server:
dual amd opteron 246
8GB ram
120gb hd(64gb free)
33gb swap (rarly used but their for emergencys)
centos 5 64bit.
direct 100mbit lan to web serv
only mysql,ssh and webmin running, no other apps installed
web server:
amd athlon 64 3800+
plesk 9.2.1
4gb ram
2x120gb hds
apache status onthe web server only shows 120ish http connections but the sql keeps climbing
MySQL Timeout On Active Connections
Oct 21, 2009unfortunately my server crashes a lot recently. What happens is that some application creates a MySQL connection which hangs and then MySQL gets overloaded and takes the whole server down.
My question:
1. How do I configure MySQL to time out even on active connections ? I.e. after 30 seconds kill the process no matter if it is still active or not. Is that possible ?
2. How do I exclude the root user from that?
[MySQL] Too Many Connections: Locked Queries
Dec 17, 2008This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist:
Code:
| 14773848 | db_name | localhost | db_name | Query | 35483 | statistics | SELECT COUNT... |
| 14776290 | db_name | localhost | db_name | Query | 35144 | statistics | SELECT COUNT... |
| 14778877 | db_name | localhost | db_name | Query | 34841 | statistics | SELECT COUNT... |
| 14790744 | db_name | localhost | db_name | Query | 33056 | Locked | UPDATE... |
| 14791275 | db_name | localhost | db_name | Query | 32977 | Locked | SELECT... |
| 14791395 | db_name | localhost | db_name | Query | 32960 | Locked | SELECT... |
| 14791556 | db_name | localhost | db_name | Query | 32929 | Locked | SELECT... |
| 14791603 | db_name | localhost | db_name | Query | 32924 | Locked | SELECT... |
| 14791757 | db_name | localhost | db_name | Query | 32900 | Locked | SELECT... |
| 14792209 | db_name | localhost | db_name | Query | 32815 | Locked | SELECT... |
| 14792355 | db_name | localhost | db_name | Query | 32786 | Locked | SELECT... |
This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?!
Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.
MySQL Stops Allowing External Connections
Apr 3, 2008Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server.
I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine...
It's not like it's a firewall issue though, it's strange...
I tried updating PHP/MySQL to a few releases, even the RC's to no avail...
Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
How To Limit Http/mysql Connections Per Domain
Jun 22, 2007how i can limit http and mysql connection limit on per domain basis.
View 2 Replies View RelatedBest Host For ASP/PHP/mySQL
Feb 24, 2009My current web host (SectorLink) has been acting flaky lately so I'm in the market for a My requirements are at least 6GB of space, the ability to run multiple websites on the same account (I'm currently at 7) and ASP, PHP, and mySQL capabilities. I'd also like the price to be competitive with what I'm currently paying ($11/month) though I'm willing to go up a bit.
I'm currently looking at 3 hosts, but I'm open to any suggestions. My short list right now includes:
HostGator - Not a Windows host, I know (though they're working on Windows plans), but they do offer ChiliSoft ASP capabilities. This host would give me unlimited space and domains for $14.95 per month.
AllReseller - This host would give me 50GB of space and unlimited domains for $11.95 a month.
Aspnix - This host would give me 10GB of space and 7 domains for $7.77 a month.
Has anyone used any of these hosts? What were your experiences with them? Could you recommend any other hosts? Side Question to any classic ASP developers out there: Have you used ChiliSoft ASP and, if so, how good is it at running scripts originally written for IIS?
PHP 5.2.x & MySQL 5.x Host
Aug 27, 2008host with PHP 5.2.x & MySQL 5.x.
- under 10$/month (monthly payment)
- at least 15 multi sites allowed.
Better Mysql Host
Jul 4, 2007my site is mainly based upon mysql ...mean I need to insert 25-30 mb data everyday .I saw several webhost saying 5 gb space ...does it mean i can store 4.5 gb data in mysql ? lets take that i will use only 0.5gb to store file&codes.
View 6 Replies View RelatedMysql And Ms Sql Host
Nov 7, 2007I am trying to find a reliable host that can provide both mysql and ms sql for the same site. I know this is not how the site should be designed, and a complete redesign is in the works to streamline everything to mysql, but for now I need a host that can provide both. Our current host is absolutely horrible (seekdotnet.com) as there is an excessive amount of downtime (typically a few times/day for various periods of time). Thus far the only one I have been able to find is Mosso, but it seems a lot of people on here are anti-mosso, or have had problems with mosso.
View 7 Replies View RelatedBest Host For Legacy Php < 4.47 And Mysql <4.1.21
Aug 3, 2009Looking for linux and the above, on shared or virtual plan. A number of sites will be on the account and can run sites without 'www' .
phpmyadmin, real FTP's (non anonymous), SSH/SFTP access, decent uptime, spam filters and support in place. No outsourcing of support, and they house their own servers.
Remote Mysql Host ...
Apr 24, 2008but first, is it a good idea to have mysql on a remote server? let's say my app makes about 400 reqs per second.
View 2 Replies View Related