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

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

  • Remove files and show the number of deleted files

    2 days ago
    Die Argumentliste ist zu lang (/usr/bin/rm)

    Remove all files starting with 2024 in mydir123 and show the number of deleted files:

    find mydir123 -name '2024*' -exec rm -vf {} \; | wc -l

  • find . -name '*' | xargs rm …

    2 days ago
    Die Argumentliste ist zu lang (/usr/bin/rm)
    find . -name '*' | xargs rm -v

  • Maybe Patch

    1 week 5 days ago
    Deprecated function: Creation of dynamic property Drupal Tablefield TablefieldFormatter::$ModuleHandler is deprecated

     

    https://www.drupal.org/project/tablefield/issues/3397688

  • /etc/my.cnf

    1 month 2 weeks ago
    Transaction isolation level REPEATABLE-READ The recommended level for Drupal is "READ COMMITTED". (Drupal Status Report)

     Edit "/etc/my.cnf" ( under [mysqld] ):

    transaction_isolation="READ-COMMITTED"

    Restart MariaDB / MySQL:

  • Create Sub-Directories with WGET

    1 month 3 weeks ago
    Wget - Eine Webseite rekursive downloaden

    wget -U 'Mozilla/MyUserAgent' -P MyTempDir123 --wait=0.2 --random-wait -nd -r -x -l 4 -e robots=off --reject

  • Ignore Binaries, JS, CSS etc

    1 month 3 weeks ago
    Wget - Eine Webseite rekursive downloaden

    wget -U 'Mozilla/MyUserAgent2024' -P MyOutPutDirectory --wait=1 --random-wait -nd -r -l 2 -e robots=off --reject

  • Intel(R) Xeon(R) E-2288G CPU @ 3.70GHz

    2 months 3 weeks ago
    CPU benchmarking with sysbench (single-threaded/all cores)

     

    # sysbench --threads="$(nproc)" cpu run

  • AMD Ryzen 7 PRO 3700 8-Core Processor

    2 months 3 weeks ago
    CPU benchmarking with sysbench (single-threaded/all cores)

    # sysbench --threads="$(nproc)" cpu run

  • Reload .bashrc without logging out

    2 months 3 weeks ago
    Linux Autovervollständigung - bash autocomplete
    source ~/.bashrc

    Diese Lösung wird empfohlen aber hat bei mir nicht funktioniert.

    Welche Alternative gibt es?

  • Composer + PHP 8.3

    2 months 3 weeks ago
    PHP-CLI auf PHP8.2 umstellen (für Composer, Drush etc)

    ln -snf /opt/plesk/php/8.3/bin/php /etc/alternatives/php