Problem with variable products and MariaDB
-
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
1973real 3m22.184s
user 0m0.002s
sys 0m0.002s# time mysql tobk_artpr1nt < query-lock.sql
ID
1973real 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
- The topic ‘Problem with variable products and MariaDB’ is closed to new replies.