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/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of the cluster_operations table, in which operations for other SQL and API ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. This information is shown in the table's status column, which can have any one of the following values: CONNECTING, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
If the destination table does not exist, logging occurs as follows. ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. This includes the case that the destination table exists and IF NOT EXISTS ...SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. CHECK ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/8.0/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Alternatively, MySQL Workbench 6.3.4 or higher provides a graphical interface for firewall control. Alternatively, to set and persist the firewall setting at runtime: SET PERSIST mysql_firewall_mode = OFF; SET PERSIST mysql_firewall_mode = ON; SET ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
To see the default InnoDB stopword list, query the Information Schema INNODB_FT_DEFAULT_STOPWORD table. The stopword table must have a single VARCHAR column named value. The following example demonstrates creating and configuring a new global ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
When modifying multiple tables within a transaction, or different sets of rows in the same table, do those operations in a consistent order each time. Add well-chosen indexes to your tables so that your queries scan fewer index records and set fewer ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Define additional table identifiers in the innodb_memcache.containers table, and use the @@table_id.key ...This ...