We are looking for a MySQL expert able to analyze our DB structure and queries to suggest changes that increase overall performance of an ad network.
There are tables with millions of records and get hundreds of queries per second.
We will provide the freelancer with the DB structure and queries done. He/she will need to run tests on his/her own server including stress tests to suggest changes that increases performance to its limits.
This is an hourly project as table's structure and queries will be provided over time (not all at once).