search

PennyDreadfulMTG / perf-reports

2 stars 7 forks source link

Exceeded slow_query limit (63.6 > 60.0) in mysql: ```UPDATE person SET locale = %s WHERE id = %s``` #63035

Open vorpal-buildbot opened 3 weeks ago

vorpal-buildbot commented 3 weeks ago

['es-419', 9413] (slow_query, 63.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2c1c7616c4db45ec3ffdfeea3b3792596a7191cb

Request Data ``` Request Method: GET Path: /api/status? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UU1vwjAM_S8-M9SW0g9uKzAhBpM2YENMUxW1bsmaNlmSaiDEf5_LNDhNudjPz8_2ywlShbpmDTYWRla32AOW17yBUcGEoSzHmtcyv-XcZFLnKScIPH84GDjBkF7k-mEcRnBjCJkxgcRCc-e7MVX-7-FNWrZc5H87SNbavZcay2yn0K6n93ZRxF-L7XLnV8563BLjMM3jIrRruPKtrJBWPwHLMjTmL4dZuIqcUgkX6yoJX5Lv7bx2kkfxOlNuMKZ-PCiu0aSMXHBD1_eCge9F_SCOwsC7lTtfAsePHKcHGguC9tcZk9WDOR6mZRttVLGs8qf5ZKcy9rbYSPYsaQa5ouiYd7hcagj5DfqfknQ7d-gTeHGEjx5cRFN77BogQaZRw5lgpkukFZtWiPMPjGCOYQ.ZiRbDQ.AiHL-wzYBBfRTnF6DLBbjKtu8AQ'), ('views', '29')]) Endpoint: person_status View Args: {} Person: 245330656568147978 Referrer: https://pennydreadfulmagic.com/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 186.28.11.6 Cf-Ray: 877930fe9bdb0349-MIA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Not A(Brand";v="99", "Opera GX";v="107", "Chromium";v="121" Accept: */* X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 OPR/107.0.0.0 Sec-Ch-Ua-Platform: "Windows" Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/ Accept-Language: es-ES,es;q=0.9 Cookie: hide_intro=True; session=.eJx1UU1vwjAM_S8-M9SW0g9uKzAhBpM2YENMUxW1bsmaNlmSaiDEf5_LNDhNudjPz8_2ywlShbpmDTYWRla32AOW17yBUcGEoSzHmtcyv-XcZFLnKScIPH84GDjBkF7k-mEcRnBjCJkxgcRCc-e7MVX-7-FNWrZc5H87SNbavZcay2yn0K6n93ZRxF-L7XLnV8563BLjMM3jIrRruPKtrJBWPwHLMjTmL4dZuIqcUgkX6yoJX5Lv7bx2kkfxOlNuMKZ-PCiu0aSMXHBD1_eCge9F_SCOwsC7lTtfAsePHKcHGguC9tcZk9WDOR6mZRttVLGs8qf5ZKcy9rbYSPYsaQa5ouiYd7hcagj5DfqfknQ7d-gTeHGEjx5cRFN77BogQaZRw5lgpkukFZtWiPMPjGCOYQ.ZiRbDQ.AiHL-wzYBBfRTnF6DLBbjKtu8AQ; views=29 Priority: u=1, i Cf-Connecting-Ip: 186.28.11.6 Cdn-Loop: cloudflare Cf-Ipcountry: CO ```