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

Comments

Profile picture for user Guest

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

Neuen Kommentar schreiben

Hilfe zum Textformat
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Suche

Neueste Kommentare

  • Same problem

    2 days 14 hours ago
    Warning: Undefined array key "url" in Drupal\Core\Asset\CssCollectionOptimizerLazy->optimizeGroup() 
    Warning: Undefined array key "url" in Drupal\Core\Asset\JsCollectionOptimizerLazy->optimizeGroup()

  • set-timezone Europe/Berlin

    4 days 16 hours ago
    Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr
    sudo timedatectl set-timezone Europe/Berlin

  • Try this:1. Go to  Tools &…

    1 week 4 days ago
    Warning: PHP Startup: Unable to load dynamic library 'apcu.so' ... cannot open shared object file: No such file or directory

    Try this:

  • Alternative (without warnings like "no crontab for user")

    3 weeks 3 days ago
    List Cronjobs for all users (via for + crontab)

    Alternative (without warnings like "no crontab for dovecot") to see all tasks:

  • php 8.3 apcu

    3 weeks 1 day ago
    Install APCu (PHP 8.1, Plesk)

    php 8.3 apcu failed

    über Plesk hat es geklappt.

     

  • phpize failed error?

    3 weeks 1 day ago
    Install APCu (PHP 8.1, Plesk)

     

    install:

    # sudo apt install php-dev

  • phpize
    # sudo apt install…

    3 weeks 1 day ago
    pecl install apcu : phpize: not found / ERROR: `phpize' failed

    phpize

    # sudo apt install php-dev

     

    details

  • Problem:
    /opt/plesk/php/8.3…

    3 weeks 1 day ago
    Install APCu (PHP 8.1, Plesk)

    Problem:

  • Problem:PHP APCu caching…

    2 months 1 week ago
    Install APCu (PHP 8.1, Plesk)

    Problem:

  • Hilft "cp -avf old new && rm…

    3 months 2 weeks ago
    Linux mv: das Verschieben von 'new' nach 'old' ist nicht möglich: Das Verzeichnis ist nicht leer

    Hilft "cp -avf old new && rm -rvf old" nicht?