Database administrator to optimise SQL and cache queries to reduce server load – Upwork

Description:
Our search result page makes many queries to DB this needs optimising
Turned on MySQL slow query and find and fix many slow queries for faster results

Required solutions:
1. Cache
2. Optimising

Some hits:
# cat /var/lib/mysql/vps31882-slow.log | grep Query_time | awk ‘{if($3>100){print $0}}’
# Query_time: 106.564153  Lock_time: 0.000630  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 121.702103  Lock_time: 0.000387  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 109.616620  Lock_time: 0.000119  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 107.553514  Lock_time: 0.000318  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 485.722132  Lock_time: 0.000045  Rows_sent: 45516  Rows_examined: 45516
# Query_time: 107.466786  Lock_time: 0.000076  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 104.710115  Lock_time: 0.000099  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 148.557370  Lock_time: 0.000149  Rows_sent: 363  Rows_examined: 66872852
# Query_time: 113.666161  Lock_time: 0.000113  Rows_sent: 238  Rows_examined: 41511109
# Query_time: 172.251112  Lock_time: 0.000107  Rows_sent: 20  Rows_examined: 66872509
# Query_time: 106.041656  Lock_time: 0.000098  Rows_sent: 20  Rows_examined: 41510891
# Query_time: 158.865332  Lock_time: 0.000094  Rows_sent: 363  Rows_examined: 66872852
# Query_time: 110.713243  Lock_time: 0.000130  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 104.943340  Lock_time: 0.000136  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 112.343043  Lock_time: 0.000101  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 106.538778  Lock_time: 0.000101  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 106.296695  Lock_time: 0.000080  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 108.757711  Lock_time: 0.000102  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 109.108166  Lock_time: 0.000077  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 102.127666  Lock_time: 0.000114  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 105.835893  Lock_time: 0.000083  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 105.505116  Lock_time: 0.000087  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 106.987221  Lock_time: 0.000083  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 115.391761  Lock_time: 0.000075  Rows_sent: 258  Rows_examined: 48351581
# Query_time: 116.369813  Lock_time: 0.000080  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 119.216394  Lock_time: 0.000099  Rows_sent: 20  Rows_examined: 48351343
# Query_time: 116.850844  Lock_time: 0.000073  Rows_sent: 258  Rows_examined: 48351581

Posted On: November 19, 2017 08:09 UTC
ID: 211751569
Category: IT & Networking > Database Administration
Skills: Database Caching, PHP, SQL
Country: United Kingdom
click to apply

Click on the link (Blue-Green color) above to apply on the relevant Online Freelance website. Disclaimer- We do not provide jobs directly, please go to the relevant freelancing website to apply and get your first Freelance Online Job.