Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. After you have verified that the definitions are handled properly, dump the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any extension from the file name and uses the result to determine the name of the table into which ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and client forms: The server-side plugin is built into the server, but is disabled by default. The client-side plugin is built into the libmysqlclient ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
This operation can be slow if the table is large or if the indexes being rebuilt do not fit into the buffer pool. Less disk I/O is required to bring data into the buffer pool, or to perform full table scans. Once your data reaches a stable size, or ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-spatial-analysis.html
For a horizontal or a vertical linestring, the MBR is a rectangle degenerated into the linestring. For a point, the MBR is a rectangle degenerated into the point. For MyISAM and InnoDB tables, search operations in columns containing spatial data ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before the inner tables. Table expressions in the FROM clause of a query are ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Each of these partitions—p0, p1, and p2—is further divided into 2 subpartitions. In effect, the entire table is divided into 3 * 2 = 6 partitions. Subpartitioning—also known as composite partitioning—is the further division of each ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
BUCKET_QUANTILE The proportion of statements that fall into this or a lower bucket. The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section ...