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/group-replication-limitations.html
Adjust the value of this variable depending on the maximum message size that you need the group to tolerate, bearing in mind that the time taken to process a transaction is proportional to its size. Concurrent data definition statements and data ...
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/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog ...Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
Using the PARTITIONS keyword without a number following it results in a syntax error. You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. The following examples show other common error messages you might encounter when installing MySQL and starting the ...This section helps you diagnose and correct some of these ...The default data directory location is C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”. The job of the Performance Schema instrumentation is to provide row count and accumulated ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. The ...SHOW WARNINGS displays information about the conditions resulting from execution of the most recent nondiagnostic statement in the current ...