Faster than MySQL?

Hello,

I own a couple of heavy traffic sites that work with huge databases.

One of them pulls info from a databse that is 1.9GB
There are 7 tables, with:

Rows | Size
320,220 | 1.6 GB
660,570 | 22.5 MB
518,000 | 21.5 MB
71,000 | 3.5 MB
510,000 | 21 MB
1,130,000 | 140 MB
90,000 | 11  MB

Actually database server is MySQL running on CentOS 5 with CPanel, and load gets very high with some queries, and I'm wondering if there is a faster/better database server than MySQL.

Thank you very much,

Chorch
LVL 6
ChorchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ralmadaCommented:
>>Actually database server is MySQL running on CentOS 5 with CPanel, and load gets very high with some queries, and I'm wondering if there is a faster/better database server than MySQL.<<

I think you're asking the wrong question. There are a lots of things that will make your database slow.

First of all I would suggest you check you have the right indexes and review your queries to see if they can be improved, also check your query_cache_size. The below links will help you with this:

http://forge.mysql.com/wiki/Top10SQLPerformanceTips
http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html

Then you will have to look at the hardware supporting the server. How many CPUs, how much memory, etc.

I don't think one database server is faster/better than the other. You just need to implement it properly.

If you still decide to change it, you will have to consider implementation costs...

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ralmadaCommented:
sorry in my last paragraph I meant to say migration cost, if you decide to use another database server
0
ralmadaCommented:
Also I forgot to mention check what engine (MyISAM or Innodb) you are currently use and see if it's the right for your needs.

http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines
0
DerokorianCommented:
Also MySQL has an enterprise version (if that's not what your on) which has much better support and configuration options for HIGH volume database interaction. But the biggest thing that slows down databases is I/O limitations of the hardware. If you have 24 cores and 100GB of ram but you are running an 5400RPM IDE hard drive... well you're limited to the speed of the harddrive.
0
Kent OlsenData Warehouse Architect / DBACommented:
Hi Chorch,

Define "heavy traffic sites".  :)  

2GB isn't a particularly large database.  If you've got a 4GB database server the entire database can be cached in memory, and if you've got a multi-use server, a little tuning can still keep the database cached in memory.  

Internally, MySQL uses a fairly aggressive memory locking technique that results in MySQL maxing out at several thousand transactions/second.  MySQL can be built from source with options that get it to about 10,000 transactions/second.  Either way, that's a LOT of database work.  Do your needs run into the thousands/second range?

If so, you may need to rethink your solution.  MySQL and PostGres are fine for the vast majority of web sites, but if your data needs are that great, you may need to investigate commercial database engines such as DB2 or Oracle.  


Good Luck,
Kent
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.