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/range-optimization.html
For the data set shown earlier, the algorithm operates like this: Get the first distinct value of the first key part (f1 = 1). The predicates on A_1, ..., A_k must be equality predicates and they must be constants. The query must be a conjunctive ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
For the server, one exception applies: The mysqld-auto.cnf option file in the data directory is processed last, so it takes precedence even over command-line options. List the options in an option file that the program reads when it starts. It ...If ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). For remote cloning operations, the clone plugin must be installed on the donor and recipient ... This section describes how to install and configure the clone ...For general information about installing or uninstalling ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
However, REPAIR TABLE should be avoided because when one server replaces the data file with a new one, this is not known to the other servers. Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table ...If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: clients are using or haven't closed the table properly This warning doesn't necessarily mean that the table is corrupted, but you should at least check the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld.html
The data directory is also the default location for other information such as log files and status files. MySQL Server manages access to the MySQL data directory that contains databases and tables. mysqld, also known as MySQL Server, is a single ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
To generate a dump file, name the sys schema explicitly on the command line using either of these commands: mysqldump --databases --routines sys > sys_dump.sql mysqlpump sys > sys_dump.sql To reinstall the schema from the dump file, use this ...The ...Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
For LOAD DATA statements that include no CHARACTER SET clause, the server uses the character set indicated by the character_set_database system variable to interpret the information in the file. The CREATE DATABASE and ALTER DATABASE statements have ... Every database has a database character set and a database ...If CHARACTER SET charset_name is specified without ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server-side-help.html
The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). mysql> SHOW BINARY LOGS; ... mysql> help search_string If you ...For example, HELP rep% returns a list of topics that begin with rep: mysql> HELP rep% Many help items for your request ...
https://dev.mysql.com/doc/refman/8.0/en/null-values.html
The NULL value means “no data.” NULL can be written in any lettercase. For text file import or export operations performed with LOAD DATA or SELECT ... Be aware that the NULL value is different from values such as 0 for numeric types or the ...