Recommend A UK LAMP Host - With Some Specific Mysql Privilege Requirements
Dec 13, 2008
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible.
So, I need another UK host with:
- 2Gb of space (the site serves up big PDF documents)
- 70Gb of bandwidth (I said they were big)
- mysql privs available as above
Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological £10/month barrier which I don't want to cross.
View 2 Replies
ADVERTISEMENT
Feb 20, 2008
I have a cople of dedicated servers. Both run the same software, phpBB forums. However, with the top command I see one of them need as much as triple memory for every apache process than the other. Here are the details:
Server 1
Hardaware: Dual Opteron 2212 + 4 GB RAM + 2 SAS 146 GB drives. CentOS5 x64
uname -a
Linux s1.tp.netmanaged.net 2.6.18-53.1.13.el5 #1 SMP Tue Feb 12 13:02:30 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
ps auxf
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 10316 684 ? Ss Feb14 0:03 init [3]
root 2 0.0 0.0 0 0 ? S Feb14 0:11 [migration/0]
root 3 0.0 0.0 0 0 ? SN Feb14 0:01 [ksoftirqd/0]
root 4 0.0 0.0 0 0 ? S Feb14 0:00 [watchdog/0]
root 5 0.0 0.0 0 0 ? S Feb14 0:25 [migration/1]
root 6 0.0 0.0 0 0 ? SN Feb14 0:02 [ksoftirqd/1]
root 7 0.0 0.0 0 0 ? S Feb14 0:00 [watchdog/1]
root 8 0.0 0.0 0 0 ? S Feb14 0:00 [migration/2]
root 9 0.0 0.0 0 0 ? SN Feb14 0:00 [ksoftirqd/2]
root 10 0.0 0.0 0 0 ? S Feb14 0:00 [watchdog/2]
root 11 0.0 0.0 0 0 ? S Feb14 0:00 [migration/3]
root 12 0.0 0.0 0 0 ? SN Feb14 0:00 [ksoftirqd/3]
root 13 0.0 0.0 0 0 ? S Feb14 0:00 [watchdog/3]
root 14 0.0 0.0 0 0 ? S< Feb14 0:00 [events/0]
root 15 0.0 0.0 0 0 ? S< Feb14 0:00 [events/1]
root 16 0.0 0.0 0 0 ? S< Feb14 0:00 [events/2]
root 17 0.0 0.0 0 0 ? S< Feb14 0:00 [events/3]
root 18 0.0 0.0 0 0 ? S< Feb14 0:00 [khelper]
root 55 0.0 0.0 0 0 ? S< Feb14 0:00 [kthread]
root 63 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kblockd/]
root 64 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kblockd/]
root 65 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kblockd/]
root 66 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kblockd/]
root 67 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kacpid]
root 180 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [cqueue/0]
root 181 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [cqueue/1]
root 182 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [cqueue/2]
root 183 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [cqueue/3]
root 186 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [khubd]
root 188 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kseriod]
root 279 0.0 0.0 0 0 ? S< Feb14 0:40 \_ [kswapd0]
root 280 0.0 0.0 0 0 ? S< Feb14 1:02 \_ [kswapd1]
root 281 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [aio/0]
root 282 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [aio/1]
root 283 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [aio/2]
root 284 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [aio/3]
root 436 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kpsmouse]
root 497 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [scsi_eh_]
root 503 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [ata/0]
root 504 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [ata/1]
root 505 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [ata/2]
root 506 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [ata/3]
root 507 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [ata_aux]
root 513 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [scsi_eh_]
root 514 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [scsi_eh_]
root 515 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [scsi_eh_]
root 516 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [scsi_eh_]
root 517 0.2 0.0 0 0 ? S< Feb14 17:38 \_ [kjournal]
root 549 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kauditd]
root 1184 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kedac]
root 1700 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kmpathd/]
root 1701 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kmpathd/]
root 1702 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kmpathd/]
root 1703 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kmpathd/]
root 1734 0.0 0.0 0 0 ? S< Feb14 0:03 \_ [kjournal]
root 1736 0.0 0.0 0 0 ? S< Feb14 0:00 \_ [kjournal]
root 3220 0.0 0.0 0 0 ? SN Feb14 1:59 \_ [kipmi0]
root 5770 0.0 0.0 0 0 ? S 00:15 0:02 \_ [pdflush]
root 12519 0.0 0.0 0 0 ? S 00:48 0:02 \_ [pdflush]
root 583 0.0 0.0 13480 1624 ? S<s Feb14 0:00 /sbin/udevd -d
root 2272 0.0 0.3 23588 13780 ? Ss Feb14 0:00 /usr/sbin/rest
root 2287 0.0 0.0 81800 772 ? S<sl Feb14 0:03 auditd...
Do you realise that the x64 Opteron is needing an avarage 1.7 %MEM for each Apache process while the Xeon just needs 0.5 %MEM?
Since both use the same version of phpBB and the same version of CentOS5, while the only difference is one is x64 and the other i686, I wonder if this has to do with the way memory is handled by the x64 CentOS5.
View 3 Replies
View Related
Jun 26, 2008
I am using Cpanel. One Cpanel account is backup. I use it to backup my database.
Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'.
I gave "lock table' priviledge again and run the script, it is ok.
But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again.
I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View 4 Replies
View Related
Jun 4, 2007
I need some help finding a reliable windows host. I haven't hosted on windows in a long time, and I don't know how to choose. These are the specs:
Requirements:
* Windows hosting
* PHP GD library (installed on most hostings)
* Permissions to execute third-party applications (i.e. exe files)
* Permissions to execute Internet Explorer
I've used Jodohost before and they were ok. Also was considering weberz.com, but I don't if either will meet these requirements. Any ideas?
View 14 Replies
View Related
Jul 1, 2008
if anybody is looking into hosting their own TLD with the new ICANN decision? I'm wondering what the requirements would be? And has anybody seen/heard any mention of what the registration fees are likely to be, I know there will be bidding on names in dispute...maybe this will be the case for every worth-while TLD.
View 6 Replies
View Related
Oct 20, 2009
can anyone recommend a decent nl host with offers at present on dedi servers, looking to purchase in next week
View 4 Replies
View Related
Jun 8, 2009
after 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.
View 14 Replies
View Related
Feb 11, 2009
Does 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.
View 14 Replies
View Related
Nov 30, 2008
I'm finding a new host for my sites. I've searched the forums for hours but there were too many results, both positive and negative that I couldn't make decision . So, I want to ask you, who have been with WHT for long time and read the forum often about some good hosts you have experienced.
Details:
Hosting type: shared hosting (with option to upgrade to VPS)
Disk space: 30GB
Bandwidth: min 100GB
Host provider experience: >= 2 years
Budget: <= $12/ month
Could you please recommend some good hosts here?
If you are not so sure, I'll be very grateful if you give me a short list so that I can search for reviews one more time.
Thanks !
Note:
I may lift my budget a bit if needed.
View 14 Replies
View Related
Jun 24, 2008
any one recommend good flv host? for private sharing of 120 alumni students? videos are mostly farewell stuffs.
View 3 Replies
View Related
Jun 28, 2008
My requirements are:
IIS 7
ASP.NET 3.5
MSSQL () (no more than 5 dbs needed)
MYSQL (no more than 5 dbs needed)
Diskspace 5GB - 100GB
Bandwidth 100GB - 2000GB
Some sort of E-mail Component
Please recommend a reliable windows host for me,
View 8 Replies
View Related
May 18, 2008
I am currently having some problems with my Off-Shore Host, too many downtimes and MySQL errors so I am looking for a new OffShore Web Host. I need a web host that can host: MovieGalaxy.org and it must be offshore. Anybody here has any experiences with a good Off Shore Host?
View 8 Replies
View Related
Nov 24, 2008
Can anyone recommend a host that can host domains on multiple IPs (not neccesarily dedicated) under 1 single account.
We are already using ixwebhosting.com, but we need a lot more.
View 3 Replies
View Related
Aug 10, 2008
if somebody could recommend a good backup host. I already know BQBackup is solid, but I'd like some other recommendations as well (another host, not a reselller of BQ).
View 6 Replies
View Related
Nov 30, 2007
Can anyone recommend a cheap reliable Windows VPS host? My sites (shared) are hosted on Fluid Hosting , I am very happy with their service but their Win VPS prices are too high for me, I just want to use VPS for testing my applications.
I found cheapvps.co.uk searching on WHT, but their support seems to be patchy?
View 14 Replies
View Related
Mar 16, 2008
I'm looking for a managed server (mid range specs) and approximately 20TB monthly bandwidth.
I'm looking for reasonably priced hosts, that have a reputation "very similiar" to Rackspace.com. I don't want to quite pay what Rackspace's pricing looks like. So, I'm looking for something slightly cheaper than Rackspcae, but that have a VERY good record for promptness in addressing issues and with proven uptime records.
So far I am considering Verio & The Planet. My knowledge of hosts beyond that is very limited. Please point me in the right direction as to where I can find hosts with SOLID records like Rackspace.com, but are slightly less expensive.
View 14 Replies
View Related
Jun 9, 2008
I already started a thread, and got suggestions about a host to choose. I selected HostGator, but when i read the TOS of HostGator, they do not openly allow image sharing and do not allow you to keep more than 50,000 files on their server.
So, which host do you recommend me. Please consider:
1. Low cost,
2. Reliability,
3. High shared disk and bandwidth
4. Allow image sharing. (I am not going to share adult images).
View 14 Replies
View Related
Jun 9, 2008
cheap-ish place to host a PROTOTYPE website. We're going to need php + mysql, but we're going to need to have more control such as root SSH access.
Here is the list of what we need to start with:
SSH access
PHP 5
Java
MYSQL 4 or 5
Apache 2
SendMail
Any ISP recommendations?
For now this is just a prototype, and it will NOT get hammered with
traffic. But we do need an outfit that is efficient and reliable.
Ship
Shiperton Henethe
We are based in the UK.
View 11 Replies
View Related
Apr 20, 2009
Couple days ago all of a sudden my host that I've been with for years all of a sudden went down the drain. Why? Supposedly, my site was used for spam? Stupid. They are "trying" to compile my database and files, but I DOUBT that will happen.
With an already 24 hour downtime. I am receiving a lot of emails and phone calls on site. I need my community to get back up asap! So I guess it's time to find a new host.
I need a RECOMMENDATION on a westcoast host that will provide me with great customer service and the requirements I need to run my community.
Must handle vBulletin real well, have the requirements I need, and have great customer service.
This is a local forum, which is why I would like to be on a Westcoast Host.
View 9 Replies
View Related
Jun 5, 2007
I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.
View 0 Replies
View Related
Apr 26, 2009
How can I disable INSERT access to specific table.
The user should have full access the the DB except insert to specific table.
The tables_priv allow to set what enable and not what disable.
I'm using mysql v5
View 4 Replies
View Related
Mar 13, 2013
I am trying to setup a subdomain and/or virtual host to redirect to a specific port and path. I have setup my server with DDYNS through my domain name registar. Through the ddyns client I have set it to assign a subdomain of "outside.name.com" so that my server will have a easy name to get to instead of a dynamic ip address.
I have also setup on my registrars host records another subdomain of "inside.name.com" with a static IP address for internet network accessing to my server.My problem is that I have a service/program on my server that I need access to both internally and externally and this service can only be access through a port of 32400 and HTTP address of /web. (e.g. outside.name.com:32400/web or inside.name.com:32400/web)...
Is there a way that I can create a VirtualHost or Subdomain of "service.*.name.com" that redirects them to ":32400/web" of the hostname they're on? (e.g. service.outside.name.com automatically forwards or proxies--to keep it pretty--to service.outside.name.com:32400/web)
View 1 Replies
View Related
May 20, 2015
I have question: How to redirect specific useragent on specific URLs to specific URLs in .htaccess [Question]
E.g.:
I want to redirect 301 with conditional:
Code:
useragent: Firefox
from my url1: domain[dot]com/old-url1/
from my url2: domain[dot]com/old-url2/
to
Code:
to new url1: in my url1: domain[dot]com/new-url1/
to new url2: in my url1: domain[dot]com/new-url2/
I create this in my .htaccess but not work
Code:
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} googlebot [NC]
RewriteRule ^/?this-is-url/?$ domain[dot]com [L,R,NC]
View 1 Replies
View Related
Dec 2, 2007
I'm currently looking for co-location in the US (preferably West coast) for a 2RU server with a 100mbit port with around 500gb-1TB of bandwidth, with the option to upgrade bandwidth as necessary.
I have two requirements though - first, I need a provider who can do the initial server setup for me. I want to provide them with a blank, empty server and I want them to install the operating system (no control panel), install the relevant software (Apache, MySQL, PHP, Exim) and do an initial server hardening. Obviously expect to pay a higher setup cost for this
Second, I need a provider that does two things - they need to offer dedicated servers as well as co-lo (as I will need a handful of dedicated servers at some point in the future for 2-3 months only), and I need them to be able to place these servers on to a private switch/VLAN so that all bandwidth can be pooled between the servers and used as necessary, rather than having individual port limits. I would probably be looking at needing a 1gbit port in total for these servers (or 100mbit ports to each server). And I need someone that can sustain a data transfer of a few hundred mbits from these servers in terms of their infrastructure and connectivity
So does anyone know of any providers that can offer this? Preferably someone who doesn't charge an arm and a leg (but at the same time, not necessarily dirt cheap) for bandwidth, as I will obviously be using a fair bit
View 5 Replies
View Related
Sep 4, 2008
we have a site with a lot of traffic around 100.000 visitors and 250.000 pageviews daily, each page is just 30k to 60k , we use mssql server and hit our database with a very simple query ( "select, where, order by" type ), is a small table just 9000 records. What windows vps would you guys recommend me for this kind of traffic? What amount of RAM memory? mssql on the same server or shared? would mssql server 2005 express do the job?
View 4 Replies
View Related
Feb 16, 2008
How much does a typical quad core Xeon eat, say an E5410 or a E7320? a 2GB RAM stick? A 500-750GB SATA disk? How much is the system overhead for a 1U unit? I tried to find data on this without too much success. For example Intel says the same number (80W) for an 1.6GHz CPU and a 2.4GHz one -- that does not sound too reliable to me.
If this is too abstract, then I would like to ask aobut the real world power consumption of two boxes. 1 E5410, 8GB of RAM, 2 SATA disk maybe 10K RPM. The other will have two E7320, 24-32GB of RAM and 3 10-15K disk.
View 5 Replies
View Related
Sep 26, 2007
with a single server running PHP and MySQL.
What sort of hosting requirements do you think I would need for...
A site with a mysql db with 100,000+ records in a single table and executing simple select statements on the table with 100,000+ records at a rate of 50 queries per second? (All other things should be negligible at this scale).
View 4 Replies
View Related
May 4, 2007
how to figure out how much power one would need?
My potential colo provider is saying that a 5A circuit comes standard with a 1/4 cabinet and that they charge $20 per amp over that. I will have (6) Dell 1650's with dual 650W PSU's. Any idea how to calculate how much actual power I will need for this configuration?
View 14 Replies
View Related
