Chorch
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry in my last paragraph I meant to say migration cost, if you decide to use another database server
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
http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.