Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.0
-
debian sid
Description
i want share here my benchmark logs about last "PERFORMANT COMPILE" and today git master compile
i double checked 10 times checked my my.cnf and my automated bashscript, and i figured out more than 20 times read performance regression inside mariadb
this is may latest compile:
mariadb --version
|
mariadb from 11.8.0-MariaDB, client 15.2 for Linux (x86_64) using EditLine wrapper
|
root@vps:~/compile# uname -a
|
Linux vps 6.12.12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.12-1 (2025-02-02) x86_64 GNU/Linux
|
root@vps:~/compile# date
|
Thu Feb 6 06:00:26 PM CET 2025
|
|
11.8.0 edd52b7fc7d6500fd6fcf377c54c8dc2ed365061 |
Version: '11.8.0-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
|
2025-02-06 17:05:23 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
|
2025-02-06 17:05:23 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
|
2025-02-06 17:05:23 0 [Warning] 'proxies_priv' entry '@% mysql@vps' ignored in --skip-name-resolve mode.
|
2025-02-06 17:05:23 0 [Warning] 'user' entry '@vps' ignored in --skip-name-resolve mode.
|
2025-02-06 17:05:23 0 [Note] Server socket created on IP: '::'.
|
2025-02-06 17:05:23 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2025-02-06 17:05:23 0 [Note] InnoDB: Buffer pool(s) load completed at 250206 17:05:23
|
2025-02-06 17:05:23 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool
|
2025-02-06 17:05:23 0 [Note] Plugin 'wsrep-provider' is disabled.
|
2025-02-06 17:05:23 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2025-02-06 17:05:23 0 [Note] InnoDB: log sequence number 73966525460; transaction id 369018591
|
2025-02-06 17:05:23 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
|
2025-02-06 17:05:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
|
2025-02-06 17:05:23 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
|
2025-02-06 17:05:23 0 [Note] InnoDB: Opened 3 undo tablespaces
|
2025-02-06 17:05:23 0 [Note] InnoDB: End of log at LSN=73966525460
|
2025-02-06 17:05:23 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
|
2025-02-06 17:05:23 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-02-06 17:05:23 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB
|
2025-02-06 17:05:23 0 [Note] InnoDB: Using liburing
|
2025-02-06 17:05:23 0 [Note] InnoDB: Using AVX512 instructions
|
2025-02-06 17:05:23 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-02-06 17:05:23 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
|
2025-02-06 17:05:23 0 [Note] Starting MariaDB 11.8.0-MariaDB source revision edd52b7fc7d6500fd6fcf377c54c8dc2ed365061 server_uid ZaNAImpF1d14bSNP5nqiBemsjaA= as process 32
|
##############attention now comes first newest mariadb git master from today 3 times, after than my old benchmarks in uploaded file
Attachments
Activity
ok i will try my benchmarks longer than 10 seconds...
axel schwenke write to directly over mail to me when you have access to my mail, if not here is it my one time link
my f58 is 2 times compiled with success i bench it and report back
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] InnoDB: Buffer pool(s) load completed at 250211 18:37:05
Feb 11 19:37:05 Version: '11.8.0-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Warning] 'proxies_priv' entry '@% mysql@vps92562878' ignored in --skip-name-resolve mode.
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Warning] 'user' entry '@vps92562878' ignored in --skip-name-resolve mode.
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] Server socket created on IP: '::'.
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] Server socket created on IP: '0.0.0.0'.
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Plugin 'wsrep-provider' is disabled.
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: log sequence number 102899875270; transaction id 549895182
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Opened 3 undo tablespaces
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: End of log at LSN=102899875270
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Using liburing
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Using AVX512 instructions
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Number of transaction pools: 1
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Starting MariaDB 11.8.0-MariaDB source revision f5821aaf7731e1f74b970fdaf186b945ae012c9d server_uid Fcnuc7qRTivW46r/7ymVk4nAeEg= as process 32
here is my bench results with 120 second test. |
|
|
ofc user and pass and db name replaced with kate editor
|
|
|
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] InnoDB: Buffer pool(s) load completed at 250211 18:37:05 |
Feb 11 19:37:05 Version: '11.8.0-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections. |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] mariadbd: Event Scheduler: Loaded 0 events |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Warning] 'proxies_priv' entry '@% mysql@vps92562878' ignored in --skip-name-resolve mode. |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Warning] 'user' entry '@vps92562878' ignored in --skip-name-resolve mode. |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] Server socket created on IP: '::'. |
Feb 11 19:37:05 2025-02-11 18:37:05 0 [Note] Server socket created on IP: '0.0.0.0'. |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Plugin 'wsrep-provider' is disabled. |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Plugin 'FEEDBACK' is disabled. |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: log sequence number 102899875270; transaction id 549895182 |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Opened 3 undo tablespaces |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: End of log at LSN=102899875270 |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Completed initialization of buffer pool |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Using liburing |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Using AVX512 instructions |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Number of transaction pools: 1 |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] InnoDB: Compressed tables use zlib 1.3.1 |
Feb 11 19:37:04 2025-02-11 18:37:04 0 [Note] Starting MariaDB 11.8.0-MariaDB source revision f5821aaf7731e1f74b970fdaf186b945ae012c9d server_uid Fcnuc7qRTivW46r/7ymVk4nAeEg= as process 32 |
sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=--mysql-password=--mysql-db=--time=120 /usr/share/sysbench/oltp_read_only.lua run |
sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) |
|
|
Running the test with following options:
|
Number of threads: 2 |
Initializing random number generator from current time
|
|
|
|
|
Initializing worker threads...
|
|
|
Threads started!
|
|
|
SQL statistics:
|
queries performed:
|
read: 12055008 |
write: 0 |
other: 1722144 |
total: 13777152 |
transactions: 861072 (7175.47 per sec.) |
queries: 13777152 (114807.54 per sec.) |
ignored errors: 0 (0.00 per sec.) |
reconnects: 0 (0.00 per sec.) |
|
|
General statistics:
|
total time: 120.0014s |
total number of events: 861072 |
|
|
Latency (ms):
|
min: 0.13 |
avg: 0.28 |
max: 11.96 |
95th percentile: 0.41 |
sum: 239289.35 |
|
|
Threads fairness:
|
events (avg/stddev): 430536.0000/4033.00 |
execution time (avg/stddev): 119.6447/0.00 |
|
|
sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=--mysql-password=--mysql-db=--mysql-host=10.10.20.55 --mysql-port=3306 --time=120 /usr/share/sysbench/oltp_read_only.lua run |
sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) |
|
|
Running the test with following options:
|
Number of threads: 2 |
Initializing random number generator from current time
|
|
|
|
|
Initializing worker threads...
|
|
|
Threads started!
|
|
|
SQL statistics:
|
queries performed:
|
read: 9284464 |
write: 0 |
other: 1326352 |
total: 10610816 |
transactions: 663176 (5526.35 per sec.) |
queries: 10610816 (88421.64 per sec.) |
ignored errors: 0 (0.00 per sec.) |
reconnects: 0 (0.00 per sec.) |
|
|
General statistics:
|
total time: 120.0017s |
total number of events: 663176 |
|
|
Latency (ms):
|
min: 0.17 |
avg: 0.36 |
max: 11.93 |
95th percentile: 0.53 |
sum: 239360.87 |
|
|
Threads fairness:
|
events (avg/stddev): 331588.0000/190.00 |
execution time (avg/stddev): 119.6804/0.01 |
|
|
|
any news or updates made or figured out bottleneck ?
thanks and
best regards
And answer my questions!