Sysbench is a benchmark suite which allows you to quickly get an impression of system performance which is important if you plan to run a database under intensive load. In this topic we will only deal with database tests, but sysbench is also capable of performing CPU and FILE IO tests.
Installing sysbench:
For non-root user run command below first or use "sudo" ahead commands:
On Debian/Ubuntu:
On CentOS or Fedora, it can be installed from EPEL repository.
Add EPEL repository:
Then install:
Download the script to run the database tests:
Give privileges to the file:
Every time you modify your mariadb configuration use the commands below to avoid problems:
run script:
You can also use MySQLTuner to help you choose a better config:
results:
What should we pay attention to in the results:
transactions (high better).
latency (less better).
Installing sysbench:
For non-root user run command below first or use "sudo" ahead commands:
sudo su
On Debian/Ubuntu:
apt install sysbench
On CentOS or Fedora, it can be installed from EPEL repository.
Add EPEL repository:
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
yum -y install epel-release
yum -y update
Then install:
yum install sysbench
Download the script to run the database tests:
wget -cO -https://pastebin.com/raw/D1bX0Thz > sysbench-mariadb.sh
Give privileges to the file:
chmod 750 sysbench-mariadb.sh
Every time you modify your mariadb configuration use the commands below to avoid problems:
service mysql stop
rm -rf /var/lib/mysql/ib_log*
service mysql restart
run script:
After starting the test wait until the message below appears on the terminal../sysbench-mariadb.sh
sysbench-mariadb.sh script finished!
You can also use MySQLTuner to help you choose a better config:
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. - GitHub - major/MySQLTuner-perl: MySQLTu...
Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками Вход или Регистрация
github.com
results:
What should we pay attention to in the results:
transactions (high better).
latency (less better).
vps google cloud n2-standard-2 Intel(R) Xeon(R) CPU @ 2.80GHz - 2 cores architecture: x86_64 ssd 35G ram 8G | vps google cloud n2-standard-2 Intel(R) Xeon(R) CPU @ 2.80GHz - 2 cores architecture: x86_64 ssd 35G ram 8G | vps oracle cloud VM.Standard.A1.Flex ARM Neoverse-N1 50.00 BogoMIPS - 4 cores architecture: aarch64 ssd 50G ram 24G | vps oracle cloud VM.Standard.A1.Flex ARM Neoverse-N1 50.00 BogoMIPS - 4 cores architecture: aarch64 ssd 50G ram 24G |
MariaDB 10.5.12 default config with only increased max_connections = 300 | MariaDB 10.5.12 custom config | MariaDB 10.6.5 default config with only increased max_connections = 300 | MariaDB 10.6.5 custom config |
Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками
Вход или Регистрация
|
Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками
Вход или Регистрация
|
Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками
Вход или Регистрация
|
Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками
Вход или Регистрация
|