Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Performance Tuning Interview Questions > MYSQL on a high traffic site

:: Categories ::

Interview Question in SQL Server Performance Tuning


 

Interview Question :: MYSQL on a high traffic site


I currently work for an online company backed by a mysql database. Our websites performance is slowing down due to the heavy traffic. Here's my question

I know MS SQL and Oracle our great databases for heavy traffic. Is there any MYSQL databases that will work for heavy traffic sites?

I have a lot of php code that I would have to switch over to sql syntax if I change the database structure
Answers to "MYSQL on a high traffic site"
RE: MYSQL on a high traffic site?

You might be better off doing some simple db tuning and upgrading hardware if needed...Throw some indexes in there, make sure your queries are pulling only data you need, etc. MySQL is a pretty good server...I doubt that you have taxed it to the point it's slow.
 
Vote for this answer ::  
RE: MYSQL on a high traffic site?

MySQL has traditionally had a reputation of being very fast. You might have to look into using more servers.



Also, are you sure its the database performance that's the bottleneck? It could be the PHP processing or some other piece.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License