PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
You should also check for configuration files such as /etc/my.cnf or the /etc/mysql directory and delete them. These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. The precise syntax and semantics depend on the storage engine used. In standard ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off'; Limitations. This optimization improves ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
For example, to enable the firewall in an option file, use these lines: [mysqld] mysql_firewall_mode=ON After modifying my.cnf, restart the server to cause the new setting to take effect. Before using MySQL Enterprise Firewall, install it according ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
The following example shows an example my.cnf file section used to configure SSL on a server and how activate it for Group Replication. Group communication connections as well as recovery connections, are secured using SSL. Configuring SSL for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
Copy your my.cnf configuration file or files to a safe place. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html
The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API ...