Timeline for Where is the MySQL variable - innodb_flush_method?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 14, 2013 at 3:55 | vote | accept | Sithu | ||
| Apr 12, 2013 at 18:25 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 719 characters in body
|
| Apr 12, 2013 at 18:16 | comment | added | RolandoMySQLDBA | Another FacePalm Moment : mamapop.com/wp-content/uploads/2012/02/… | |
| Apr 12, 2013 at 18:12 | comment | added | ypercubeᵀᴹ |
Yep: "On Windows, the flush method is always async_unbuffered and cannot be changed."
|
|
| Apr 12, 2013 at 18:10 | comment | added | RolandoMySQLDBA |
OMG it just hit me. This is a Windows question. For the Windows version of MySQL, O_DIRECT is not supported. It is available under Linux only.
|
|
| Dec 14, 2012 at 3:16 | comment | added | Sithu |
Thank you, Rolando. I found that have_innodb=YES and #skip-innodb. So, InnoDB engine is already available. When I added innodb_flush_method=O_DIRECT under the [mysqld] section, I could not restart mysql. I got the error "Windows could not start the mysql service on Local Computer. Error 1067 the process terminated unexpectedly". When I removed that line, I could restart the server. I could not add that variable anywhere in the file. Any idea?
|
|
| Dec 13, 2012 at 16:36 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |
