optimizing mysql

IN PROGRESS
Bids
10
Avg Bid (USD)
$310
Project Budget (USD)
$30 - $250

Project Description:
We have two tables in mysql database(v5.6.10). One table has 300 records another table (myisam) has 50 millions records. We will provide you three queries with seven filter condition and 5 order by. We like to optimize those three queries, so that when we add different combination of filter conditions or all filter conditions and different order by, we need to expect the result by 250 msec. Our server has 4 cpu and 4 GB RAM. We also provide you the conf file. When we provide the data, we will provide for 8millions records and you need to make it into 50 millions records.

Deliveries: 50 million records table, different combination of three queries, filters and order by with performance timing. We will also test that and ensure we meet the performance.

Skills required:
MySQL
Additional Files: Requirements.txt
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 267
in 5 days
$ 100
in 0 days
$ 350
in 3 days
$ 1050
in 3 days
Hire Ivan83
$ 165
in 3 days
$ 275
in 3 days
Hire datonil
$ 220
in 3 days
Hire santap2013
$ 250
in 15 days
$ 220
in 3 days
$ 200
in 3 days