PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be specified. On 32-bit platforms, the supported range of values for this function is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to fail. In this case, remove all redo log files and restart the MySQL 5.7 server on the existing data ...If ...To address this issue, dump and restore affected tables before attempting the upgrade ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to ...The size of the table slows down the insertion of indexes by log N, assuming B-tree ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
To modify an account that uses passwordless authentication, you must have the PASSWORDLESS_USER_ADMIN privilege. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. It ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...Suffixes ...The elements of an instrument name from left to right provide a progression from more general to more ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
They do not help marking a specific point in time to which the server joining the group must catch up, nor do they convey certification information. This is the job of binary log view markers, which mark view changes in the binary log stream, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
Note It is possible to use multiple network hardware interfaces (such as Ethernet cards) for a single data node, but these must be bound to the same address. Stored procedures, stored functions, triggers, and scheduled events are all supported by ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
The arrays in your file must have names like ctype_MYSET, to_lower_MYSET, and so on. For each <collation> element listed in the <charset> element for the character set in Index.xml, the ctype-MYSET.c file must provide an implementation of the ...To ... This section discusses the procedure for adding a character set to ...For example, greek and swe7 are ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...