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/key-space.html
In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. You ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...Query performance benefits from the NOT NULL optimization, because it cannot include any NULL ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE bar LIKE '%baz%'; returns 0. Table 14.13 String Comparison Functions and ...A ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. To schedule regular rotation of the binary log master key on all applicable source and replica servers, you can enable the ... ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER INSTANCE defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. It requires the DELETE privilege for the mysql system schema because ... DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...