PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. For example, if you need to write ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...Normally, you must write your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. The default setting for innodb_stats_on_metadata was changed to OFF when persistent optimizer statistics were enabled by default in ...For information about persistent optimizer statistics, see Section 14.8.11.1, “Configuring Persistent Optimizer Statistics ...Optimizer statistics ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 INT; ADD COLUMN is not an in-place operation for stored ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. Its arguments are the unit in which you want the result expressed, and the two dates for which to take the ...To determine how many years old each of your pets is, use the TIMESTAMPDIFF() ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
Each row provides information about the current state of a group. This is where most threads end up when the thread group has created more threads than needed for normal operation. Often a thread group needs additional threads for a short while and ... The TP_THREAD_GROUP_STATE table has one row per thread group in the thread ...
https://dev.mysql.com/doc/refman/5.7/en/load-index.html
In addition, indexes on partitioned tables can be preloaded for one, several, or all partitions. The IGNORE LEAVES modifier causes only blocks for the nonleaf nodes of the index to be preloaded. In other words, if you wish to preload indexes for all ...tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-thread-states.html
Committing events to binlog Opening mysql.ndb_apply_status Processing events The thread is processing events for binary logging. Shutting down Syncing ndb table schema operation and binlog This is used to have a correct binary log of schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. System variable ...The ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. SHOW COLUMNS displays information only for those columns for which you ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. InnoDB minimizes ...If the mutex or rw-lock becomes available during this period, the thread can continue immediately, in the same time ...