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/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/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. LOAD DATA interprets all fields in ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When using statement-based logging, statements flagged as being unsafe generate a warning to this effect. To prevent this, MySQL 5.7 provides a warning suppression mechanism, which behaves as follows: Whenever the 50 most recent ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
If all binary logs on the server were generated using MySQL 5.7.8 or later and you are using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can always safely be used. With binlog_gtid_simple_recovery=TRUE, gtid_executed and gtid_purged might ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
The --name option, for supplying a custom name for your server container, is optional; if no container name is supplied, a random one is generated. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...