Wordpress Sql Queries Performance On A Shared Hosting Account

Jan 10, 2009

im running a few blogs on a shared hosting account (steadfast) and i noticed the 18 sql queries being generated by a fresh install of wordpress 2.7 are taking 0.246 seconds to execute.
<!-- 18 queries. 0.246 seconds. -->

considering this is a shared hosting server with over 800+ more domains on it, is the performance better or worse when compared to other shared hosting providers ?
archim3des

View 14 Replies


ADVERTISEMENT

How Many Wordpress Blogs Can Be Hosted On A Shared Hosting Account

Apr 26, 2009

How many wordpress blogs can be hosted on a Hostgator Business Shared hosting or MediaTemple Grid-Service hosting account?

Also which one of the two is better hosting?

View 14 Replies View Related

Shared Hosting With Good Mysql Performance

Jun 7, 2008

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.

View 14 Replies View Related

Optimizing These Particular MySQL Slow Queries In WordPress

Jun 14, 2008

What I did here was create /var/log/mysqld.slow.log for queries that are taking one second or longer. After around 36 hours, here is what I came up with. Since the file size of /var/log/mysqld.slow.log was 219KB, posting it in its entirety it not practical. Therefore, I used a program, the perl script known as mysql_slow_log_parser found on www.retards.org, to parse the mysqld.slow.log to make it easier to interpret and read. The result was that the original filesize of 219KB was converted to the smaller size of 14KB....

View 7 Replies View Related

WordPress MU Godaddy Shared Hosting Wildcard Subdomains

Jan 5, 2009

I have a site hosted at Godaddy.

My hosting account is shared delux.

I have recently added multi blogger Wordpress MU.

A single main blog is working fine but all other blogs are showing errors.

I have installed for subdomains.

View 1 Replies View Related

How Many Visitors On Shared Hosting Account

Aug 27, 2009

how many visitors bear a shared hosting account, Because if visitor grow it goes down..

View 20 Replies View Related

Moving From A Shared Hosting Account To A VPS.

Jun 5, 2007

I currently use a HostGator shared plan which caps off database connections at 25. HG support said my only choice is to move to a dedicated server which means my monthly hosting cost jumps from $14.95 to $174.00! Something I'm not too excited about paying.

Can anyone offer any suggestions on Virtual Private Servers running *nix? Would a VPS be a good alternative to an expensive HG dedicated server or do you recommend I just suck it up and go dedicated? I just can't believe how much they want considering I've seen some VPS for under $100. If I did go with a VPS, would there be an easy way to move all my files, databases, SSL certs, etc to the new server?

View 9 Replies View Related

The Perfect Business (shared) Hosting Account

Jul 24, 2008

I'd like your feedback on what you would consider being the perfect shared hosting account.

What features would be valuable for you, which wouldn’t?

Any features not listed?

If you had to put together the perfect feature set for a shared hosting account, how would you do it?

View 14 Replies View Related

Spry.com Shared Hosting Account DNS Not Working.

Sep 2, 2008

I am having issues with spy hosting. I signed up for a shared hosting account on Saturday the setup was fast but DNS will not resolve my domains. I get this error when doing a DNS Traversal

ns9.dnscloud.com [66.249.19.217][Broken DNS server: Reports a server failure]91ms

ns10.dnscloud.com [66.249.19.218][Broken DNS server: Reports a server failure]92ms

What is this?

I made a ticket and NO REPLY AS OF YET!

What is going on spy. Has spy gone bad i though they use to be legit?

View 13 Replies View Related

Shared Hosting Account Hacked Many Times

Apr 14, 2008

Our web site has been hacked many time over the last few months. The hacker only puts links to other site in our html code. We changed the FTP password many time but we are still finding malicious code in our main index page and other pages on the site.

We can figure how and from where they are coming in and how prevent further hacks.

View 2 Replies View Related

Recommend A CMS To Use On A Fasthosts Shared Hosting Account

Jun 3, 2008

I ideally want to use Fasthosts as the hosting provider, on a shared hosting account. Are there any CMS's that install and work well in such an environment?

I dont need a CMS with bells and whistles, just one that is template driven, and has 'friendly' URLs.

View 16 Replies View Related

DNS Hosting, Number Queries Versus Hardware Config

Jun 10, 2008

For those who run their own DNS servers I am interested in what DNS software your running on BSD or Linux platforms and on average how many DNS queries per second it serves on what hardware specification?

View 3 Replies View Related

Shared Dedi Lines Performance At Night Times

Sep 30, 2008

My business is on the other side of the world and peak time starts at midnight in America time. I am planning to buy 100Mbps shared servers with FDCServers. I am wondering if the time of the day makes a huge difference for a shared 100Mbps line.

View 1 Replies View Related

ISCSI As Centralized Hosting - Performance

Feb 2, 2008

I´m thinking about using a centralized hosting solution, in order to achieve better redundance and performance while having more room to expand if necessary. In order to achieve this, I was thinking about implementing a storage server, and use a software to provide iSCSI target capabilities.

As storage server, I was thinking about using HP DL320s ( URL ), loaded with 12 147GB SAS HD´s 15K RPM. I will make some tests to understand the real difference between RAID5 and RAID10, concerning write speed. Also, I´m not sure if the controller provided with this server is good enough to provide a reliable operation.

For switching, I will use HP 2824 or 2848 Gigabit switch, and use port trunk in order to join both NIC controllers of the storage server.

As iSCSI target software, I still don´t know wich one to use. I think FalconStor would be a good bet, however it seems to be a bit expensive. Any good alternative?

This storage server would be used to provide storage for about 10 "regular" hosting servers, that have, at the moment, regular dual 10K SATA Drives (Raptor) in RAID1. I'm afraid the 2x Gigabit ports aren´t enough, even considering that I will not have intensive sequential reads / writes, but random acceses.

View 14 Replies View Related

Recommendations For High-performance Hosting (clustering)

Jun 14, 2008

I'd like to get your recommendations on how I should approach this problem. I posted this in another part of the forum, but I feel that this is a more appropriate place for it.

Problem:

How to handle large amounts of traffic with for a social network website? If a user uploads a photo or video, how does it become accessible on all of the server? If traffic is expected to be about 500,000 visitors a day, how many machines do you think I should use?

Possible Solution:

I've come up with the following possible infrastructure.

One load balancer. The load balancer has 3 PHP/Apache servers behind it. Behind each of the PHP/Apache servers is a (slave) MySQL server, from which data is read. Behind the slave MySQL servers, there is 1 master MySQL server, which handles all of the database writes. The master MySQL and slave MySQL servers are synced up, so data is up to date.

The actual photo and video files are not stored in the database, only the links to them is stored in the database (to keep the database small). The photo and video reside in a central location (like a SAN or NAS), which is accessible by all of the 3 PHP/Apache webservers.

Questions:

1. How many machines do you think will be able to handle photo and video uploads for 500,000 visitors a day?

2. Is having a SAN with Terabytes of RAIDED disk space an available option?

3. If a SAN or NAS is not an option, does anyone have any ideas on how to make sure all of the web servers have access to the same photos and videos? Is rsync a viable solution?

4. Which hosting provider do you think I should go with?

5. Is clustering what I need? What is clustering and how will it address my concerns?

View 1 Replies View Related

Recommendations For High Performance Hosting (clustering)

Jun 14, 2008

I'd like to get your recommendations on how I should approach this problem.

Problem:

How to handle large amounts of traffic with for a social network website? If a user uploads a photo or video, how does it become accessible on all of the server? If traffic is expected to be about 500,000 visitors a day, how many machines do you think I should use?

Possible Solution:

I've come up with the following possible infrastructure.

One load balancer. The load balancer has 3 PHP/Apache servers behind it. Behind each of the PHP/Apache servers is a (slave) MySQL server, from which data is read. Behind the slave MySQL servers, there is 1 master MySQL server, which handles all of the database writes. The master MySQL and slave MySQL servers are synced up, so data is up to date.

The actual photo and video files are not stored in the database, only the links to them is stored in the database (to keep the database small). The photo and video reside in a central location (like a SAN or NAS), which is accessible by all of the 3 PHP/Apache webservers.

Questions:

1. How many machines do you think will be able to handle photo and video uploads for 500,000 visitors a day?

2. Is having a SAN with Terabytes of RAIDED disk space an available option?

3. If a SAN or NAS is not an option, does anyone have any ideas on how to make sure all of the web servers have access to the same photos and videos? Is rsync a viable solution?

4. Which hosting provider do you think I should go with?

5. Is clustering what I need? What is clustering and how will it address my concerns?

View 11 Replies View Related

Community Website. Is It Ok With Shared Account

Apr 6, 2008

A community website with a forum(phpbb3), not more than 2000 users, less than 50 posts per day and less than 50 users online at the same time, will be ok to host under a shared account?

If the bandwith is lower than the limit, is it possible to use many resources and get susbended?

View 6 Replies View Related

Access An Account On Shared Ip Without Domain Name

Apr 9, 2008

I have an account on an older server. Its plesk.

But now that I pointed the domain I can no longer access the old server from the web.

So this is my shared ip:
66.235.201.136

Now there are about 10 domains on the IP.

what would my URL look like to access one of those accounts in plesk in the browser?

66.235.201.136/~rgratitu

I've tried the above and it doesn't work.

View 1 Replies View Related

Can You Recommend A High Performance Price JSP Hosting Provider

Aug 12, 2008

It should support jsp/jdk6.0/tomcat6.0/mysql5.0 or higher, and SSH is prefered.

Your advice will be highly appreciated.

View 0 Replies View Related

Regarding WordPress Hosting

Oct 23, 2009

I don't have Linux or whatever I just got Windows XP or Vista.

I'm not an expert at creating websites, I find it difficult. I don't want to have to install databases or msyql manually, I just don't have a clue and would rather leave it.

I just know how to use WordPress and I want a WordPress hosted site.

I would like to know if there are any sites similiar to this:
[url]

Which includes stuff like cPanel & Fantastico
[url]

Fantastico looks brilliant as I can simply install WordPress in a few clicks without having to mess with FTP and database/msqyl etc.

Does anyone know any reccomended sites that use Fantastico for Windows Vista which I can install WordPress easily?

(I don't want to use '3ix' as I have seen ALOT of negative reviews)

View 14 Replies View Related

A Wordpress/Hosting

Dec 6, 2008

I would really like to be able to edit and customize wordpress templates but apparently need a server that will support wordpress or something so I can upload and test. But currently I can not really afford any premium hosting... has anyone got any ideas if there is anything else I can do? or would anyone possibly be able to offer a small amount of space that I could use temporarily until I can afford to purchase a hosting account?

View 9 Replies View Related

Wordpress Hosting

Dec 16, 2008

Please recommend me reliable wordpress hosting with fully functionality.

Low budget,5GB webspace and 5GB bandwidth will be enough.

If it's possible reccuring billing from month to month would be best deal,because of low budget.

View 11 Replies View Related

Hosting For WordPress MU

Jun 27, 2008

Which host supports WordPress MU blogs the best? (preferably shared).

View 11 Replies View Related

Looking For ThePlanet Hosted MSSQL2005 Shared Account

Jul 11, 2008

i need mssql2005 account with 1 database only with access from my management studio express to your mssql server ip only. no webhosting needed. database size <=200 Mb. Aproximately bandwidth <=10Gb/mo.

MSSQL2005 server must be hosted on ThePlanet.

Or at least suggest me any company using ThaPlanet Hosting who selling shared mssql2005 hosting.

View 6 Replies View Related

Backup A Dedicated Server To Shared Account

May 7, 2009

I have a dedicated server with SSH ability and I need to backup some of the accounts of the server via rsync to a normal shared account where I only have ftp access..?

View 14 Replies View Related

Do Most Shared Hosts Just Suspend Your Account When You Get Traffic

Aug 23, 2008

This is my first time with shared hosting and I went with hostgator because they are well known. Well, my site is getting decent traffic but well within my disk space and data transfer allotment, and I get this email saying my site has been suspended and my site is inaccessible.

Dear customer,

Due to an excessive amount of Apache requests on our gatorXXX server we have been forced to suspend the directory /home/username/public_html/sitename at this time as all other users on the server are experiencing issues due to this :

...http requests list...

Please let us know when you're ready to investigate and address this issue so we can work with you further. Thanks.

Sincerely,
Ford Merrill
Systems Administrator Supervisor
HostGator.com LLC

Is this what most shared hosts do? Just suspend your account once your site starts getting traffic?

View 14 Replies View Related

Adding New Account To CPanel With Shared IP Address

Aug 20, 2008

whenever I open a new account in Cpanel it assigns a new IP to the new host. I want to know how I can change the cpanel settings to assigns a shared IP to the new host.

View 7 Replies View Related

Wordpress Blog Hosting

Jun 3, 2009

1. which web hosting provider is good for starting web hoster like me?

2. i need web host who support wordpress as blog software and web hosting must be fair price and my blog contain only 10mb size and bandwidth may 1gb/month intial.

2. can i use more than one blog in same domain, if ok in that each blog can have their own wordpress blog software i.e i can instal more than one wordprss software in same domain and web host?

3. if i accept free domain register from my web hoster, then if i transfer my blog after 5 months or 9 months to different web host provider can i use same domain or it is not possible?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved