search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (103.7 > 60.0) in mysql: ```DELETE FROM rotation_runs WHERE season_id = %s``` #63530

Open vorpal-buildbot opened 1 month ago

vorpal-buildbot commented 1 month ago

[34] (slow_query, 103.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '246690'), ('session', '.eJx1UV1PwjAU_S99nmTfH7w5ASUgUXGYaMzSbZdS2FpoOxgh_Hc7EoYx8fGce07PvacnlG5BVJgBU6ivRA0GwkVF2RUUUNGKFx2kMueiSKlmkBV5vutGVmCGluuatu-hm6LkOS5Bq4DdJXM9-N9CWUpqWnYhv6yoRYRA0a4pObsEW65joEoRntYSBMNVq83wBoSKIu3guFYrO5UKq3byGAUTSY5WHi_e8qYJ9p97MXoXAUzd-cy76RXf6MD-CeE8BymvGJGBiheTZxGHmW9_BA8JneBkR_bDl-kYv2o_NFsqQKZYV2gFtuXp03yn5zihZ3vObd626ptuaJoGErDU1KoL2a1neXYYxU4yzA_JIBhbDRzuyZOjVJZxHaJb3eprvnSP-q_o8qi5S2uyt-aUdQh9G-jyaKqOrQHFgAUIdDbQ3woVFgT0zqwuy_MPa9un-w.Zq15xw.sogDpSsWZou2UQPmjcaHNBNUC3g'), ('views', '10723')]) Endpoint: rotation_clear_cache View Args: {} Person: 195644917081440265 Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 136.25.106.188 Cf-Ray: 8ad231058ef49642-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Not)A;Brand";v="99", "Google Chrome";v="127", "Chromium";v="127" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "macOS" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: none Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Accept-Language: en-US,en;q=0.9,es;q=0.8 Priority: u=0, i Cookie: hide_intro=True; page_size=20; deck_id=246690; session=.eJx1UV1PwjAU_S99nmTfH7w5ASUgUXGYaMzSbZdS2FpoOxgh_Hc7EoYx8fGce07PvacnlG5BVJgBU6ivRA0GwkVF2RUUUNGKFx2kMueiSKlmkBV5vutGVmCGluuatu-hm6LkOS5Bq4DdJXM9-N9CWUpqWnYhv6yoRYRA0a4pObsEW65joEoRntYSBMNVq83wBoSKIu3guFYrO5UKq3byGAUTSY5WHi_e8qYJ9p97MXoXAUzd-cy76RXf6MD-CeE8BymvGJGBiheTZxGHmW9_BA8JneBkR_bDl-kYv2o_NFsqQKZYV2gFtuXp03yn5zihZ3vObd626ptuaJoGErDU1KoL2a1neXYYxU4yzA_JIBhbDRzuyZOjVJZxHaJb3eprvnSP-q_o8qi5S2uyt-aUdQh9G-jyaKqOrQHFgAUIdDbQ3woVFgT0zqwuy_MPa9un-w.Zq15xw.sogDpSsWZou2UQPmjcaHNBNUC3g; views=10723 Cf-Connecting-Ip: 136.25.106.188 Cdn-Loop: cloudflare Cf-Ipcountry: US ```
vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (114.0 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 114.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8ada9be4cc21112e-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (99.8 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 99.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8adb4bb069a610e5-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (80.1 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 80.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8adba3908fe21129-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (88.3 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 88.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8adbfb7ae9a7115b-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (168.4 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 168.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8adc535e2afd4df4-MCI X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (282.9 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 282.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8adcab3b5aaa4e08-MCI X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (159.8 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 159.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8add03207da16a1d-MCI X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (70.6 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 70.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8addb2f388ce4de6-MCI X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (113.3 > 60.0) in mysql: DELETE FROM rotation_runs WHERE season_id = %s

[34] (slow_query, 113.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 35736c3fe33478c0983d3c3199ded30248e6958c

Request Data ``` Request Method: GET Path: /api/rotation/clear_cache? Cookies: ImmutableMultiDict([]) Endpoint: rotation_clear_cache View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 50.21.182.26 Cf-Ray: 8ae1d1a6b9326207-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: python-requests/2.32.3 Accept: */* Cf-Connecting-Ip: 50.21.182.26 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite