I'm adding additional information here. It seems that the issue is not related to mysql-8.0 but the kernel or qemu. After the sysbench test starts to output lines with "tps: 0.00 qps: 0.00", the command:
# ls /data/mysql
sometimes list the files, but sometimes hang.
Whatever the MySQL daemon does, it is not expected to cause a hang of the file-system for other processes. Also the command
Hello,
I'm adding additional information here. It seems that the issue is not related to mysql-8.0 but the kernel or qemu. After the sysbench test starts to output lines with "tps: 0.00 qps: 0.00", the command:
# ls /data/mysql
sometimes list the files, but sometimes hang.
Whatever the MySQL daemon does, it is not expected to cause a hang of the file-system for other processes. Also the command
# dd if=/dev/vdb of=/dev/null bs=512 count=1 iflag=direct
hangs, but does not show up as an outstanding storage operation in iostat (%util of /dev/vdb remains 0).
Additionally, please find in the attached file the output from:
# echo w > /proc/sysrq-trigger
I hope that this helps!
Best regards,
Nikolay Tenev