MariaDB Server Performance Optimieren

In /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]

#my custom changes
innodb_buffer_pool_size = 8G
query_cache_size=256M

MariaDB

MySQL

Neuen Kommentar schreiben

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 Booster

Antworten

Restart MariaDB / MySQL Mi, 12/11/2024 - 16:11

Commandline:

systemctl restart mariadb

Antworten

List config vaiables Mi, 12/11/2024 - 16:12

/usr/sbin/mariadbd --help --verbose | grep "query.*size"

Antworten

MariaDB Server Performance Optimieren

Comments

MariaDB Restart (after changes in /etc/mysql/db-performance.cnf) Mi, 12/11/2024 - 16:09

Restart MariaDB / MySQL Mi, 12/11/2024 - 16:11

List config vaiables Mi, 12/11/2024 - 16:12

Neuen Kommentar schreiben

Suche

Neueste Kommentare

Same with Drush 13 + PHP 8.3 and my Solution

Error : Failed to install the required package 'RPM' by using AP

Installieren & Aktivieren

I have a view with a path…

admin_toolbar 3.5.2 is the…

Tools & Settings >> Security…

List config vaiables

Restart MariaDB / MySQL

MariaDB Restart (after changes in /etc/mysql/db-performance.cnf)

Error: configure: error: no acceptable C compiler found in $PATH

Tags