installing RocksDB plugin increase InnoDB disk util from 1% to 100%
Description
Environment
Smart Checklist
Activity
Aaditya Dubey January 19, 2023 at 9:48 AM
Hi ,
We still haven't heard any news from you. So I assume reported issue is not persist and will close the ticket. If you disagree just reply and create a follow-up.
Aaditya Dubey June 3, 2022 at 7:56 AM
Hi ,
Thank you for the updates.
i have tried exact same steps to reproduce the issue but still it is not repeating, please find my test case below:
issue is not repeatable.
is it possible to record your screen and share with us to check the issue further? or screenshot of steps you trying to repeat the issue?
Andy S June 2, 2022 at 4:12 PM
Hi @aaditya.dubey!
In order to reproduce my bug report please do following:
1. Disable RocksDB
2. Restart mysqld
3. Run sysbench with --threads 1
4. Start iostat -x 1. very likely your disk util gonna be just 2-3% with 1 thread (i have ~1% because on NVMe)
5. Enable RocksDB plugin
6. Disk util gonna raise to 95-100%.
Aaditya Dubey June 2, 2022 at 3:09 PMEdited
Hi ,
Thank you for the report.
i have tried to repeat the issue but i do not see the constant disk utilization, please find my test case below:
please let us know full reproducible steps to further debug the issue.
Details
Details
Assignee
Reporter
Andy SComponents
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Enabling RocksDB plugin (without any configuration in my.cnf) immediately increasing innodb disk utilization from 1% to 100%.
How to replicate the issue:
1. Start disk IO monitoring
```iostat -x 1```
2. Start any load on innodb.
3. Enable RocksDB plugin
```ps-admin -k```
Effective immediately innodb disk utilization will raise to 100% (permanently until plugin disabled) and ```mysqladmin processlist``` gonna show almost all threads in state "waiting for handler commit", however without enabled plugin it's never a case.
Just disabling plugin won't resolve the issue unless mysqld process has been manually restarted.