maria-discuss team mailing list archive

["J. Cassidy" <sean@xxxxxxxxxxxx>]

Hello all,


have used Sysbench extensively to test MariaDB CPU
load factors between various architectures.

I am noticing massive
amounts of "[ERROR] mysqld: Deadlock found when trying to get lock; try
restarting transaction" in the MariaDB error log during the R/W phase. The
Sysbench R/W TPS rates are still respectable for my purposes, but how do I
correct this condition?? Can I ignore this / must live with it?
I have
tried three different MariaDB releases (10.0.19, 10.1.12, 10.1.24) to narrow
things down, but this message (x 1000's) is happening across all releases in
the Sysbench R/W phase.

Here is the Sysbench command that drives the
workload against MariaDB -

sysbench --test=lua/oltp.lua
--oltp_tables_count=128 --oltp-table-size=85937 --rand-seed=42 --rand-type=uniform
--num-threads=128 --oltp-read-only=off --report-interval=2
--mysql-socket=/var/lib/mysql/mysql.sock --max-time=201 --max-requests=0
--mysql-user=root --percentile=99 run

Would anyone have a tip / idea
/pointer?


Regards,


JC


John
Cassidy

Obere Bühlstrasse 21
8700 Küsnacht (ZH)
Switzerland / Suisse / Schweiz


Mobile: +49 152 58961601
(Germany)
Mobile: +352 621 577 149 (Luxembourg)
Mobile: +41 78 769 17 97
(CH)
Landline: +41 44 509 1957

http://www.jdcassidy.eu

"Aut viam inveniam aut faciam" - Hannibal.