PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-common-layer.html
A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 THREAD_ID: 24 SERVICE_STATE: ON COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. At any given time, a transaction may request a lock that ... When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record one" "2","record two" This format can be read, and even written, by spreadsheet applications ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Invoke the stored procedure like this: mysql> CALL mysql.mysql_cluster_move_privileges(); Query OK, 0 rows affected (22.32 sec) Depending on the number of rows in the privilege tables, this procedure may take some time to execute. Note For clients ...This is not needed when connecting a new SQL node to the cluster for the first ... NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute a definer-context stored procedure that executes with the privileges of a user who does have CREATE TEMPORARY TABLES and that creates a ... You ...
https://dev.mysql.com/doc/refman/5.7/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 ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...