Search the Community

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!