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/replication-options-binary-log.html
Important Before enabling this variable, you must make certain that there are no dependencies between transactional and nontransactional tables; an example of such a dependency would be the statement INSERT INTO myisam_table SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. With InnoDB, these problems should be resolved during crash ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. Modifications that the ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
For information about MySQL storage engines, see Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, ... SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
If you do not have GNU tar on your system, install it with the following command: pkg install archiver/gnu-tar You should mount any file systems on which you intend to store InnoDB files with the forcedirectio option. (By default mounting is done ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. Reserving B-tree Page Space for Future Index Growth To set aside space for future index growth, you can use the innodb_fill_factor ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
When working with InnoDB tables, consider also the innodb_strict_mode system variable. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...