PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The DECIMAL data type is a fixed-point type and calculations are exact. In MySQL, the DECIMAL type has several synonyms: ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
is not allowed to connect to this MySQL server You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect. To fix it, execute mysqladmin flush-hosts to reset the internal ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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 ...