mysql database table and query optimization

note you will be working on an adult website. You need to be a php/mysql developer to help on this project as the server side mysql optimization has been done, requires tables and re-designing of query Issue: - We have a client with large video sharing website running AVS script. Average users online 500. - We notice there was lag in website speed when there in 2000 users online at peak time (11AM-2PM EST) - The issue appears not with web servers or loadbalancer however mysql server shows sign of high cpu usage when this happens. - During peak time 4-6CPU cores being used by mysql and load goes up to 200. We have recently upgraded the mysql server to 2 X Intel(R) Xeon(R) CPU E5-2620, 16GB ram, SSD drive and the issue still there. The issue appears not I/O wait or memory usage. Highest mysql connection peak at 900 at a given time. Project Goal: The website navigation speed shouldn't lag and should have same speed when the online user is 1000 or 2000. The hardware is not an issue here or the web server. Website growing daily and should be able to handle the growth without a beat. Project Requirement: - Login to mysql server during peak time (11AM-2PM EST) few days to observe the load spike and compare the navigation speed - Mysql server does not have any control panel, you should be able to work through command only via ssh - You must be well versed in linux,mysql, php as you may have to re-write the mysql query that script uses to reduce load or table locks - Downtime is not acceptable, if you want to make changes to sql server can only be done during off peak hours (6PM - 9PM EST) and must be communicated in advance of how long you need - All changes must be documented and presented to us once completed, we will need this when we move to another sql server. - If you have any questions about the infrastructure design, ask before bidding - Project goal should be met (min 90%) Project Budget: $100 Please bid only if you can meet the project requirements!!!