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/innodb-statistics-estimation.html
Enabling innodb_stats_on_metadata may reduce access speed for schemas that have a large number of tables or indexes, and reduce stability of execution plans for queries that involve InnoDB tables. See Section 10.2.1.23, “Avoiding Full Table ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-mysql-memory-use.html
In this example, memory instrument data is queried in the Performance Schema memory_summary_global_by_event_name table, which summarizes data by EVENT_NAME. The following example demonstrates how to use Performance Schema and sys schema to monitor ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next item. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Queries can be displayed vertically by terminating the query with \G instead of a semicolon. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
As with nonpartitioned tables, proper use of indexes can speed up queries on partitioned tables significantly. In addition, designing partitioned tables and queries on these tables to take advantage of partition pruning can improve performance ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...