PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
Note As of MySQL 5.7.21, the Performance Schema setup_timers table is deprecated and is removed in MySQL 8.0, as is the TICKS row in the performance_timers table. The performance_timers table has these columns: TIMER_NAME The name by which to refer ...The rows that do not contain NULL indicate which timers you can use in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/5.7/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the plugin's deinitialization function and removes the row for the plugin from the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
For example, you cannot have a management node running on a PowerPC which directs a data node that is running on an x86 machine. NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
This can be used, for example, to create a shorter name by which to refer to a schema with a long name (such as info rather than INFORMATION_SCHEMA). Parameters in_db_name VARCHAR(64): The name of the schema for which to create the synonym. Given a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
CEILING(3.7004397181411) is 4, and V = POWER(2,4), which is 16.) Set N = F(column_list) & (V - 1). MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas ...
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign ...