I gang

optimize mysql on server

We are looking for person to optimize our server mysql. we have 64gb memory installed but still the site is loading very slow due to mysql.

You will connect through teamviewer and do necessary adjustments so mysql works faster.

Here is our output for mysql tuner.

>> MySQLTuner 1.3.0 - Major Hayden <>

[OK] Currently running supported MySQL version 5.5.36-cll

[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM

[--] Data in MyISAM tables: 498M (Tables: 4003)

[--] Data in InnoDB tables: 56M (Tables: 528)

[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)

[--] Data in MEMORY tables: 0B (Tables: 47)

[!!] Total fragmented tables: 23

-------- Security Recommendations -------------------------------------------

[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------

[--] Up for: 2d 1h 26m 10s (35M q [198.395 qps], 5M conn, TX: 21B, RX: 2B)

[--] Reads / Writes: 97% / 3%

[--] Total buffers: [url removed, login to view] global + [url removed, login to view] per thread (151 max threads)

[OK] Maximum possible memory usage: [url removed, login to view] (0% of installed RAM)

[OK] Slow queries: 0% (93/35M)

[OK] Highest usage of available connections: 29% (45/151)

[OK] Key buffer size / total MyISAM indexes: [url removed, login to view]

[OK] Key buffer hit rate: 100.0% (2B cached / 93K reads)

[!!] Query cache is disabled

[OK] Sorts requiring temporary tables: 0% (685 temp sorts / 1M sorts)

[!!] Joins performed without indexes: 46516

[!!] Temporary tables created on disk: 48% (1M on disk / 3M total)

[!!] Thread cache is disabled

[!!] Table cache hit rate: 0% (400 open / 60K opened)

[OK] Open file limit used: 2% (547/26K)

[OK] Table locks acquired immediately: 99% (10M immediate / 10M locks)

[OK] InnoDB buffer pool / data size: [url removed, login to view]

[OK] InnoDB log waits: 0

-------- Recommendations -----------------------------------------------------

General recommendations:

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 (> 400)

Færdigheder: Linux, MySQL

Se mere: teamviewer troubleshoot, statistics archive, mysql in memory engine, memory engine, 3m, q-bit, RX, optimize mysql, mysql join table, mysql table join, mysql performance_schema, architecture linux server, increase hit rate, loading cache, pool server, mysql teamviewer, linux connections, mysql output table, query performance, reduce database size, join_buffer_size, maximum possible memory usage, mysql log joins without indexes, person optimize, mysql server performance

Om arbejdsgiveren:
( 161 bedømmelser ) Ghaziabad, United States

Projekt-ID: #5991868

Tildelt til:

petrovicbobang

I have long experience in this area, because I'm maintaining and optimizing web sites (primarily through mysql optimization) with heavy traffic (more than 10k requests per second). I'm using precona toolkit on a daily Mere

$24 USD på 1 dag
(2 bedømmelser)
1.2

10 freelancere byder i gennemsnit $40 for dette job

nikosku

Hello, my name is Nikos and I'm working on the Linux server administration field for the past 5 years. Over these years I was responsible for two web hosting companies, managing at full their servers and providing cust Mere

$30 USD in 0 dage
(0 bedømmelser)
0.0
dexterash

Good day Optimizing mySQL isn't a one time/one hit job. We've done it for a lot of hosts (mainly Joomla/Wordpress that run on Apache), but it usually involves running the primer script(mysql tuner) every week for on Mere

$55 USD in 0 dage
(0 bedømmelser)
0.0
aruns2008

I have more than seven years of experience in mysql and linux. Have handled various performance issues related to mysql database. Have the necessary tools to fix this issue.

$35 USD in 2 dage
(0 bedømmelser)
0.0
odessky

Hi Your problem is here: Joins performed without indexes: 46516 I can add possible indexes to increase speed of join queries My price is $35/h SSH root access is requied

$35 USD på 1 dag
(0 bedømmelser)
0.0
vashishtabhishek

Hi, I have 10 years of experience in IT industry.I have worked with companies like Yahoo , managing big infrastructure , and Tera bytes of data. As of now working as Cloud Architect for one of the telecom giant. Mere

$35 USD på 1 dag
(0 bedømmelser)
0.0
krgourav007

Hi, I am a DBA expert and working on BIG data technologies since last 5+ years for a very big MNC ( HCL Technologies). I am bidding low as I can fix the stuff for you easily. You can be sure about the guarantee o Mere

$20 USD in 3 dage
(0 bedømmelser)
0.0
GandalfTheGrey

I am an experienced Linux administrator. I can authenticate myself so you could be sure that I will do no harm to your server / services nor abuse your data. Also, I am ready to sign NDA if needed. I can be verified Mere

$100 USD på 1 dag
(0 bedømmelser)
0.0
mtsatsenko

Highly experienced System and Database Administrator with strong Linux and UNIX skills. Able to complete this job within 2 business days.

$30 USD in 2 dage
(0 bedømmelser)
0.0
classon

I managed the [url removed, login to view] database cluster during its early growth phase. This was a mysql database cluster with 1 master and 7 replicated slaves. The web front end contained over 50 apache/php servers. I built the sche Mere

$35 USD in 2 dage
(0 bedømmelser)
0.0