MySQL Variables sync_frm 数据库 参数变量解释及正确配置使用
本站中文解释
sync_frm是MySQL多实例服务器中的一个参数变量，用于控制同步.frm文件的频率。
设置方法：
1.在MySQL的配置文件中修改sync_frm参数:
[mysqld]
sync_frm=1
2.重新启动MySQL服务器来使变更生效:
sudo systemctl restart mysqld
官方英文解释
sync_frm
| Command-Line Format | --sync-frm[={OFF|ON}] |
|---|---|
| Deprecated | Yes |
| System Variable | sync_frm |
| Scope | Global |
| Dynamic | Yes |
| Type | Boolean |
| Default Value | ON |
If this variable is set to 1, when any nontemporary table is
created its .frm file is synchronized to
disk (using fdatasync()). This is slower
but safer in case of a crash. The default is 1.
This variable is deprecated in MySQL 5.7 and is
removed in MySQL 8.0 (when .frm
files become obsolete).
