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/merge-table-problems.html
MySQL ensures that unique key values remain unique within that MyISAM table, but not over all the underlying tables in the collection. DROP TABLE on a table that is in use by a MERGE table does not work on Windows because the MERGE storage engine's ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/8.0/en/my-print-defaults.html
For example, the mysqlcheck program reads the [mysqlcheck] and [client] option groups. To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
If your working directory is the test database directory, invoke myisam_ftdump as follows: myisam_ftdump mytexttable 1 If the path name to the test database directory is /usr/local/mysql/data/test, you can also specify the table name argument using ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...Then ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, FIXED. In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. Number literals include exact-value (integer and DECIMAL) literals and approximate-value ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...The user_defined_functions table lists loadable functions installed using CREATE FUNCTION as well as loadable functions installed automatically by components or ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-memory-management.html
The innodb_ddl_buffer_size variable, introduced in MySQL 8.0.27, defines the maximum buffer size for online DDL operations. Prior to MySQL 8.0.27, innodb_sort_buffer_size variable defines the buffer size for online DDL operations that create or ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
The number of parallel threads that sort and load data is controlled by the innodb_ddl_threads variable, introduced in MySQL 8.0.27. The maximum setting is 256, which is the maximum number for all sessions. The actual number of threads that scan the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.