Closed

MySQL optimization

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)

Skills: MySQL

See more: join_buffer_size, starting as a freelancer, freelancer vps, vps optimization, Query optimization, optimize mysql, mysql freelancer, table optimization, mysql performance optimization, mysql join table, mysql table join, query performance, mysql log joins without indexes, slow queries, optimize vps limit, mysql query slow, mysql slow queries, security descriptor, mysql slow, query optimize, mysql join, optimizations, mysql query optimization, query optimize mysql, join_buffer_size always use indexes joins

About the Employer:
( 12 reviews ) Osaka, Japan

Project ID: #5032736

7 freelancers are bidding on average $130 for this job

datadiggers

Hello, I'm Matt and I'm MySQL database administrator specializing in performance optimization of MySQL servers and PHP applications. I can easily adjust configuration of Your server per Your guidelines and also revi More

$124 USD in 2 days
(10 Reviews)
5.4
Magjoom

I will do the required optimization; please let me know if you want me to start.. I will look forward to hear from you Magjoom

$188 USD in 2 days
(10 Reviews)
5.4
danale72

Hello You defined quite detailed description of what need to be done. Apart from that I will scan database for types and indexes to improve performance. All the best Alexei

$155 USD in 2 days
(37 Reviews)
4.9
tlchung

skilled server admin here, over 10+ year server admin experience, i can do the mysql optimization for you, let start now.

$54 USD in 2 days
(25 Reviews)
4.3
ppcminds

Hello , I understand your requirement , i can work on it . Please add us in s kype . We can dicuss in detail Please feel free to contact us, My S kype : [url removed, login to view] - Thanks, Ravi.

$166 USD in 5 days
(1 Review)
4.0
atharvsoftwares

Our Skills:- - Strong Skills in Cake PHP/ Joomla / Codeignitor/ YII / MVC - As well as in PHP framework - Good in MySql and DB management also - CMS of Wordpress, Magento, Drupal development with plugins and extens More

$126 USD in 3 days
(0 Reviews)
0.0
minuthomas

Hi, I am a 5+ years experienced linux server administrator. I can resolve the issue that you are facing with MySQL server. I shall optimize MySQL server for its maximum performance. Regards, Minu [url removed, login to view] More

$100 USD in 1 day
(0 Reviews)
0.0