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/mysqldumpslow.html
Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. -a Do not abstract all numbers to N and strings to 'S'. -g pattern Type String Consider only queries that match the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed System Variable gtid_executed Scope Global Dynamic No Type String Unit set of GTIDs When used with global scope, this variable contains a representation of the set of all transactions executed on the server and GTIDs that have been set ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. In general, this is 0 for numeric ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Introduced 5.7.21 Type String The destination keyring plugin for key migration. --keyring-migration-host=host_name Command-Line Format --keyring-migration-host=host_name Introduced 5.7.21 Type String Default Value localhost The host location of the running server that is currently using one of the key migration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-secure-installation.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only the usual option groups, but also groups with the usual names and a suffix of str. --password=password, -p password Command-Line Format ... This ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
For more information about how NDB stores columns of blob types, see String Type Storage Requirements. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. The CONNECTION string contains the information required to connect to the remote server containing the table used for physical ...For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Recall that compression works by identifying repeated ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
This includes user-defined variables having a string value because they are treated as BLOB or TEXT columns, depending on whether their value is a binary or nonbinary string, respectively. Presence of any string column with a maximum length larger ... In some cases, the server creates internal temporary tables while processing ...