PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
There is an index on only a prefix of a column named in the ORDER BY clause. To obtain memory for filesort operations, as of MySQL 8.0.12, the optimizer allocates memory buffers incrementally as needed, up to the size indicated by the ... This ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on the amount of connection attribute data transmitted from client to server: A fixed limit imposed by the client ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The table implementation uses a fixed-size, in-memory ring buffer, with old events automatically discarded as necessary to make room for new ones. The error_log table is a view on a fixed-size, in-memory ring buffer, with old events automatically ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
If given, it must be specified as a /ns suffix immediately following the address. An address with no /ns suffix uses the host system global namespace. An address with a /ns suffix uses the namespace named ns. If given, it must be specified as a /ns ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
An alternative is convert them to fixed-length binary strings without delimiters. Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | ...