Closed

MySQL optimization

This project received 7 bids from talented freelancers with an average bid price of $130 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
7
Project Description

I would like a trustworthy freelancer to perform the following optimizations on my VPS.

If I like your work, there are some other things I would like done on the security side.

Run OPTIMIZE TABLE to defragment tables for better performance

Enable the slow query log to troubleshoot bad queries

Adjust your join queries to always utilize indexes

When making adjustments, make tmp_table_size/max_heap_table_size equal

Reduce your SELECT DISTINCT queries without LIMIT clauses

Set thread_cache_size to 4 as a starting value

Increase table_cache gradually to avoid file descriptor limits

Variables to adjust:

query_cache_size (>= 8M)

join_buffer_size (> [url removed, login to view], or always use indexes with joins)

tmp_table_size (> 16M)

max_heap_table_size (> 16M)

thread_cache_size (start at 4)

table_cache (> 64)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online