PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
ORDER BY RAND() LIMIT 15; Influencing ORDER BY Optimization For slow ORDER BY queries for which filesort is not used, try lowering the max_length_for_sort_data system variable to a value that is appropriate to trigger a filesort. This section ...An ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. During the checksum operation, the table is locked with a read lock ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
To specify a literal open ( or close parenthesis ) in a regular expression, it must be escaped: mysql> SELECT REGEXP_LIKE('(', '('); ERROR 3692 (HY000): Mismatched parenthesis in regular expression. Match any character (including carriage return and ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. It can also happen if you try to execute two queries that return data without calling mysql_use_result() or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
Group Replication Requirements For The MySQL Communication Stack The network address configured by the group_replication_local_address system variable for each group member must be set to one of the IP addresses and ports that MySQL Server is ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. To upgrade when using the Solaris package file format, you must remove the existing installation before ...To use this package, download the corresponding mysql-VERSION-solaris11-PLATFORM.pkg.gz file, then uncompress ... You can install ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
(Any option file changes that must be made are performed in the next step.) Adjust any references to the plugin system and status variables to refer to the corresponding component system and status variables. Suppose that previously you had ...In ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
PROCESSLIST_DB The default database for the thread, or NULL if none has been selected. For monitoring of events executed by the thread to occur, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. DATA_LENGTH The ...The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
column IS [NOT] NULL column IN (value_list) Each item in the value_list must be a constant, literal value. For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...Prior to ...