In Progress

266598 MySQL Database Optimization

I have a MySQL database that performs very slow. I would like to have this database optimized or issues resolved to significantly increase its performance. This is a very large database and contains around 175 million records. The search querys work and produce valid results but take far to long. I need it to return results in a few seconds and wish to be able to search by all fields in the database. At one time it worked well but then when some records were removed that were older records it slowed a great deal. I have attached a document that shows one such search I just ran. The attached also provides a view of the admin area where prices and number of searches are set.

This project is not for you to design a site but I would like the search fields to be able to be accessed from the domain and not just the test area where they currently reside.

We have a database of similar size on the server and managed to get good performance but ended up using PostgresSQL to do it. If you wish to change this to PostgreSQL please indicate this when biddding. I don't know which is better other than do know the PostgresSQL worked better for our other database of similar size.

Thank you for your consideration.

Skills: Anything Goes, MySQL, PHP, SQL

See more: mysql search performance, mysql search optimization, mysql database server, database design prices, mysql postgresql, good database design, sql mysql, mysql test, mysql database , mysql database design, document database, design optimization, database performance , database optimization, mysql performance optimization, postgressql, mysql number sql, mysql area, records domain, optimization database, mysql server performance, mysql performance test, sql database size, sql test number, php server optimization

About the Employer:
( 29 reviews ) Salem, United States

Project ID: #2012876

Awarded to:


Please see the PMB.

$250 USD in 4 days
(8 Reviews)