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/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This means that the same XA transaction can appear in the events_transactions_current ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 8.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = 'STRICT_TRANS_TABLES'; SET sql_mode = 'STRICT_ALL_TABLES'; STRICT_TRANS_TABLES enables strict mode for transactional ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
In MySQL, a server-side cursor is materialized into an internal temporary table. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the max_heap_table_size and tmp_table_size system ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-troubleshooting.html
If you downgrade from one release series to another, there may be incompatibilities in table storage formats. In this case, use mysqldump to dump your tables before downgrading. After downgrading, reload the dump file using mysql or mysqlimport to ...For examples, see Section 2.10.13, “Copying MySQL Databases to Another ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. Both HKDF and PBKDF2 can use salts, and their use is recommended to help prevent attacks based on dictionaries of common passwords or rainbow tables. mysql> SELECT ...If ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
To obtain metadata about events: Query the event table of the mysql database. For representation of event information in the mysql.event table, the execute_at, starts, and ends times are converted to UTC and stored along with the event time zone.
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. MySQL Enterprise Backup does a hot backup of all tables that use the InnoDB storage engine. For tables using MyISAM or ...