nobelkitap
OpenCart-TR
- Katılım
- 3 Şub 2015
- Mesajlar
- 16
- Tepkime puanı
- 0
- Puanları
- 0
Merhaba, web sitemiz olan; hatibogluyayinevi.com da bir sorun var ve bu sorun Sunucuda loadların yükselmesine sebep oluyor. Böylece suspend yiyoruz. Siteye çok giren yok. Maksimum 30 40 kişidir. Sizce bu sorun neden olabilir.
Sunucuda uzun süren mysql komutu:
2015-02-15 3:13:59 - PHP Notice: Error: Query execution was interrupted<br />Error No: 1317<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '70' in /home/hatibogl/public_html/system/database/mysql.php on line 50
Sunucuda uzun süren mysql komutu:
2015-02-15 3:13:59 - PHP Notice: Error: Query execution was interrupted<br />Error No: 1317<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '70' in /home/hatibogl/public_html/system/database/mysql.php on line 50