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/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). After copying, delete the ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
In the first phase, the clustered index is scanned, and index entries are generated and added to the sort buffer. Sorted Index Builds and Optimizer Statistics Sorted index builds may result in optimizer statistics that differ from those generated by ... InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily with SHOW SLAVE STATUS. Issuing START SLAVE on a multithreaded replica with gaps in the sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
overall: Generate an analysis based on the content of the table specified by in_table. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
The number of indexed columns in a table The number of partitions. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The INSTRUMENTED and HISTORY column values for new threads are determined by the contents of the setup_actors table. For information about how to use the setup_actors table to control these columns, see Section 25.4.6, “Pre-Filtering by Thread”.
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 6.2.3, “Grant Tables”, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
When converting utf8mb3 columns to utf8mb4, you need not worry about converting supplementary characters because there are none. In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...