Performance settings dilema

[Courage2000]

I have my own server, with 26 Gb RAM dual  Xeon and what it will be a small bakery site and some small sites (WP).
Not really significant traffic, but I want to be as fast as possible in serving the pages.

Many info I've read are for previous versions of Prestashop, I have the newst version (1.7.6.4)

I run on the server CentOS 7.7

Server software version: Apache 2.4.6
PHP version: 7.3.16
Memory limit: 512M
Max execution time: 300
Upload Max File size: 128M
info_outline Database information
MySQL version: 5.7.29-32 PERCONA (INNODB)
MySQL server: localhost
MySQL engine: InnoDB
MySQL driver: DbPDO

I've installed Opcache and PHP 7.3 and configured like in the tutorials.
I've also installed php-pecl-apcu module (caching)

php.ini

[Date]
date.timezone = UTC
[Session]
session.auto_start = Off
[PHP]
short_open_tag = Off
display_errors = Off
magic_quotes_gpc = off
memory_limit = 512M

max_execution_time = 300
max_input_time = 300
upload_max_filesize = 20M
post_max_size = 22M
max_input_vars = 20000
allow_url_fopen = on

opcache.ini

opcache.revalidate_freq=0
;opcache.validate_timestamps=0 - still developing, not production
opcache.enable_file_override=1
opcache.interned_strings_buffer=64
opcache.memory_consumption=256
opcache.max_accelerated_files=20000

 

Quick questions:

1. Smarty cache: yes/no
2. If YES ->  Caching type: File system or MySQL (Percona)
3. Use cache (CacheApc): yes/no (remember, I have OPCache)
4. Do I still need to visit each page of the site in order to create cache (script based on sitemap.xml)?

5. Should I also add this to my Percona SQL server?

edit /etc/my.cnf end add:

 

query_cache_limit               = 128K
query_cache_size                = 32M
query_cache_type                = ON
Other important settings are:

table_open_cache                      = 1000
read_buffer_size                      = 2M
read_rnd_buffer_size                  = 1M
thread_cache_size                     = 80
join_buffer_size                      = 2M
sort_buffer_size                      = 2M
max_connections                       = 400
tmp_table_size                        = 32M
max_heap_table_size                   = 32M
table_definition_cache                = 1000
performance_schema                    = OFF

innodb_buffer_pool_size = 10G # (adjust value here, 50%-70% of total RAM)
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 1 # may change to 2 or 0
innodb_flush_method = O_DIRECT

 

Thank you!

[El Patron]

8 hours ago, Courage2000 said:

Quick questions:

1. Smarty cache: yes/no
2. If YES ->  Caching type: File system or MySQL (Percona)
3. Use cache (CacheApc): yes/no (remember, I have OPCache)
4. Do I still need to visit each page of the site in order to create cache (script based on sitemap.xml)?

5. Should I also add this to my Percona SQL server?

edit /etc/my.cnf end add:

1) yes

2) file system

3) opcache

4) yes

5) you should get mysql metric, see phpmyadmin 'localhost' stats and adjust as recommended by phpmyadmin or other mysql configuration checker.

 

happy ps'ing