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/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures in the default database, mysql. $> mysql -u root -p < ...To verify that, ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
innodb_buffer_data The total number of InnoDB data bytes allocated for the table. innodb_buffer_free The total number of InnoDB nondata bytes allocated for the table (innodb_buffer_allocated − innodb_buffer_data). These views summarize table ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Legal hexadecimal literals: X'01AF' X'01af' x'01AF' x'01af' 0x01AF 0x01af Illegal hexadecimal literals: X'0G' (G is not a hexadecimal digit) 0X01AF (0X must be written as 0x) Values written using X'val' notation must contain an even number of digits ...Lettercase of the digits and of any leading X does not ... Hexadecimal literal values are written using X'val' or 0xval ...
https://dev.mysql.com/doc/refman/8.0/en/join.html
Such subqueries must include an alias to give the subquery result a table name, and may optionally include a list of table column names in parentheses. If you mix comma joins with the other join types when there is a join condition, an error of the ... MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
JSON_PRETTY(json_val) Provides pretty-printing of JSON values similar to that implemented in PHP and by other languages and database systems. The value supplied must be a JSON value or a valid string representation of a JSON value. If the value is ...JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, the amount of storage space used by a given JSON value and the amount of space remaining in a JSON column following a partial ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features to be supported or enforced. Statements referencing such features, even if effectively ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-userguide.html
The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high availability and scalability using InnoDB based MySQL databases, without requiring advanced MySQL expertise. The X DevAPI ...In ... MySQL Shell is an advanced client and code editor for MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...It also defines a secondary index k_d on column (d), but internally InnoDB extends this index and treats it as columns (d, i1, ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...