Jump to content

Back-Office trés lent

Soromap
 Share

Recommended Posts

Soromap Newbie

Soromap

Posted
Posted

Bonjour,

 

J'aurais besoin d'aide pour un souci de lenteur du chargement du Back-Office de presta 1.5.6.2 :

- Chargement des pages du BO de 10s à 20s (selon la page)

- Le front-office charge très rapidement.

- tous les modules de stats sont désactivés.

- J'ai déjà testé avec et sans le cache d'activé.

- Le site est installé sur un serveur Ubuntu avec LAMP en local (Intel Xeon E5502 1.87GHz, 2 Go RAM)

 

- J'ai aussi testé une nouvelle installation de prestashop 1.4.11.0, 1.5.4.1 et 1.6.0.6 :

Sur la version 1.4.11.0, pas de problème, back-office est rapide (moins d'une seconde) mais le thème voulu n'est pas compatible. Sur les versions 1.5.4.1 et 1.6.0.6 le back-office est aussi lent à charger.

 

------------------------------------------------------------------------------------------------------------------------------

 

Ma configuration :

 

Informations à propos de votre configuration

Informations sur votre serveur

Informations sur votre serveur: Linux #119-Ubuntu SMP Wed Feb 19 01:20:04 UTC 2014 i686

Version du logiciel serveur: Apache

Version de PHP: 5.3.2-1ubuntu4.24

Limite de mémoire: 128M

Temps d'exécution maximal (max_execution_time): 120

Informations sur la base de données

Version de MySQL: 5.1.73-0ubuntu0.10.04.1

Moteur MySQL: InnoDB

Préfixe des tables: ps_

Informations sur votre boutique

Version de PrestaShop: 1.5.6.2

URL de votre boutique: http://test.protecwood.com/

Nom du thème utilisé: deco_evo

Informations sur la configuration mail

Méthode d'envoi de mail: Vous utilisez la fonction mail() de PHP

Vos informations

Informations vous concernant: Mozilla/5.0 (Windows NT 5.1; rv:28.0) Gecko/20100101 Firefox/28.0


AdminInformation.gif Vérifier votre configuration

Paramètres requis: OK

Paramètres optionnels: OK


AdminInformation.gif Liste des fichiers modifiés
Aucun changement n'a été détecté sur vos fichiers

 

------------------------------------------------------------------------------------------------------------------------------

 

J'ai mis PS_DEBUG_PROFILING à true, voila le resultat :

 

PrestaShop™ 1.5.6.2
Temps de chargement22.597s
Questions / Renseignements / Formations : +33 (0)1.40.18.30.04 | Contact | Bug Tracker | Forum | Addons

 

Load time: 22.597s
You'd better run your shop on a toaster
  • config: 44ms
  • constructor: 0ms
  • init: 13ms
  • checkAccess: 0ms
  • setMedia: 2ms
  • postProcess: 0ms
  • initHeader: 7ms
  • initContent: 16.408s
  • initFooter: 0ms
  • display: 6.122s
Hook processing: 4ms / 0.07 Mb
  • moduleRoutes: 3ms / 0.06 Mb
  • displayAdminHomeQuickLinks: 0ms / 0 Mb
  • actionDispatcher: 0ms / 0 Mb
  • actionAdminControllerSetMedia: 0ms / 0 Mb
  • displayBackOfficeFooter: 0ms / 0 Mb
  • displayAdminHomeStatistics: 0ms / 0 Mb
  • displayAdminHomeInfos: 0ms / 0 Mb
  • displayBackOfficeHeader: 0ms / 0 Mb
  • displayBackOfficeTop: 0ms / 0 Mb
  • displayBackOfficeHome: 0ms / 0 Mb
Memory peak usage: 5.8 Mb
  • config: 2.92 Mb (2.9 Mb)
  • constructor: 0 Mb (2.9 Mb)
  • init: 1.37 Mb (4.3 Mb)
  • checkAccess: 0 Mb (4.3 Mb)
  • setMedia: 0.06 Mb (4.4 Mb)
  • postProcess: 0 Mb (4.4 Mb)
  • initHeader: 0.37 Mb (4.7 Mb)
  • initContent: 0.72 Mb (5.6 Mb)
  • initFooter: 0 Mb (5.6 Mb)
  • display: 0.13 Mb (5.8 Mb)


Total cache size (in Cache class): 0.12 Mb
DB type: DbPDO
SQL Queries: 42 queries
Time spent querying: 12ms
Included files: 69
Size of included files: 1.54 Mb
Globals (> 1 Ko only): 993 Ko
  • _LANGADM ≈ 981.2 Ko
  • _SERVER ≈ 6.5 Ko
  • _COOKIE ≈ 1.4 Ko
Stopwatch (with SQL_NO_CACHE) (total = 42)2.353 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /srv/www/test.protecwood.com/classes/Configuration.php:116
478 rows browsed0.939 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position`
in /srv/www/test.protecwood.com/classes/Hook.php:339
36 rows browsed0.939 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) ORDER BY t.`position` ASC
in /srv/www/test.protecwood.com/classes/Tab.php:246
USING FILESORT - 101 rows browsed0.492 ms SELECT SQL_NO_CACHE *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 1 LIMIT 1 ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE 1 AND o.id_shop IN (1) ORDER BY o.`date_add` DESC LIMIT 0, 10
in /srv/www/test.protecwood.com/classes/order/Order.php:882
USING FILESORT - 1 row browsed0.4 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC
in /srv/www/test.protecwood.com/classes/Dispatcher.php:426
USING FILESORT - 26 rows browsed0.337 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
in /srv/www/test.protecwood.com/classes/shop/Shop.php:622
USING FILESORT - 1 row browsed0.332 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'test.protecwood.com' OR su.domain_ssl = 'test.protecwood.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /srv/www/test.protecwood.com/classes/shop/Shop.php:320
USING FILESORT - 1 row browsed0.269 ms SELECT SQL_NO_CACHE SUM(total_paid / conversion_rate) as total_converted, left(invoice_date, 10) as invoice_date FROM ps_orders o WHERE valid = 1 AND total_paid > 0 AND invoice_date BETWEEN '2014-04-07 00:00:00' AND '2014-04-14 16:04:09' AND id_shop IN (1) GROUP BY DATE(invoice_date)
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:398
USING FILESORT - 1 row browsed0.269 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 1 AND `id_employee` = 1
in /srv/www/test.protecwood.com/classes/Tab.php:534
1 row browsed0.268 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/Language.php:805
1 row browsed0.263 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:1244
1 row browsed0.245 ms SELECT SQL_NO_CACHE SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND dr.`time_end` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:332
1 row browsed0.235 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /srv/www/test.protecwood.com/classes/Hook.php:182
86 rows browsed0.234 ms SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC
in /srv/www/test.protecwood.com/classes/QuickAccess.php:65
USING FILESORT - 5 rows browsed0.234 ms SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.233 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/shop/Shop.php:199
1 row browsed0.231 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
in /srv/www/test.protecwood.com/classes/Tab.php:276
101 rows browsed0.23 ms SELECT SQL_NO_CACHE IFNULL(SUM(`total_paid_real` / conversion_rate), "0") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = 1 AND `invoice_date` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:313
1 row browsed0.217 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.21 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
in /srv/www/test.protecwood.com/classes/Tab.php:222
101 rows browsed0.201 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers
in /srv/www/test.protecwood.com/classes/cache/CacheMemcache.php:202
1 row browsed0.186 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.183 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_REWRITING_SETTINGS" LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:45
1 row browsed0.182 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.169 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/Tab.php:203
1 row browsed0.169 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /srv/www/test.protecwood.com/classes/Language.php:698
1 row browsed0.167 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.162 ms SELECT SQL_NO_CACHE COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:320
1 row browsed0.156 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/shop/ShopUrl.php:154
1 row browsed0.156 ms SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE `id_country` = 8
in /srv/www/test.protecwood.com/classes/ObjectModel.php:219
1 row browsed0.154 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = 'cf97a074d2703875dcfab8f9f68175f7' AND active = 1 LIMIT 1
in /srv/www/test.protecwood.com/classes/Employee.php:223
1 row browsed0.153 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:60
1 row browsed0.149 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.147 ms SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:1291
1 row browsed0.145 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:219
1 row browsed0.143 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.139 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 1) LIMIT 1
in /srv/www/test.protecwood.com/classes/ObjectModel.php:212
1 row browsed0.127 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1
in /srv/www/test.protecwood.com/classes/Tab.php:178
101 rows browsed0.113 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:257
1 row browsed0.113 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:256
1 row browsed0.104 ms SELECT SQL_NO_CACHE COUNT(*) FROM ps_customer_thread LIMIT 1
in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:255
1 row browsed0.097 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers
in /srv/www/test.protecwood.com/classes/cache/CacheMemcache.php:202
1 row browsed
Doubles (IDs replaced by "XX") (total = 1)2 SELECT * FROM ps_memcached_servers
Tables stress6 tab4 shop4 shop_url3 tab_lang3 orders3 lang_shop3 lang3 configuration3 customer_thread2 customer2 currency_shop2 shop_group2 memcached_servers2 employee_shop2 country_lang2 country2 country_shop2 employee1 tab_module_preference1 order_state_lang1 date_range1 page_viewed1 page1 page_type1 quick_access_lang1 hook_alias1 hook_module1 module1 configuration_lang1 theme1 hook1 module_shop1 currency1 meta_lang1 meta1 quick_access
Included files

1 adminPW/index.php
2 config/config.inc.php
3 config/defines.inc.php
4 config/settings.inc.php
5 config/autoload.php
6 config/alias.php
7 classes/Autoload.php
8 cache/class_index.php
9 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 classes/db/Db.php
17 tools/profiling/Tools.php
18 classes/Tools.php
19 classes/Context.php
20 classes/shop/Shop.php
21 classes/db/DbPDO.php
22 classes/cache/Cache.php
23 classes/cache/CacheMemcache.php
24 classes/Validate.php
25 classes/db/DbQuery.php
26 config/defines_uri.inc.php
27 classes/Configuration.php
28 classes/Language.php
29 classes/Country.php
30 classes/Collection.php
31 classes/Cookie.php
32 classes/Rijndael.php
33 classes/Employee.php
34 classes/Link.php
35 classes/shop/ShopUrl.php
36 config/smarty.config.inc.php
37 tools/smarty/Smarty.class.php
38 tools/smarty/sysplugins/smarty_internal_data.php
39 tools/smarty/sysplugins/smarty_internal_templatebase.php
40 tools/smarty/sysplugins/smarty_internal_template.php
41 tools/smarty/sysplugins/smarty_resource.php
42 tools/smarty/sysplugins/smarty_internal_resource_file.php
43 tools/smarty/sysplugins/smarty_cacheresource.php
44 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45 config/smartyadmin.config.inc.php
46 adminPW/functions.php
47 ./images.inc.php
48 classes/Dispatcher.php
49 classes/Tab.php
50 controllers/admin/AdminHomeController.php
51 classes/controller/AdminController.php
52 classes/Translate.php
53 translations/fr/admin.php
54 classes/Profile.php
55 classes/Currency.php
56 classes/Media.php
57 classes/QuickAccess.php
58 classes/helper/Helper.php
59 classes/shop/ShopGroup.php
60 classes/module/Module.php
61 classes/Upgrader.php
62 classes/Chart.php
63 classes/order/Order.php
64 cache/smarty/compile/93/17/6f/93176fecf88d4fba3de0b9a656d3385c050fa6d2.file.optimizationTips.tpl.php
65 cache/smarty/compile/65/3d/ee/653deed35ad5f13530df3e5026ffa5a35601aea6.file.content.tpl.php
66 cache/smarty/compile/b5/d6/99/b5d69928a1a6a7f1f7379dac2576419cc7c5df9a.file.layout.tpl.php
67 cache/smarty/compile/67/25/82/6725826279815b2a1741aca643541569c78605ac.file.header.tpl.php
68 tools/smarty/plugins/modifier.escape.php
69 cache/smarty/compile/0a/48/47/0a4847d5c9fd4a46ac29fb09959b1c64dc48b298.file.footer.tpl.php

 

------------------------------------------------------------------------------------------------------------------------------

 

Merci d'avoir pris le temps de me lire ;-)

 

Cordialement,

 

Stephen Bousquet

Link to comment
Share on other sites
swed62 Newbie

swed62

Posted
Posted

Bonjour,

 

J'ai tous les 3/4 jours des problemes de lenteur back office après l ajout de produits.

 

J'ai appelé Prestashop qui m'ont forcément orienter vers leur hotline payante. De ce fait, je me suis tourné vers Ovh (offre mutualisé) et lui même n'a pas de réponse à ma question.

 

En cherchant sur le back office et après une regénération des miniatures, je me suis aperçu que cela revenait à la normale. Essaie de ton côté, peut être que....

Link to comment
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
Go to topic listing
×
×
  • Create New...