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/charset-unicode-conversion.html
For the CHAR, VARCHAR, and TEXT data types, watch for these issues when converting your MySQL tables: Check all definitions of utf8mb3 columns and make sure they do not exceed the maximum length for the storage engine. Check all indexes on utf8mb3 ...In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data types (VARCHAR and the TEXT types), the maximum permitted length in characters is less for utf8mb4 columns than for utf8mb3 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. After an unexpected halt of a replica, upon restart the ...This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
max_latency The maximum single wait time of timed occurrences of the statement. err_count The total number of errors produced by occurrences of the statement. total_latency The total wait time of timed occurrences of the statement. avg_latency The ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has ...A ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Check whether there are any timed messages to be executed; if so, put these into the job buffer as well. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
Configuring Transaction Event Collection Transaction Boundaries Transaction Instrumentation Transactions and Nested Events Transactions and Stored Programs Transactions and Savepoints Transactions and Errors Configuring Transaction Event Collection ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. In addition, MAX_ROWS and MIN_ROWS can be used to determine the maximum and minimum numbers of rows, respectively, that can be stored in each partition. This section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
If a row does not exceed the maximum row length, all of it is stored locally within the page. If a row exceeds the maximum row length, variable-length columns are chosen for external off-page storage until the row fits within the maximum row length ...(These segments are different from the rollback segment, which actually contains many tablespace segments.) When a segment grows inside the tablespace, InnoDB allocates the first 32 pages to it one at a ...