Bug #91908 problems when using solid state disk (SSD), with restoration and changes
Submitted: 6 Aug 2018 13:27 Modified: 10 Jun 2022 12:15
Reporter: MAuricio Zambrana Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Windows Severity:S4 (Feature request)
Version:5.5, 5.7 OS:Windows (10)
Assigned to: MySQL Verification Team CPU Architecture:x86 (Intel i5)
Tags: alter, restore, solid state disk (SSD)

[6 Aug 2018 13:27] MAuricio Zambrana
Description:
620/5000
PC with windows 10, and solid state disk drive (SSD)

when making changes in database, tables, restoration, it is ok and does not finish making the changes, it does not respond

for example if I make the change from a myisam table to annodb it hangs

ALTER TABLE basetest .table1 ENGINE = INNODB;

if I change the character type of the BD

  "d:\MySQL57\bin\mysql.exe" -e "ALTER DATABASE basetest CHARACTER SET latin1 COLLATE latin1_swedish_ci";

if I perform a restoration

"d:\MySQL57\bin\mysql.exe" --force basetest --default-character-set = latin1 < "D:\_\basetest_.sql"

but it does not happen the same if I use a standar hard drive

How to repeat:

I create and execute a bat file with administrator permission, which has the instructions of:
 taskkill / f / im mysqld.exe                      terminate the mysql process
 taskkill / f / fi "status eq not responding"
 net stop mysql57                                  I stop the service
 net start mysql57                                 start the new service
"d:\MySQL57\bin\mysql.exe" --force basetest --default-character-set = latin1 <"D: \_\basetest_.sql"

this must be done for each of the instructions and the restoration is just done

Suggested fix:
I create and execute a bat file with administrator permission, which has the instructions of:
 taskkill / f / im mysqld.exe                      terminate the mysql process
 taskkill / f / fi "status eq not responding"
 net stop mysql57                                  I stop the service
 net start mysql57                                 start the new service
"d:\MySQL57\bin\mysql.exe" --force basetest --default-character-set = latin1 <"D: \_\basetest_.sql"

this must be done for each of the instructions and the restoration is just done
[10 May 2022 12:15] MySQL Verification Team
Hello,

Thank you for the bug report.
Could you please provide exact steps to reproduce this issue at our end?

Regards,
Ashwini Patil
[11 Jun 2022 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".