• Hello, recently we started to have a problem with variable products and MariaDB (our server uses MariaDB)

    When I open variable product with lots of dropdown all dropdowns just freeze. Here is log from our service provider, it has something to do with length of request to the database. Does anyone has the same issue?

    Here are some logs:

    # time mysql tobk_artpr1nt < query-lock.sql
    ID
    1973

    real 3m22.184s
    user 0m0.002s
    sys 0m0.002s

    # time mysql tobk_artpr1nt < query-lock.sql
    ID
    1973

    real 6m59.299s
    user 0m0.001s
    sys 0m0.005s

    | 2711003 | tobk_artpr1nt | localhost | tobk_artpr1nt | Query | 465 | Copying to tmp table | SELECT ge_posts.ID FROM ge_posts LEFT JOIN ge_postmeta ON ( ge_posts.ID = ge_postmeta.post_id ) | 0.000 |

    Here is link to page in question – https://www.artprint.lv/shop/canvas/your-photo/demo-product/ as you can see variable panel is just frozen

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Problem with variable products and MariaDB’ is closed to new replies.