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/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...MySQL offers a variety of backup strategies from which you can choose the methods that best suit the requirements for your ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. The date and time data types for representing temporal values are DATE, TIME, ...
https://dev.mysql.com/doc/refman/5.7/en/general-security-issues.html
For information specifically about the access control system that MySQL uses for setting up user accounts and checking database access, see Section 2.9, “Postinstallation Setup and Testing”. For answers to some questions that are often asked ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
After starting the server, you should set up a password for it using the instructions in Section 2.9.4, “Securing the Initial MySQL Account”. Note The database must be initialized before MySQL can be started. The following sections provide more ... This section gives a general overview of starting the MySQL ...
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 ...