PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...For other installation methods, you must initialize the data directory ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
The key to safe database management is making regular backups. Note InnoDB does not support databases that are restored using third-party backup tools. Hot Backups The mysqlbackup command, part of the MySQL Enterprise Backup component, lets you ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Database Compression versus Application Compression Decide whether to compress data in your application or in the table; do not use both types of compression for the same data. Compressing in the Database When enabled, MySQL table compression is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
(NDB 7.5.0) This parameter defines the amount of space (in bytes) available for storing database records. For large databases, it may be preferable to use a 64-bit operating system for this reason. An important point for both IndexMemory and ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-transid-mysql-connection-map=state Command-Line Format --ndb-transid-mysql-connection-map[=state] Type Enumeration Default Value ON Valid Values ONOFFFORCE Enables or disables the plugin that handles the ndb_transid_mysql_connection_map table ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
Example 16.2 Backup and restore scenario The stored functions GTID_IS_EQUAL(), GTID_IS_DISJOINT(), and GTID_IS_DISJOINT_UNION() can be used to verify backup and restore operations involving multiple databases and servers. In this example scenario, ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
replicate-do-db: Tells replication SQL thread to restrict replication to specified database. replicate-ignore-db: Tells replication SQL thread not to replicate to specified database. slave_parallel_type: Tells replica to use timestamp information ...