Slow prestashop

[mycloudcms]

Hi, we have a prestashop case with 10K, I have slow perfomance. My mind goes to mysql

Dedicated Server

CPU:Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz

RAM:16 GB

mysql:

innodb_file_per_table
max_connections=500
max_user_connections=300
wait_timeout=100
interactive-timeout=100
table_open_cache=1024
thread_cache_size=64
join_buffer=16M
sort_buffer=32M
table_open_cache=5000
key_buffer_size=512M
innodb_buffer_pool_size=2GB
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=8M
myisam_sort_buffer_size=128M
max_allowed_packet=32M
net_retry_count=512
thread_cache=8
thread_concurrency=32
server_id=1
collation_server=utf8_unicode_ci
character_set_server=utf8
tmp_table_size=128M
max_heap_table_size=128M
query_cache_limit=256K
query_cache_size=100MB
query_cache_type=1
concurrent_insert=2
low_priority_updates=1
open_files_limit=50000
default-storage-engine=MyISAM
slow_query_log

[mysqldump]
quick
max_allowed_packet=16M

 

 

Thank you!

[Web VIZO]

Hello,

What PrestaShop version are you using, and what are the settings under "Advanced Parameters  > Performance"?

 

Regards,
Web Development VIZO.

[selectshop.at]

Please check server requirements here, Both are tested with 20k in production.

https://www.prestashop.com/forums/topic/633856-server-requirements-tested-in-production-for-ps-16/

https://www.prestashop.com/forums/topic/633857-server-requirements-for-ps-17/

 

default-storage-engine should be InnoDB for PS 1.6. and 1.7.