Some of the hard drive in Virtual machines moved from legacy sector size of 512 bytes to a larger, more efficient sector size of 4096 bytes, generally referred to as 4K sectors.
Operating system present in VM is windows10. We have a build package installing softwares when the build is being deployed on VM irrespective of underlying hard drive. Is there any way to detect the hard drive type?
Reason being, mysql installation breaks due to 4k and workaround is only possible if installation is successful and my.cnf is available for changes.
Based on the errors i reached here, Mysql Doc. I have mysql 5.7 and it says "Running the MySQL server on a 4K sector hard drive on Windows is not supported