Place Your Ad Here

Bug Lock contention on thread-read tracking under very high load

There is a bug in this version
X

Xon

Guest
I've had a client report that under very high number of readers, the insert on duplicate key update query that is part of markThreadReadByUser causes snowballing slow queries due to lock contention.

MySQL was set to report deadlocks, but did not report anything during this catastrophically slow queries. innodb_flush_log_at_trx_commit had the default value of 1, but changing it to 2 did not appear to help.

A sample of the slow query log for this query...

Read more

Continue reading...
 
You must log in or register to reply here.

Similar threads

X
Solved Lock contention on thread-read tracking under very high load
Replies
0
Views
54
XenForo General Discussions
Xon
X
B
Hot Redmi A3 2024 Frp Bypass। Without Disable Play Service। No need pc ,No Screen Lock , No Xshare।
Replies
0
Views
44
Xiaomi Mobiles
best-one1
B
GuDron
  • Sticky
Hot [Finally The Game Over] Samsung KG Lock: Easy Solution Guide
Replies
1
Views
100
Samsung
Jnthn
Jnthn
D
ITEL A60 LOCK FRP REMOVED BY PANDORA TOOL DONE
Replies
0
Views
40
Android Various Brands
Droidmaster
D
D
Tecno spark 8 Reset lock | FRP Done
Replies
0
Views
32
Tecno / Infinix
Droidmaster
D
Top Bottom
Back