PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
This section includes guidelines and information for the storage requirements for each data type supported by MySQL, including the internal format and size for storage engines that use a fixed-size representation for data types. The length prefix ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-best-practices.html
Run Upgrade Checker and Fix Incompatibilities MySQL Shell's Upgrade Checker Utility detects incompatibilities between database versions that must be addressed before performing the upgrade. MySQL supports upgrading between minor versions (within an ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-prerequisites.html
The upgrade checker works for all Bugfix, Innovation, and LTS releases of MySQL. Any such triggers must be dumped and restored to fix the issue. After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before ...
https://dev.mysql.com/doc/refman/9.7/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. In contrast to CHAR, VARCHAR values are stored as a 1-byte or 2-byte length prefix plus data. The length prefix indicates the number of bytes in the value. InnoDB encodes fixed-length fields greater than or equal to 768 bytes in length as variable-length fields, which can be stored ...
https://dev.mysql.com/doc/refman/9.7/en/charset-configuration.html
In such cases, starting the mysql client with --default-character-set=system_character_set—that is, setting the client character set to match the system character set—should fix the problem. The MySQL server has a compiled-in default character ...
https://dev.mysql.com/doc/refman/9.7/en/custom-benchmarks.html
After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next bottleneck. Most of the time, these problems would be much easier to fix if the systems were not already in production. Benchmark your ...
https://dev.mysql.com/doc/refman/9.7/en/data-types.html
For floating-point and fixed-point types, M is the total number of digits that can be stored (the precision). D applies to floating-point and fixed-point types and indicates the number of digits following the decimal point (the scale). MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/dynamic-format.html
If you have fixed-length columns that you access or change frequently in a table that also contains some variable-length columns, it might be a good idea to move the variable-length columns to other tables just to avoid fragmentation. Much less disk ... Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-mysql-cluster.html
However, if your application requires “five nines” availability, you should use fixed (numeric) IP addresses, since making communication between Cluster hosts dependent on services such as DNS and DHCP introduces additional potential points of ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html
You need to find out why a member is lagging behind and fix that or remove the member from the group. Alternatively, another way of fixing the issue specifically in Group Replication is to issue a STOP GROUP_REPLICATION statement and then a START ...