Sadržaj

Tuner and optimizers

https://github.com/major/MySQLTuner-perl https://github.com/BMDan/tuning-primer.sh

Apache 2

https://github.com/richardforth/apache2buddy

MariaDB test

sysbench /usr/share/sysbench/percona/tpcc.lua --mysql-socket=/run/mysqld/mysqld.sock --mysql-user=root --mysql-password='Mellon2021??!!' --mysql-db=fitness_central --time=100 --threads=24 --report-interval=1 --tables=5 --scale=50 --db-driver=mysql prepare

MariaDB db cleanup

sysbench /usr/share/sysbench/percona/tpcc.lua --mysql-socket=/run/mysqld/mysqld.sock --mysql-user=root --mysql-password='Mellon2021??!!'--mysql-db=fitness_central --time=100 --threads=24 --report-interval=1 --tables=5 --scale=50 --db-driver=mysql cleanup

PHP

sudo apt-get install -y php8.2-cli php8.2-common php8.2-mysql php8.2-zip php8.2-gd php8.2-mbstring php8.2-curl php8.2-xml php8.2-bcmath

sudo apt install php8.2-cli php8.2-common php8.2-imap php8.2-redis php8.2-snmp php8.2-xml php8.2-bcmath php8.2-curl php8.2-fpm php8.2-mbstring php8.2-xsl php8.2-xdebug php8.2-yaml php8.2-mysql php8.2-gd php8.2-psr -y

sudo apt install php8.2-common php8.2-mysql php8.2-xml php8.2-curl php8.2-gd php8.2-imagick php8.2-cli php8.2-dev php8.2-imap php8.2-mbstring php8.2-opcache php8.2-soap php8.2-zip -y