Re: Failed to install MySQL Community Version 5.7.29

[Samson Lin]

The system which I took 14 mins to start MySQL v5.7.29 is running on VMware ESXi. dd testing result is as follows:

# dd if=/dev/zero of=/var/lib/mysql/deleteme.random bs=1024 count=137216
137216+0 records in
137216+0 records out
140509184 bytes (141 MB) copied, 0.705133 s, 199 MB/s

# dd if=/dev/zero of=/var/lib/mysql/deleteme.random bs=1024 count=137216 conv=sync
137216+0 records in
137216+0 records out
140509184 bytes (141 MB) copied, 6.39211 s, 22.0 MB/s

I installed another copy on VMware Workstation. dd testing result is as follows:

# dd if=/dev/zero of=/var/lib/mysql/deleteme.random bs=1024 count=137216
137216+0 records in
137216+0 records out
140509184 bytes (141 MB) copied, 1.18473 s, 119 MB/s

dd if=/dev/zero of=/var/lib/mysql/deleteme.random bs=1024 count=137216 conv=sync
137216+0 records in
137216+0 records out
140509184 bytes (141 MB) copied, 0.98326 s, 143 MB/s

The difference is ...
dd with conv=sync has a sudden drop in copy speed (22 MB/s) in VMware ESXi.

mysqld takes 14 mins to start on VMware ESXi but less than 1 min on VMware Workstation. Does it system issue, not related to MySQL software?