PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
An error is generated if auto-positioning is enabled and an anonymous transaction is encountered. When the binary log is off and gtid_next is set to AUTOMATIC, then no GTID is generated. To be able to safely configure the replication mode of an ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
FOR EXPORT is run, InnoDB generates a .cfg metadata file in the schema directory of the table. Note If you are importing a table from an encrypted tablespace, InnoDB generates a .cfp file in addition to a .cfg metadata file. FOR EXPORT is run, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-event-tables.html
For each event type, the _current, _history, and _history_long tables have the same columns. For _history_long, when the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. After ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
In the Default column, PREFIX stands for the value of the CMAKE_INSTALL_PREFIX option, which specifies the installation base directory. -DCMAKE_BUILD_TYPE=type The type of build to produce: RelWithDebInfo: Enable optimizations and generate debugging ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. When an index is added to an existing table, or when a column ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. If an application stores values from a function such as MD5() or SHA1() that returns a string of hex digits, more efficient storage and comparisons ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
The NDB storage engine does not support indexes on virtual generated columns. As with other storage engines, you can create an index on a stored generated column, but you should bear in mind that NDB uses DataMemory for storage of the generated ...