Command-Line Format --binlog-row-event-max-size=# System Variable ( ≥  8.0.14) binlog_row_event_max_size Scope ( ≥  8.0.14) Global Dynamic ( ≥  8.0.14) No SET_VAR  Hint Applies ( ≥  8.0.14) No Type Integer Default Value 8192 Minimum Value 256 Maximum Value (64-bit platforms) 18446744073709551615 Maximum Value (32-bit platforms) 4294967295 Replication and Binary Logging Options and Variables Command-Line Format --log-bin=file_name Type File name 3541 In earlier MySQL versions, binary logging was disabled by default, and was enabled if you specified the --log-bin  option. From MySQL 8.0, binary logging is enabled by default, whether or not you specify the  --log-bin  option. The exception is if you use  mysqld  to initialize the data directory manually by invoking it with the  --initialize  or  --initialize-insecure  option, when binary logging is disabled by default. It is possible to enable binary logging in this case by specifying the  --log-bin The default location for binary log files is the data directory. You can use the  --log-bin  option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. When the server reads an entry from the binary log index file, which tracks the binary log files that have been used, it checks whether the entry contains a relative path. If it does, the relative part of the path is replaced with the absolute path set using the  --log-bin  option. An absolute path recorded in the binary log index file remains unchanged; in such a case, the index file must be edited manually to enable a new path or paths to be used. The binary log file base name and any specified path are available as the  log_bin_basename  system variable. If you do not supply the  --log-bin  option, MySQL uses  binlog  as the default base name for the binary log files. For compatibility with earlier releases, if you supply the  --log-bin  option with no string or with an empty string, the base name defaults to  host_name -bin , using the name of the host machine. Specifies the base name to use for binary log files. With binary logging enabled, the server logs all statements that change data to the binary log, which is used for backup and replication. The binary log is a sequence of files with a base name and numeric extension. The  --log-bin  option value is the base name for the log sequence. The server creates binary log files in sequence by adding a numeric suffix to the base name. When row-based binary logging is used, this setting is a soft limit on the maximum size of a row-based binary log event, in bytes. Where possible, rows stored in the binary log are grouped into events with a size not exceeding the value of this setting. If an event cannot be split, the maximum size can be exceeded. The value must be (or else gets rounded down to) a multiple of 256. The default is 8192 bytes. • --log-bin[= base_name ]