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)
7 freelancers are bidding on average $130 for this job
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
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.