Jump to content

Possible bug: Prestasho with many (20.000) products kills database


peterlyberth
 Share

Recommended Posts

Hi there.

Our host contacted about a problem with our store killing the database.

 

13459146 | billigih | pro18.meebox.net:47087 | billigih_newdb | Query | 1543 | Locked | SELECT COUNT(*) AS `count` FROM `billigih_newdb`.`ps_stock_available` WHERE (CONVERT(`id_stock_avail |
| 13459306 | billigih_billig | pro18.meebox.net:47299 | billigih_newdb | Query | 1544 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459458 | billigih_billig | pro18.meebox.net:47487 | billigih_newdb | Query | 1504 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459524 | billigih_billig | pro18.meebox.net:47576 | billigih_newdb | Query | 1481 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459526 | billigih_billig | pro18.meebox.net:47578 | billigih_newdb | Query | 1481 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459543 | billigih_billig | pro18.meebox.net:47610 | billigih_newdb | Query | 1478 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459565 | billigih_billig | pro18.meebox.net:47644 | billigih_newdb | Query | 1471 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459606 | billigih_billig | pro18.meebox.net:47706 | billigih_newdb | Query | 1457 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459639 | billigih_billig | pro18.meebox.net:47750 | billigih_newdb | Query | 1450 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459681 | billigih_billig | pro18.meebox.net:47797 | billigih_newdb | Query | 1440 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459684 | billigih_billig | pro18.meebox.net:47800 | billigih_newdb | Query | 1439 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459692 | billigih_billig | pro18.meebox.net:47811 | billigih_newdb | Query | 1436 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459707 | billigih_billig | pro18.meebox.net:47828 | billigih_newdb | Query | 1431 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459710 | billigih_billig | pro18.meebox.net:47833 | billigih_newdb | Query | 1430 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459738 | billigih_billig | pro18.meebox.net:47883 | billigih_newdb | Query | 1422 | Locked | SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48254) AND (id_product_attribute |
| 13459759 | billigih_billig | pro18.meebox.net:47918 | billigih_newdb | Query | 1416 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459784 | billigih_billig | pro18.meebox.net:47954 | billigih_newdb | Query | 1410 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459832 | billigih_billig | pro18.meebox.net:48016 | billigih_newdb | Query | 1396 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459853 | billigih_billig | pro18.meebox.net:48041 | billigih_newdb | Query | 1390 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459862 | billigih_billig | pro18.meebox.net:48053 | billigih_newdb | Query | 1389 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459897 | billigih_billig | pro18.meebox.net:48100 | billigih_newdb | Query | 1382 | Locked | SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48254) AND (id_product_attribute |
| 13460002 | billigih_billig | pro18.meebox.net:48243 | billigih_newdb | Query | 1356 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13461628 | billigih_billig | pro18.meebox.net:50540 | billigih_newdb | Query | 1039 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13461922 | billigih_billig | pro18.meebox.net:51020 | billigih_newdb | Query | 983 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13462629 | billigih_billig | pro18.meebox.net:51960 | billigih_newdb | Query | 824 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |

 

 

The sql statements are used in category.php, and as far as I can see, it has to make those queries to show the products.

 

Is this a bottleneck in the host or in prestashop itself?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More