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/grant-tables.html
This change of grant table storage engine enables an accompanying change to the behavior of account-management statements such as CREATE USER or GRANT. For example, the 'root'@'localhost' account created during MySQL installation has a row in the ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Using temporary (JSON property: using_temporary_table) To resolve the query, MySQL needs to create a temporary table to hold the result. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
InnoDB supports FOR EXPORT for tables that have their own .ibd file file (that is, tables created with the innodb_file_per_table setting enabled). | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS ...Note It is not possible to issue FLUSH statements within stored functions or ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The TABLESPACE option can be used with CREATE TABLE to create tables in a general tablespaces, file-per-table tablespace, or in the system tablespace. Creating a General Tablespace General tablespaces are created using CREATE TABLESPACE ...To make an ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
The sampling-rate value in the HISTOGRAM column of the Information Schema COLUMN_STATISTICS table can be queried to determine the fraction of data that was sampled to create the histogram. row *************************** Table: employees.employees ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
To dump grant table contents as logical definitions in the form of CREATE USER and GRANT statements, use the --users option and suppress all database dumping: mysqlpump --exclude-databases=% --users In the preceding command, % is a wildcard that ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED ...The last row has a Msg_type value of status and the Msg_text normally should be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
The ndb_binlog_index and ndb_apply_status tables are created in the mysql database. User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread.
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
--replicate-do-table=db_name.tbl_name Command-Line Format --replicate-do-table=name Type String Creates a replication filter by telling the replication SQL thread to restrict replication to a given table. You can also create such a filter by issuing ...On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 ... This section explains the server options and system variables that apply to replica servers and contains the following: ...