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/partitioning-maintenance.html
OPTIMIZE PARTITION to reclaim any unused space and to defragment the partition data file. Some MySQL storage engines, including InnoDB, do not support per-partition optimization; in these cases, ALTER TABLE ... Example: ALTER TABLE t1 REPAIR ... A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
Doing so means that potentially any file on the system can be read by MySQL, and thus—should MySQL be compromised—by an attacker. Note Many of the NDB Cluster utilities such as ndb_show_tables, ndb_desc, and ndb_select_all also work without ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
(That is, the statement fails if creating an account would cause the account to adopt a currently orphaned stored object.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning ...To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system ...It enables authentication, ...
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 ...On ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. To change the set of key sequences permitted by a given input library, ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... ANALYSE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-services.html
To set up multiple MySQL services, you must make sure that each instance uses a different service name in addition to the other parameters that must be unique per instance. Approach 1: Specify the options for all services in one of the standard ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Each connection parameter has a default ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
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 ...