I have big problem. Prestashop very slow ?

[teerapol2522]

Hi All.

 

      I use prestashop v1.5.4 , it's very slow for open this web

 

http://brecosmetic.com
 

     How can I  fig it?


It's result mysqltunner

 

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster

[--] Data in MyISAM tables: 1G (Tables: 3908)

[--] Data in InnoDB tables: 29M (Tables: 843)

[--] Data in MEMORY tables: 0B (Tables: 7)

[!!] Total fragmented tables: 269

 

-------- Security Recommendations  -------------------------------------------

[!!] User 'fnoutlet_fnrep@localhost' has no password set.

[!!] User 'systop_newpatara@%' has no password set.

[!!] User 'systop_newpatara@localhost' has no password set.

 

-------- Performance Metrics -------------------------------------------------

[--] Up for: 13m 55s (14K q [17.822 qps], 914 conn, TX: 100M, RX: 1M)

[--] Reads / Writes: 87% / 13%

[--] Total buffers: 322.0M global + 18.5M per thread (1000 max threads)

[!!] Maximum possible memory usage: 18.4G (316% of installed RAM)

[OK] Slow queries: 0% (0/14K)

[OK] Highest usage of available connections: 2% (21/1000)

[OK] Key buffer size / total MyISAM indexes: 16.0M/476.5M

[OK] Key buffer hit rate: 99.2% (117K cached / 974 reads)

[OK] Query cache efficiency: 75.8% (6K cached / 9K selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 812 sorts)

[!!] Joins performed without indexes: 5

[!!] Temporary tables created on disk: 32% (87 on disk / 268 total)

[OK] Thread cache hit rate: 97% (21 created / 914 connections)

[OK] Table cache hit rate: 99% (4K open / 4K opened)

[OK] Open file limit used: 65% (7K/12K)

[OK] Table locks acquired immediately: 100% (3K immediate / 3K locks)

[OK] InnoDB data size / buffer pool: 29.0M/256.0M

 

-------- Recommendations -----------------------------------------------------

General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    MySQL started within last 24 hours - recommendations may be inaccurate

    Reduce your overall MySQL memory footprint for system stability

    Enable the slow query log to troubleshoot bad queries

    Adjust your join queries to always utilize indexes

    When making adjustments, make tmp_table_size/max_heap_table_size equal

    Reduce your SELECT DISTINCT queries without LIMIT clauses

Variables to adjust:

  *** MySQL's maximum memory usage is dangerously high ***

  *** Add RAM before increasing MySQL buffer variables ***

    join_buffer_size (> 16.0M, or always use indexes with joins)

    tmp_table_size (> 32M)

 

[Dh42]

Hmm the site is not seeming to load. 

 

Tell me more about the server you are on. What kind of hosting do you have?

 

Also how many customer accounts, products, categories, and other stats like that. 

[teerapol2522]

Hi ,

 

   CENTOS 5.8 x86_64 
  Intel® Xeon® CPU X3440 @ 2.53GHz
  Ram 6 G  
  run  on cPanel

 Category 8
Product 41

 Backend can open normally and fast but front end have problem
 

[Dh42]

Are you on a shared server or a dedicated server?

[teerapol2522]

Hi ,  

 

    I use share server but load avg. don't high.
 

top - 11:56:32 up 42 days, 17:58,  3 users,  load average: 0.34, 0.55, 0.62

Tasks: 338 total,   1 running, 326 sleeping,   0 stopped,  11 zombie

Cpu0  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st

Cpu1  :  0.0%us,  0.3%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st

Cpu2  :  0.0%us,  0.0%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.7%si,  0.0%st

Cpu3  :  0.0%us,  0.0%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st

Cpu4  :  7.3%us,  0.7%sy,  0.0%ni, 92.1%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st

Cpu5  :  0.3%us,  0.3%sy,  0.0%ni, 99.0%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st

Cpu6  :  0.3%us,  0.3%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st

Cpu7  :  0.3%us,  0.0%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st

Mem:   6096280k total,  5668020k used,   428260k free,   294312k buffers

Swap:  4096532k total,      160k used,  4096372k free,  4420628k cached

 

 

    mysql process

[Dh42]

More than likely they are throttling your account. What hosting company are you with, you might consider upgrading or switching. 

[teerapol2522]

Hi,

 

   You mean I must to change hosting?  But backend can work normally , I think some script or module on front end load very long time.

But I can't find it . Do you plugin or module for monitor load process by module?

[Dh42]

You can turn on debug profiling and see what is output. 

[teerapol2522]

Hi,

   

    I already check , result

 

Load time: 55.52s
You'd better run your shop on a toaster

• config: 161ms
• constructor: 0ms
• init: 72ms
• checkAccess: 0ms
• setMedia: 4ms
• postProcess: 0ms
• initHeader: 0ms
• initContent: 55.248s
• initFooter: 21ms
• display: 14ms

Hook processing: 55.279s / 17.99 Mb

• displayRightColumn: 54.36s / 0.84 Mb
• displayTop: 577ms / 7.6 Mb
• displayHeader: 153ms / 7.53 Mb
• displayLeftColumn: 124ms / 0.85 Mb
• displayHome: 33ms / 0.41 Mb
• displayFooter: 21ms / 0.58 Mb
• moduleRoutes: 11ms / 0.18 Mb
• DisplayOverrideTemplate: 0ms / 0 Mb
• actionFrontControllerSetMedia: 0ms / 0 Mb
• actionDispatcher: 0ms / 0 Mb

Memory peak usage: 33.39 Mb

• config: 8.87 Mb
• constructor: 0 Mb
• init: 4.25 Mb
• checkAccess: 0 Mb
• setMedia: 0.23 Mb
• postProcess: 0 Mb
• initHeader: 0.01 Mb
• initContent: 17.24 Mb
• initFooter: 0.59 Mb
• display: 0.61 Mb

• 
    
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•     displayRightcolume problem???????????

[teerapol2522]

Hi , 

 

     I  found problem on module install at Right colume.  Problem is Paypal module  When I disable  It can open normally.
What problem ?  Connection to paypal problem ( hosting in Thai )