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-replication-applier-status-by-worker-table.html
The replication_applier_status_by_worker table has these columns: CHANNEL_NAME The replication channel which this row is displaying. WORKER_ID The worker identifier (same value as the id column in the mysql.slave_worker_info table). After STOP ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (log apply index): This stage includes the application of DML log generated while ALTER TABLE was running. stage/innodb/alter table (log apply table): This stage includes the application of concurrent DML log generated while ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT DISTINCT, but it is inefficient to generate all matching rows first only to eliminate duplicates later. WHERE ...); Here, ot_i and it_i ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Values for TIMESTAMP columns are converted from the session time zone to UTC for storage, and from UTC to the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
SHOW EVENTS output has these columns: Db The name of the schema (database) to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
The NAME column displays the system-generated name for the temporary table, which is prefixed with “#sql”. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table columns (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
With a nonconstant initializer argument (such as a column name), the seed is initialized with the value for each invocation of RAND(). One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and ...ABS(X) Returns the absolute value of X, or NULL if X is ...