PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
The following table shows the expected form of the expr argument for each unit value. This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-synchronization.html
A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO 'cluster_app_user'@'localhost', works by directing NDB to create a snapshot using the queries SHOW CREATE USER cluster_app_user@localhost and SHOW GRANTS FOR ... NDB 8.0 introduces a new mechanism for sharing and synchronizing users, roles, and privileges between SQL nodes connected to an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
The string must be a suitable length for the Primary Account Number, but is not otherwise checked. Warning Values returned from gen_rnd_canada_sin() should be used only for test purposes, and are not suitable for publication. Warning Values returned ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Here are examples of how to solve some common problems with MySQL. Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This space must be ...