PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
When doing bulk inserts into tables with auto-increment columns, set innodb_autoinc_lock_mode to 2 instead of the default value 1. For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. If you insert a row into a table partitioned by RANGE such that the column value ...Even though it is permitted to use NULL as the value of an expression that must otherwise yield an integer, it is important to keep in mind that NULL is not a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The events_transactions_current table has these columns: THREAD_ID, EVENT_ID The thread associated with the event and the thread current event number when the event starts. END_EVENT_ID This column is set to NULL when the event starts and updated to ...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/performance-schema-object-filtering.html
The OBJECT_TYPE column indicates the type of object to which a row applies. The OBJECT_SCHEMA and OBJECT_NAME columns should contain a literal schema or object name, or '%' to match any name. The ENABLED column indicates whether matching objects are ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 Table structure is also available ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The replication_applier_configuration table has these columns: CHANNEL_NAME The replication channel which this row ... This table shows the configuration parameters that affect transactions applied by the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
The replication_connection_status table has these columns: CHANNEL_NAME The replication channel which this row is displaying. Issuing RESET MASTER or RESET SLAVE resets the values shown in these columns. The following table shows the correspondence ... This table shows the current status of the replication I/O thread that handles the replica's connection to the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
No data is provided for the WORK_ESTIMATED column, which displays 0. Bounded progress instrumentation The WORK_COMPLETED and WORK_ESTIMATED columns are both meaningful. The Performance Schema instruments stages, which are steps during the ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. A row constructor is used for comparisons with subqueries that ...If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
This value is incremented if you are querying an index column with a range constraint or if you are doing an index scan. To monitor any replication channel, use the HEARTBEAT_INTERVAL column in the replication_connection_configuration table for the ... The MySQL server maintains many status variables that provide information about its ...