Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-optional-metadata.html
When a client executes a statement that produces a result set, MySQL makes available the data the result set contains, and by default also result set metadata that provides information about the result set data. Suppression of metadata transfer by ...Metadata is contained in the MYSQL_FIELD structure (see Section 5.2, “C API Basic Data Structures”), which is returned by the mysql_fetch_field(), mysql_fetch_field_direct(), and mysql_fetch_fields() ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualinterdev.html
If you have a BIGINT in your result, you may get the error [Microsoft][ODBC Driver Manager] Driver does not support this parameter. Try selecting the Change BIGINT columns to INT option in the Connector/ODBC connect screen.
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-handles.html
This section provides information about MGM API functions used to create and destroy management server handles (see NdbMgmHandle). ndb_mgm_create_handle() ndb_mgm_set_name() ndb_mgm_set_ignore_sigpipe() ndb_mgm_destroy_handle() ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
If you are using replication, you should specify an expiration period that is no lower than the maximum amount of time your replicas might lag behind the source. PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of ...The log consists of a set of binary log files, plus an index file (see Section 7.4.4, “The Binary ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-threads-activity-category.html
Slow Launch Threads (Delta) The number of threads that have taken more than slow_launch_time seconds to create. Connection Limit Usage (Rate) Once the maximum connection limit for the MySQL server has been reached, no other user connections can be ...It implements a thread pool that increases server performance by efficiently managing statement execution threads for large numbers of client ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
In MySQL, it can produce nondeterministic results because f() might be executed a different number of times for different executions of a given query depending on how the optimizer chooses to handle it. FROM t...) AS dt ...); Here the result from ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-27.html
(Bug #31117686) Synchronization in the MultiHostConnectionProxy#invoke() method forced connection pools to wait for statements to finish executing before new or free connections could be provided, creating performance issues in some cases. (WL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #38044940) A java.sql.Time instance created from a negative millisecond value, when inserted into a database via using a PreparedStatement, lost its fractional part of the seconds. (Bug #77658, Bug #21946136) Connection.setNetworkTimeout() has ...(Bug #37785888) The method getObject(String , Class<T>) returned a java.lang.AbstractMethodError for a pooled ...