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/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/order-by-optimization.html
The index may also be used even if the ORDER BY does not match the index exactly, as long as all unused portions of the index and all extra ORDER BY columns are constants in the WHERE clause. If the index does not contain all columns accessed by the ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Each statement summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-locks.html
The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current lock. The mode column shows the lock mode; this is always one of S (indicating a shared lock) or X (an exclusive ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
Database, table, column, and routine names can be up to 64 characters. Object Quoting Guidelines Several objects within GRANT statements are subject to quoting, although quoting is optional in many cases: Account, database, table, column, and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
A table can contain a maximum of 1017 columns (raised in MySQL 5.6.9 from the earlier limit of 1000). For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 ...