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/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). You can do this by creating ... You can add another replica to an existing replication configuration without stopping the source ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE ... The ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
For additional information about column indexes, see Section 13.1.14, “CREATE INDEX Statement”. Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/5.7/en/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. Also refer to the information provided in Section 2.9.4, “Securing the Initial MySQL Account”. A summary of the procedure ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Masking functions provide strict and relaxed masking of Primary Account Numbers. Because it cannot be guaranteed that the number generated is not assigned to a legitimate payment account, the result of gen_rnd_pan() should never be displayed, other ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. The storage engine also creates plain text data file having a name that begins with the table name and has a .CSV extension. If you examine the test.CSV ... The CSV storage engine stores data in text files using comma-separated values ...