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/mysql-cluster-sql-statements.html
row *************************** PLUGIN_NAME: ndbcluster PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50729.0 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: MySQL AB PLUGIN_DESCRIPTION: ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an ...For ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. If in the join ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
To see a command-specific help message, invoke mysql_config_editor as follows, where command is a command other than help: mysql_config_editor command --help --debug[=debug_options], -# debug_options Command-Line Format --debug[=debug_options] Type ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...