dwax
asked on
How can we determine which provider is suitable for our huge MYSQL database?
For our online service we need lots of database space. Currently we have about 900MB
of used space. Our current premium (fast!) host only supports up to 1GB. After that it's dedicated; which
will cost about € 400 each month. As this is donationware, we can't afford this. We can afford
about $1200 each year for hosting. Not much more.
So we are looking for a new host. With a few GB of MYSQL space. We don't need huge normal
file storage.
We've found hostgator.com, they say their MYSQL has no limit. Which would be ideal.
But we are afraid that their MYSQL and connections (?) aren't fast enough.
About speed. We can have up to a thousand users working simultaniously on our db. This db
has about 10.000.000 records. We want to be ready for the future: the number of users grows
every day.
So my questions are:
- are our assumptions regarding speed and number of connections right?
- what would you recommend we should do?
- what would be possible bottlenecks for a new provider?
- are there ways to check mysql speed and number of connections up front?
- how can we determine which provider is suitable for our needs?
- would a cheap host be a bad mistake?
of used space. Our current premium (fast!) host only supports up to 1GB. After that it's dedicated; which
will cost about € 400 each month. As this is donationware, we can't afford this. We can afford
about $1200 each year for hosting. Not much more.
So we are looking for a new host. With a few GB of MYSQL space. We don't need huge normal
file storage.
We've found hostgator.com, they say their MYSQL has no limit. Which would be ideal.
But we are afraid that their MYSQL and connections (?) aren't fast enough.
About speed. We can have up to a thousand users working simultaniously on our db. This db
has about 10.000.000 records. We want to be ready for the future: the number of users grows
every day.
So my questions are:
- are our assumptions regarding speed and number of connections right?
- what would you recommend we should do?
- what would be possible bottlenecks for a new provider?
- are there ways to check mysql speed and number of connections up front?
- how can we determine which provider is suitable for our needs?
- would a cheap host be a bad mistake?
all depends on DB load, 1G is small by my level
what you need to know is things like, how many concurrent connections, queries per second average and max, total index space, are all queries optimised to use indexes or else you will be doing full table scans which are slow, few graphs of db/cpu/disk/mem usage currently would be usefull
without all the above its hard to know the type of db load you have, could quite easly support all of that on a reasonable vps, you say 1000 users at the same time but are they all issuing 1000 queries every second or is is say 100 per second etc, so many vairables
what you need to know is things like, how many concurrent connections, queries per second average and max, total index space, are all queries optimised to use indexes or else you will be doing full table scans which are slow, few graphs of db/cpu/disk/mem usage currently would be usefull
without all the above its hard to know the type of db load you have, could quite easly support all of that on a reasonable vps, you say 1000 users at the same time but are they all issuing 1000 queries every second or is is say 100 per second etc, so many vairables
ASKER
@tsmgeek
Thanks for your reply.
I've done a bit of research and here are some figures.
server settings:
MySQL version MySQL 5.1/64bit
Max. concurrent connections 102
mysql data for our site:
no of queries per second
update-insert between 20 and 120 (peaks)
select around 10-30
no of rows per second
fetched rows 200- with peaks to 3500
updated rows around 100
date send recieved from mysql in kb's
recieved 2-7 kb with peaks to 15kb
send 5-10 with peaks to 35 kb
Thanks for your reply.
I've done a bit of research and here are some figures.
server settings:
MySQL version MySQL 5.1/64bit
Max. concurrent connections 102
mysql data for our site:
no of queries per second
update-insert between 20 and 120 (peaks)
select around 10-30
no of rows per second
fetched rows 200- with peaks to 3500
updated rows around 100
date send recieved from mysql in kb's
recieved 2-7 kb with peaks to 15kb
send 5-10 with peaks to 35 kb
ASKER
One more question:
Does the type of hardware also matter in MYSQL speed? Or is this negligible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks tsmgeek for taking your time to respond.
I've been in contact with servint, googled a bit on experiences, and it seems very promising!
I've been in contact with servint, googled a bit on experiences, and it seems very promising!
http://www.top10hostinglist.com/?gclid=CN-04o_h-6cCFcfsKgodN3rcqw