In /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
#my custom changes
innodb_buffer_pool_size = 8G
query_cache_size=256M
MariaDB Server Performance Optimieren
Suche
Neueste Kommentare
- 1 month 3 weeks ago[preflight] The following restricted PHP modes have non-empty values: {open_basedir}. This configuration is incompatible with drush.
Same with Drush 13 + PHP 8.3
- 1 month 3 weeks agoAcronis CyberProtect Agent For Linux (Strato Root Server)
Initializing...
Error : Failed to install the required package 'RPM' by using APT. Please install it manually.
Exit
Solution:
- 1 month 3 weeks agoAcronis CyberProtect Agent For Linux (Strato Root Server)
So habe es installiert und dann mit Hilfe von Key/Code (über Website von Acronis Cyber Protect) aktiviert:
- 1 month 3 weeks agoNo route found for the specified format html. Supported formats: csv, json. (Drupal Routing)
I have a view with a path like
/my-content-exportto export entivies as JSON or CSV. - 2 months agoInvalidArgumentException: The controller for URI "/admin/flush" is not callable.
admin_toolbar 3.5.2 is the reason. Patch coming ...
- 2 weeks 6 days agoPDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock
Drupal 10.4:
- 2 months 4 weeks agoServer install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr
Tools & Settings >> Security Policy :
Allow only secure FTPS connections
- 4 months 1 week agoMariaDB Server Performance Optimieren
/usr/sbin/mariadbd --help --verbose | grep "query.*size" - 4 months 1 week agoMariaDB Server Performance Optimieren
Commandline:
systemctl restart mariadb - 4 months 1 week agoMariaDB Server Performance Optimieren
After my changes in /etc/mysql/db-performance.cnf
Comments
MariaDB Restart (after changes in /etc/mysql/db-performance.cnf) Mi, 12/11/2024 - 16:09
After my changes in /etc/mysql/db-performance.cnf
# next values added by Plesk Performance Booster [mysqld] innodb_flush_log_at_trx_commit = 2 innodb_flush_neighbors = 0 innodb_flush_method = O_DIRECT_NO_FSYNC innodb_io_capacity = 450 innodb_random_read_ahead = ON table_open_cache = 2000 #innodb_buffer_pool_size = 134217728 innodb_log_file_size = 33554432 # my changes 2 innodb_buffer_pool_size = 8G query_cache_size = 256M # values above added by Plesk Performance BoosterRestart MariaDB / MySQL Mi, 12/11/2024 - 16:11
Commandline:
List config vaiables Mi, 12/11/2024 - 16:12
/usr/sbin/mariadbd --help --verbose | grep "query.*size"Neuen Kommentar schreiben