Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. Inserts into numeric columns are affected by the SQL mode, which is controlled by ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The MySQL server reads the contents of the grant tables into memory when it starts, and reloads them under the circumstances indicated in Section 8.2.13, “When Privilege Changes Take Effect”. INSERT Enables rows to be inserted into tables in a ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
When inserting a value from a BIT(M) column into a BIT(M') column, where M' > M, the most significant bits of the BIT(M') columns are cleared (set to zero) and the M bits of the BIT(M) value are set as the least significant bits of the BIT(M') ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
If the local value is set, the new value affects AUTO_INCREMENT columns for all tables into which new rows are inserted by the current user for the duration of the session, unless the values are changed during that session. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-troubleshooting.html
Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...grep ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total (Bug #59550) Innodb_buffer_pool_read_ahead The number of pages read into the InnoDB buffer pool by the read-ahead ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
(To change sessions in a load-balanced environment, it is necessary to detect whether there is session state to take into consideration when deciding whether a switch can be made.) The tracker mechanism permits applications to know when transactions ...A client can enable these trackers to receive notification of changes to its session ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
However, subsequent apply-log operations on the backups will take more time to complete, as the unused pages are inserted back into the tables during the operations. Accepted formats for specifying the option include: now: This includes all tables ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...