maria-discuss team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

I run sysbench frequently with MySQL (not MariaDB yet) and don't recall
ever seeing this error. But I use much larger values for --oltp-table-size.
You used 85937 and I use 1M or larger. Maybe there is too much data
contention with smaller tables, even if a large number of tables is used
(128 in your case). I use a smaller number of tables - between 4 and 20.

On Thu, Jun 8, 2017 at 12:48 AM, J. Cassidy <sean@xxxxxxxxxxxx> wrote:

> 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 <+49%201525%208961601> (Germany)
> Mobile: +352 621 577 149 <+352%20621%20577%20149> (Luxembourg)
> Mobile: +41 78 769 17 97 <+41%2078%20769%2017%2097> (CH)
> Landline: +41 44 509 1957 <+41%2044%20509%2019%2057>
>
> http://www.jdcassidy.eu
>
> "Aut viam inveniam aut faciam" - Hannibal.
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Mark Callaghan
mdcallag@xxxxxxxxx