Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-4-0-0.html
Important As of this release, 13.2.4.0.0, MySQL 8 is supported. It is not possible to monitor MySQL 8 with earlier versions of Oracle Enterprise Manager for MySQL Database. For more information on the variables added and removed in MySQL 8, see ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-binarylogs-category.html
Binlog Group Commit Sync No Delay Count The maximum number of transactions to wait for before aborting the current delay as specified by binlog-group-commit-sync-delay. Binlog Max Flush Queue Time How long in microseconds to keep reading ... Lists ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-connection-activity-category.html
Max Execution Time Exceeded (Delta) The number of SELECT statements for which the execution timeout was exceeded. Max Execution Time Set (Delta) The number of SELECT statements for which a nonzero execution timeout was set. This includes statements ... Lists the Connection Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Syntax for these options is shown here: COMMENT 'NDB_COLUMN=speclist' speclist := spec[,spec] spec ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
First approach to solving the problem: For each salesperson, calculate the maximum sale size, and also find the customer who provided this maximum. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
--binlog-row-event-max-size=N Command-Line Format --binlog-row-event-max-size=# Type Numeric Default Value 4294967040 Minimum Value 256 Maximum Value 18446744073709547520 Specify the maximum size of a row-based binary log event, in bytes. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
--compatible=name Command-Line Format --compatible=name[,name,...] Type String Default Value '' Valid Values ansimysql323mysql40postgresqloraclemssqldb2maxdbno_key_optionsno_table_optionsno_key_options Produce output that is more compatible with ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
As a development technique to guard against a runaway recursive CTE, you can force termination by placing a limit on execution time: The cte_max_recursion_depth system variable enforces a limit on the number of recursion levels for CTEs. The ... A ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
For example: static int my_foo; static MYSQL_SYSVAR_INT(foo_var, my_foo, PLUGIN_VAR_RQCMDARG, "foo comment", NULL, NULL, 0, 0, INT_MAX, 0); ... MYSQL_THDVAR_INT(name, opt, comment, check, update, default, min, max, blk) MYSQL_SYSVAR_INT(name, ...