Search Results
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
All the types are defined within the include/mysql_com.h file within the enum_field_types enumerated structure. Example: a VARCHAR(7) column containing 'A' looks like: hexadecimal 01 41 -- (length = A'</code>) In MySQL 4.1 the length is always 1 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/connector-j/en/connector-j-support-bug-report.html
The normal place to report bugs is http://bugs.mysql.com/, which is the address for our bugs database. If you find a sensitive security bug in MySQL Server, please let us know immediately by sending an email message to <secalert_us@oracle.com>.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: wait_free METER: mysql.inno.buffer_pool METRIC_TYPE: ASYNC COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: Number of times waited for free buffer (innodb_buffer_pool_wait_free) ... row *************************** ... The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
qualifier: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; Like SET GLOBAL, SET PERSIST sets the global variable runtime value, but also writes the variable setting to the mysqld-auto.cnf file (replacing any existing ...A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the beginning of the transaction (as a Gtid_log_event). Whenever the binary log is rotated or the server is shut down, the ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To set the relevant variables at server startup, put these lines in the server my.cnf file: [mysqld] plugin-load-add=connection_control.so connection-control-failed-connections-threshold=4 connection-control-min-connection-delay=2000 To set and ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. For guidance regarding buffer pool size configuration, see Section 10.12.3.1, “How MySQL Uses Memory”. Thus, take care to avoid transactions ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can operate in a ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...