How to enable / disable double buffer in mysql?

Question

How to enable / disable double buffer in mysql?

How to check if double-write buffer is on or off?

Answer 1

There is a server variable with a similar name innodb_doublewritethat can be used to check if this write method is enabled:

mysql> select @@ innodb_doublewrite;
+ ---------------------- +
| @@ innodb_doublewrite |
+ ---------------------- +
| 1 |
+ ---------------------- +
1 row in set (0.15 sec)

To set the appropriate mode, use the parameter --innodb-doublewritefor the server start command (CLI) or innodb_doublewrite.

Answer 2

InnoDB/XtraDB ( , innodb_file_per_table ), - .

(innodb_doublewrite_file), .