Anyone know how to kill or prevent a bunch of sleeping mysql processes on a shared linux box? I'm getting up past my max php/mysql connections limit and it's now taking my entire arcade script down (which is onarcade, btw)
I've tried adding a mysql_close at the end of each script, but this hasn't helped. BTW -I use mysql_connect, not mysql_pconnect.
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.
I'd like to start an ongoing thread here listing the 'Good Hosters with Good TELEPHONE tech support'. In other words, out of the 1,000s of host companies, this may cut it down to less than a dozen.
( And for all you Hosters out there who really want your company to grow, and want to know how, - it's easy: just read here.)
Good telephone support is the #1 ultimate requirement, because:
-It's a lot faster and easier for both the user and the host company, because you can state and answer all questions and clarifications on the spot, you don't need to continually pass new emails with new questions and clarifications, back and forth for days on end, until the issue is solved. It saves tech time and user's time. And saves a lot of nerves.
- It's the best way to sort the good guys from the bad. A bad company isn't going to bother to answer the phone, - or will make you wait way too long, - because they are likely getting endless complaints. The good guys are always ready to answer the phones, with a friendly voice, - because they really WANT to please the customer.
- If a company can't be bothered to pick up the phone, we can't be bothered to even consider them. They're a joke, and so won't be listed here on this thread. (So, before adding or listing any Hosters here, please verfify that they do have Good, quick, friendly, telephone support,; ideally 24/7, but 9am to 10pm might be acceptable, if it was supplemented by some emergency contact. AND:
- Hoster ALSO needs good EMAIL support (and preferably, Chat online, extended hour availability). (I spend a lot of time overseas). It sems all emails should get a non-automated response within about an hour, - and then support should jump on fixing any problem.
I only need support a few times a year. To answer some questions, or fix a problem, or do an install. That's lesss than 1 hour total, so any company paying maybe $18/hour tech support should be able to handle this. It IS reasonable to charge a custm for extended calls, beyond say, 90minutes a year, IF you don't count the 80%? Of times an issue is the Hoster;s fault of stmg gone wrong, and don't count the 'hold' times.
ALSO IMPORTANT: - Uptime - site Speeds - Monthly plans, no contract (Only a dishonest host will try to force you into a contract, where they can then ignore you.) - Reasonable price. (? Maybe $12 to $18/month for a basic business site. We don't need massive bandwitdths, - we all know that's an overselling scam, and can't ever be delivered.) - a good upgrade plan of bigger options. Maybe even VPS. - Dedicated IP, and availbility of SSL -PHP 5, mysql, phpMyAdmin, etc - cPanel ( Some Hosts are using problematic panels, like Hsphere, which are slow to load, slow in operation, require many more clicks, have too many options, spread apart on many separate pages. Time is money, and this really slows down the ability of a small business to manage his own site in effective time. For example, one WHT user wrote somewhere: "I don't feel that HSphere's interface is nice at all, although I have worked with cPanel and DA all my life... I just found it to include un-necessary features or split features up in to different hard to find pages, such as backups - mysql backups you had to find on a completely different page than file backups, and then there were options to have it in the home directory or server-end backup, in which then you had to wait a good 10 minutes before it was ready. cPanel, just hit backup and hit download and instantly it does everything you need...".
I have used several hosters. Currently on Aplus.net and Godad, which have phone support, and mediocre service.
My LIST So Far: - Liquidweb: a very impressive company with good, 24 hour support. But to get dedicated IP, you need to go with their $25/month plan. Yikes! - NewIdeaHosting.com. A very small company. My call was returned, and the owner chatted with me for an hour on the phone! Plans have small bandwidth, but promises No overselling, and personalized attention. Extra $5 for dedi IP. He specializes in Small business sites, and small eCommerce sites. He has only 250 accounts, on 3 servers. He rents servers from the Equinox data center of Chicago. Seems exceptionaly honest. - MegaHosters. Excellent phone support and WHT reviews. But company was taken over by another company, and so may well go downhill in future. Another problem: uses Hsphere. - Steadfast. Has a good rep on WHT, and seems impressive. Tech answered the phone immediately, but they say they prefer emails. Sales phone has limited hours. Good price on $20 SSL. But, uses Hshhere. - JodoHost 24 hour phone. But, uses Hsphere. An Indian company with office in Florida, and good rep. I like the idea of outsourcing phone support, if it makes it more available and affordable. But, the accent on the phone was very hard for me to understand, so maybe this might not work..... - Hostgator. Yes, it's a big overseller, but seems to get good reviews/results anyway, and good phone support. - ? ThePrimeHost ?? Mostly good WHT reviews; some dissenters. Site says 24hour phone, but when I called on several nights, no one ever answered... - Can anyone add to this list? Please list only hosts that meet the above minimum requirements of phone support, etc. Especially useful is hosters you've tried. TO AVOID: - Avoid Arvixe. I had a horrid experience with them, here: [WHT forum]:/showthread.php?p=5097822#post5097822 - Avoid WebHostingBuzz. This company never returned my phone msessage inquiries.
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?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
I have dedicated servers - which are overkill as I only host 10 sites (small). I am now looking to move to a VPS solution and would like to know if anyone can recommend a good UK company (that offers true UK hosting) with good uptime and support?
Cpanel and Unix VPS, but may also require windows vps - so a company that offers both will be beneficial, but long term view to migrate over to Linux
my web site has about 4,000 pageviews and currently working fine on shared host. i plan to build a forum to support my products. i just want to know if the 128 MBs VPS is good plan for my web site?
40 GB Disk Space Fairshare of a Dual Xeon/Opteron CPU 512 MB Dedicated RAM 2 GB Burstable RAM 750 GB Premium Transfer Fully Managed
I have about 10 sites that run straight HTML and 5 WordPress low traffic sites (which obviously use a database). Will the server above support my needs adequately?
I need managed services since I don't know anything about server maintenance and I saw LunarHosts VPS (http://www.lunarpages.com/virtual-private-server/)
The deal sounds pretty good - 1000 GB Bandwidth, 20 GB Space, PHP, MySQL and managed services for $50 a month.
I wanted to know if anybody has tried them out? Are they good? Is their a better value anywhere else?
I was looking for a webhost with adwords credit, and cheap.
When I went to Bluehost and Hostgator, the more well-known sites they had $50 adwords credit each but couldn't get their price down to less than 58$ a year. With Fatcow seems to be $44 a year and also have $50 adwords credit.
Does somebody know their reliability? I was searching google and the host seems to be a new person in town and that might be a problem.
Preferably I was searching for $20 a year webplans but I can't seem to find one with adwords credit. I want to use the adwords to drive quick traffic to a new site. I am not sure should I go for the adwords credit+ hosting or hosting seperate + adwords seperate. The keywords I'm gonna use only have 1,000-10,000 max visitors a month. If the credit is only valid for a limited time than I'd maybe better off with a both seperate.
After speaking to a colleague about some major benefits of EC2 for on-demand hosting I've been very interested in learning more.
I've spent the past 2 evenings trolling through Amazon Doc's and blog posts and have a fair assessment about how things work but I'm at a stopping point.
There doesn't seem to be a dedicated EC2 area here on Sitepoint and the Amazon EC2 forums seem geared more towards 'advanced' users.
Are there any reliable communities that are more for the beginner?
I've got a LAMP webserver Instance running on EC2 but I'm very unclear about how to login and begin adding files and managing the data. I'm sure it's pretty simple but the documentation pretty much loses me when they start discussing Security Groups and public/private keys.
I'm not much of a server admin but have grown pretty comfortable on our FC4 dedicated boxes that we currently host on.
I'm interested in getting a VPS (nothing too much - probably at least 5-10GB space / 30GB bandwidth) for a forum I run based in Australia. My budget is probably around $40/month. BTW I'm after managed.
My main issue is that I would like it to be a decent speed for Australia (specifically Melbourne). Where should a datacenter be located for Australia?
i'm planning to get a dedicated server at voxel.net cuz it seems that they have a very large scale and the price looks reasonable for the dedicated bandwidth and server i need.
