Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid values. Precision math is based on these two features: SQL modes that control how strict the server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a statement produces different errors on the source and the replica, the replication SQL thread ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If you can identify why the event took place and there are no security considerations, proceed to fix the error as described below. If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
If you are a support customer, you can use the MySQL Customer Support Center (https://www.mysql.com/support/) to alert the MySQL team about the problem and have it fixed as soon as possible. For information about steps to take when encountering ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Some attributes are fixed at creation time; others can be modified any time thereafter. MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
The default behaviour is to abort the upgrade, so that the user can fix the issue using the older version of the server, before upgrading to the newer one. --defaults-group-suffix=str Read not only the usual option groups, but also groups with the ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Handler_read_rnd The number of requests to read a row based on a fixed position. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
If given, it must be specified as a /ns suffix immediately following the address. An address with no /ns suffix uses the host system global namespace. An address with a /ns suffix uses the namespace named ns. If given, it must be specified as a /ns ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY table. You can also get this list using the mysqlshow --status db_name ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. MySQL stores VARCHAR values as a 1-byte or 2-byte length prefix plus data.