Search Results
https://dev.mysql.com/doc/internals/en/open.html
Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open method. Parameters name mode test_if_locked Return Values There are no return values. Usage This example is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Blocking Lock Mode The mode of the lock that is blocking the waiting lock. InnoDB Row Lock Waits Displays the InnoDB locks transactions are waiting for. Table 3.2 InnoDB Row Lock Waits Dashboard Name Description Waiting Lock ID The ID of the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-auditlog-activity-category.html
Event Max Drop Size The size of the largest dropped event in performance logging mode. Events Lost (Delta) The number of events lost in performance logging mode because an event was larger than the available audit log buffer space. This value may be ... Lists the Audit Log Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-innodbrowlockwaiters-category.html
Lists the Sys Schema InnoDB Row Lock Waits metrics and provides a brief description of each.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/sm-text-installer.html
Note There is no text-mode installation available for Microsoft Windows platforms. To start the text-based installer, do the following: Run the installer with the following option: --mode text The following example shows how to start the text-mode ... The steps and options of the text-based installation are identical to those described in Section 5.2, “MySQL Enterprise Service Manager Graphical Installation ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations.html
It is not an exhaustive list with respect to data types, functions, operators, and SQL modes. For data types, functions, operators, and SQL modes that are supported by MySQL HeatWave, see Section 4.2.1, “Supported Data Types for MySQL HeatWave”, ... This section lists functionality that is not supported by MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of nonspace characters, you can cause an error to ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
Several SQL mode options are available to provide greater control over handling of bad data values and whether to continue statement execution or abort when errors occur. The SQL mode can be set globally at server startup to affect all clients.
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
mysql> CREATE TABLE ch (ucs2 CHAR(3) CHARACTER SET ucs2, gb2312 CHAR(3) CHARACTER SET gb2312); In nonstrict SQL mode, try to place the rare character 汌 in both columns. mysql> SET sql_mode = ''; mysql> INSERT INTO ch VALUES ('A汌B','A汌B'); ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
For example, the following two queries are equivalent: SELECT * FROM t1 USE INDEX (i1) IGNORE INDEX (i2) USE INDEX (i2); SELECT * FROM t1 USE INDEX (i1); For FULLTEXT searches, index hints work as follows: For natural language mode searches, index ... Index hints give the optimizer information about how to choose indexes during query ...