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
ADVERTISEMENT
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
View Related
Jan 17, 2009
I was wondering if anyone had any recommendations on good, cheap, ASP.NET web hosting companies preferably in the 5-7$/month range. I have a tiny site, but a lot of email, so having a few gigs of storage space would be nice. Bandwidth has never been an issue in the past, but the more the merrier. Support for the newest .NET stuff would be highly desirable (.NET 3.5, preferably win2008 servers, maybe a MSSQL db?)
View 10 Replies
View Related
Apr 3, 2008
I am referring a friend to JaguarPC but he wants more options so he wants me to recommend 3 different shared webhosts to him. What are two other great shared hosting providers that have as good support as JaguarPC?
View 7 Replies
View Related
May 11, 2009
I came to this site few days back only and was going through various discussions. After being on this website since last 1 week I am really impressed that members are really helpful to other members with their fair and valuable suggestions.
I do have a quick question for you and need your suggestions:
Q: Which web host I should go with where I will get around 20GB of space with PHP, MySQL, FFMPEG support.
Please recommend me a host with high uptime, good http response time, and reliable to host considering a long term relationship.
View 6 Replies
View Related
Jul 5, 2008
Can anyone please suggest a good linux based shared hosting with ionCubeLoader suppot.
Technology required are:
PHP
MySQL
PhpMyadmin
Budget: $10 to $15 / month
View 11 Replies
View Related
May 29, 2007
Does anyone know of any shared hosting plans that don't have any MySQL limitations? Aplus.net and Powweb are trying to shut down my accounts because of this problem, and I can't afford dedicated hosting quite yet.
View 12 Replies
View Related
Mar 27, 2008
Does anyone have an opinion on the performance of XO's shared web hosting solution when you're using their built-in MySQL capability with PHP coding?
View 0 Replies
View Related
Sep 10, 2007
MySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that:
a) one customer could write a procedure which accessed another customer's data?
b) any customer could call a procedure created by a different customer?
c) any customer could override an existing mysql function in a way that would affect other customers?
d) any customer could write a function that bound to a system library and crash the entire server instance?
View 8 Replies
View Related
Jan 14, 2009
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
View 12 Replies
View Related
Mar 18, 2009
One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier.
I noticed the following warning in the host's control panel:
"[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances."
Is this common at other shared hosts?
View 14 Replies
View Related
Mar 17, 2008
Is 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?
View 14 Replies
View Related
Mar 12, 2008
I need to get a couple of dedicated windows servers and am trying to decide between SoftLayer and a couple other providers.
So, how is SoftLayer for customer support, network performance/uptime, pricing, and just overall?
Any recommendations?
View 7 Replies
View Related
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
Jan 7, 2007
I am considering to upgrade to MySQL 5.0. I am using 4.1 at present. Now I wonder if it will really improve performance... I really have some busy databases... Also wonder if 5.0 is fully downwards compatible to 4.1
View 2 Replies
View Related
May 24, 2007
I have a site that runs from a MySQL database. The database isn't big, it has only 16.1 MB on 17 tables with 103,978 records, and all are properly indexed.
My problem is that my MySQL has a particular problem with this database because I'll have to wait around 5-10 minutes to receive the query results.
I've tuned MySQL, I've tuned Apache and in the daily usage i have usually low Load Averages of 0.19 0.22 0.40. My server specs are Intel P4 at 3GHz with HT, 2Gb of RAM (in dual Chanel), 2 Hdd of 250Gb (backup) and 300Gb (main hdd), both with 16 mb cache. I'm running Debian 3.1 with 2.6 kernel and there is no swapping to disk as i had previous on the 2.4 kernel.
I will post my.conf below and maybe you'll give me a suggestion.
Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# [url]
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port= 3306
socket= /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket= /var/run/mysqld/mysqld.sock
nice= 0
[mysqld]
#
# * Basic Settings
#
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
language= /usr/share/mysql/english
skip-external-locking
#
# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords= 1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address= 127.0.0.1
#
# * Fine Tuning
#
key_buffer= 32M
key_buffer_size= 32M
max_allowed_packet= 16M
myisam_sort_buffer_size = 32M
table_cache= 3072
sort_buffer_size= 4M
read_buffer_size= 4M
read_rnd_buffer_size= 4M
join_buffer_size= 2M
thread_stack= 512K
wait_timeout= 300
max_connection = 60
max_connect_errors= 10
thread_cache_size= 100
long_query_time= 2
max_user_connections= 50
interactive_timeout= 100
connect_timeout= 15
tmp_table_size= 64M
open_files_limit= 3072
max_heap_table_size = 64M
#
# * Query Cache Configuration
#
query_cache_limit= 2M
query_cache_size = 64M
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql.log
#log= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
log-slow-queries= /var/log/mysql/mysql-slow.log
log-queries-not-using-indexes = /var/log/mysql/mysql-index.log
# The following can be used as easy to replay backup logs or for replication.
#server-id= 1
log-bin= /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 104857600
#binlog-do-db= include_database_name
#binlog-ignore-db= include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet= 64M
[mysql]
#no-auto-rehash# faster start of mysql but no tab completition
[isamchk]
key_buffer= 32M
sort_buffer_size= 32M
read_buffer= 16M
write_buffer= 16M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
I thought that i might need to start rewriting my code in order to be able to fix things but i need at least another opinion from someone who knows more.
View 9 Replies
View Related
May 26, 2008
shared 100 Mbps is it good or bad for colo/dedicated?
View 9 Replies
View Related
Jun 15, 2009
I have published 2 articles about MySQL benchmark results. They can be viewed here:
- super-smack: [url]
- sql-bench: [url]
If you have any results to compare, please let me know, either here or via comments.
View 5 Replies
View Related
Aug 5, 2008
question regarding hard disk performance.
Right now i have a busy running forum Running on a Single Xeon 5335 with 4GB of RAM,
single 73GB SCSI 15K. And the site seems running fine most of the time except at peak.
The load sometime goes up to 8 for about 1 hour. So i am looking to upgrade my server.
The next server i am thinking about is
Single C2Q 9300, 8GB of RAM, 1x750GB SATAII as primary drive for for webserver, 1x150GB Raptor 10K to serve MYSQL only.
I wonder if the HDD performance on my current server server with future server be the same of better? Since the future server has better CPU and RAM, the only thing i worry is the HDD performance.
So in short, Single SCSI 15K V.S Combination of SATA + RAPTOR. What do you guy think?
i am using Litespeed as webserver and i also will be using litespeed on future server.
View 10 Replies
View Related
Nov 26, 2007
I was wondering if there is a significant performance gain if you use PHP 5.25 and MySQL 5x instead PHP 4.47 and MySQL 4.22?
Let's say that the scripts to be used are all compatible to the said versions.
View 3 Replies
View Related
Nov 8, 2007
I've decided to give VPS a shot. So...
I'm runnning the same query on a 1 & 1 VPS, where the MySQL server is local, and on a 1 & 1 shared server (where the MySQL server is remote).
The MySQL version on the VPS machine is 4.1, while on the shared server it's 4.0.
The exact same query takes 20x longer (!) on the VPS.
View 7 Replies
View Related
Jan 26, 2008
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it.
What are people's experience on HostGator running PHP and MySQL?
View 6 Replies
View Related
Sep 21, 2007
I'm having some performance issues on IIS with my PHP and MySQL applications. I'm also starting to see some errors.
One of my main apps is vBulletin. I've tried posting there for help, but not many people there have experience with IIS.
See this thread:
[url]
View 8 Replies
View Related
Feb 4, 2007
Which Is better and would give me better mysql Performance since mysql eats up huge amounts of CPU and RAM.
AMD 64Bit 3200 Or a Intel Core 2 Duo 1.86 GHz
I know theres many other factors involved but I need to know which processor would perform better with mysql.
View 4 Replies
View Related
Jul 19, 2007
During my poking around performance tips I found the DELAY_KEY_WRITE option (and innodb_flush_log_at_trx_commit = 0 for innodb)
which supposedly for mysql will disable the immediate disk flush for every transaction written and instead update only once every second at most?
One thing I've never had to restart on my vps is mysql, it's been great. So is this safe to turn on? Am I risking corruption? Will the performance gain be worth it with only a 16M cache?
View 4 Replies
View Related
Oct 2, 2007
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.
URL ->>
[url]
| 11351210 | gameofte_games | localhost | gameofte_onarcade | Sleep | 69 | | |
| 11351223 | gameofte_games | localhost | gameofte_onarcade | Sleep | 65 | | |
| 11351225 | gameofte_games | localhost | gameofte_onarcade | Sleep | 65 | | |
| 11351239 | gameofte_games | localhost | gameofte_onarcade | Sleep | 60 | | |
| 11351265 | gameofte_games | localhost | gameofte_onarcade | Sleep | 50 | | |
| 11351269 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 50 | | |
| 11351277 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 48 | | |
| 11351280 | gameofte_games | localhost | gameofte_onarcade | Sleep | 47 | | |
| 11351285 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 46 | | |
| 11351323 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 36 | | |
| 11351331 | gameofte_games | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351332 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351335 | gameofte_games | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351356 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 28 | | |
| 11351358 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 27 | | |
| 11351380 | gameofte_games | localhost | gameofte_onarcade | Sleep | 20 | | |
| 11351384 | gameofte_games | localhost | gameofte_onarcade | Sleep | 20 | | |
| 11351387 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 19 | | |
| 11351394 | gameofte_games | localhost | gameofte_onarcade | Sleep | 18 | | |
| 11351401 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 16 | | |
| 11351408 | gameofte_games | localhost | gameofte_onarcade | Sleep | 15 | | |
| 11351416 | gameofte_games | localhost | gameofte_onarcade | Sleep | 9 | | |
| 11351417 | gameofte_games | localhost | gameofte_onarcade | Sleep | 9 | | |
| 11351434 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 4 | | |
| 11351454 | gameofte_games | localhost | gameofte_onarcade | Sleep | 1 | | |
| 11351459 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 0 | | |
View 10 Replies
View Related
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
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
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
Apr 6, 2009
how do I stop mysql process for good?
service mysqld stop & killall mysqld don't do anything, mysqld stop and few minutes latter it restart again.
I run httpd with lxadmin.
View 3 Replies
View Related
