PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). This is the Reference Manual for ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
The tables themselves continue to exist because their definitions are stored in .frm files on disk, but they are empty when the server restarts. A server restart also sets the maximum size of existing MEMORY tables to the global max_heap_table_size ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html
Assume that an existing 5.6 server is configured for the default TCP/IP port number (3306) and Unix socket file (/tmp/mysql.sock). -DMYSQL_TCP_PORT=port_number \ -DMYSQL_UNIX_ADDR=file_name \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.7.44 Here, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-send-buffers.html
To be backward-compatible with existing configurations, this parameter takes as its default value the sum of the maximum send buffer sizes of all configured transporters, plus an additional 32KB (one page) per transporter. The NDB kernel employs a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Note When using tot_key_writes, you should keep in mind that a write operation in this context updates the row if the key exists, and inserts a new row otherwise. In addition, a client may choose to end a scan before all potentially matching rows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-perror.html
ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent or temporary. Added to the MySQL NDB Cluster distribution in NDB 7.6, it is intended as a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
Invoke mysql_config_editor like this: mysql_config_editor [program_options] command [command_options] If the login path file does not exist, mysql_config_editor creates it. --warn, -w Warn and prompt the user for confirmation if the command attempts ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
For example, HELP rep% returns a list of topics that begin with rep: mysql> HELP rep% Many help items for your request exist. mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. This section describes how to use mysqldump to create delimited-text dump files. For ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This ensures that when the dump file is reloaded, it creates each database if it does not exist and makes it the default database so database contents are loaded into the same database from which they came. If the database to be reloaded does not ...