group_concat_max_lenis by default higher or equal to
.envvariable. This ensures that if an error occurs when querying the data via Elasticsearch, there is no fallback to the MySQL server. In large projects, failure of the Elasticsearch leads to the MySQL server being completely overloaded otherwise.
shopware.mail.update_mail_variables_on_sendconfiguration, you can disable this source of database load:
php -i | grep 'PCRE JIT Target'or looking into the phpinfo page.
.envto save one SQL query on each request.
.env.local.phpfile is used in Production instead of a
.envfile not to parse an env file on any request. If you are using a containerized environment, all those variables can also be set directly in the environment variables
errorto reduce the amount of logged events. Also, limiting the
buffer_sizeof monolog prevents memory overflows for long-lived jobs:
business_event_handler_bufferhandler logs flows. Setting it to
errorwill disable the logging of flow activities that succeed.