PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has these columns: table_schema The schema that contains the table. The schema_redundant_indexes view displays ...
https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. If you do this often, it is very ... An ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html
Upgrades to MySQL 8.0.16 and higher may show an option to skip the upgrade check and process for system tables. Prior to MySQL 8.0.16, run mysql_upgrade as Administrator to check your tables, attempt to repair them if necessary, and update your ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
The following table compares the characteristics of the different compression algorithms and shows their assigned priorities. Instead, its default is to permit all algorithms shown in Table 22.1, “X Protocol Compression Algorithm ... From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
This section describes the acceptable formats for date and time literals. Beginning with MySQL 8.0.19, you can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. Standard SQL and ODBC Date and Time Literals String ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. This section describes how to assign a password to the initial root account created during ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
The most important differences between a document and the tables known from traditional relational databases are that the structure of a document does not have to be defined in advance, and a collection can contain multiple documents with different ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
mysqld_safe accepts options on the command line and in option files, as described in the following table. --core-file-size=size Command-Line Format --core-file-size=size Type String The size of the core file that mysqld should be able to create.