18609 MySQL Optimistations needed
N/A
Julkaistu lähes 18 vuotta sitten
N/A
Maksettu toimituksen yhteydessä
Hi
I need further optimisations on our database for our website. [login to view URL] (database is disabled).
Background: There are too many connections from our site to the shared server, we need to reduce it further.
You would also need to liase with our host company PIPEX to resolve the problems.
Here is a snapshot of the process list which caused problems for the server:
+-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 33700 | mobile | localhost | mobiledb | Query | 0 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 33907 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 33956 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34214 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34281 | mobile | localhost | mobiledb | Query | 0 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34338 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34382 | mobile | localhost | mobiledb | Query | 1 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34392 | mobile | localhost | mobiledb | Query | 1 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34415 | mobile | localhost | mobiledb | Sleep | 0 | | |
| 34431 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34454 | mobile | localhost | mobiledb | Query | 0 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34459 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34478 | mobile | localhost | mobiledb | Query | 3 | Writing to net |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34495 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34532 | mobile | localhost | mobiledb | Query | 3 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34554 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34589 | mobile | localhost | mobiledb | Query | 0 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34603 | mobile | localhost | mobiledb | Query | 2 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34646 | mobile | localhost | mobiledb | Query | 0 | Sending data |
| select product_review.heading_id ,product_review.review_heading_value
from product_review |
| 34660 | webdate | localhost | webdatedb | Query | 0 | Copying to tmp
| table | SELECT DISTINCT [login to view URL], [login to view URL], [login to view URL], [login to view URL],
| p.marital_status, [login to view URL], [login to view URL], [login to view URL] F |
| 34662 | a4hlive | [login to view URL] | a4hlivedb | Sleep | 0 | | |
| 34663 | root | localhost | | Query | 0 | | show processlist |
+-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
Projektin tunnus (ID): 1769445
Tietoa projektista
1 ehdotus
Etäprojekti
Aktiivinen 12 vuotta sitten
Haluatko ansaita rahaa?
Freelancerin tarjouskilpailun edut
Aseta budjettisi ja aikataulu
Rekisteröinti ja töihin tarjoaminen on ilmaista