Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This might include: allocate environment handle, set ODBC version, allocate connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-overview.html
Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This might include: allocate environment handle, set ODBC version, allocate connection ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-environment-category.html
Table 7.10 Environment Configuration Metrics NameDescriptionBasedir The MySQL installation base directory. Core File Enabled Whether to write a core file if the server crashes. Hostname The server sets this variable to the server host name at ...
https://dev.mysql.com/doc/connector-j/en/connector-j-source-replica-replication-connection.html
If you have a write transaction, or if you have a read that is time-sensitive (remember, replication in MySQL is asynchronous), set the connection to be not read-only, by calling Connection.setReadOnly(false) and the driver will ensure that further ...The Connection tests for available source hosts when Connection.setReadOnly(false) is called, throwing an SQLException if it cannot establish a connection to a source, or switching to a source connection if the host is ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica server host and nnnnnn is a sequence number. Relay log files have the same format as binary log ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
When the source is using the row-based binary logging format, you should execute STOP REPLICA or STOP REPLICA SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #116164, Bug #37080195) Component Notes INSTALL COMPONENT issued concurrently with a SET PERSIST which used a subquery could sometimes lead to an unplanned exit of the server. (Bug #36452528) InnoDB: Concurrently truncating a table while ...We ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-networking-category.html
Named Pipe Enabled On Windows only, indicates whether the server supports connections over named pipes. Shared Memory Enabled On Windows only, indicates whether the server the server permits shared-memory connections. Table 7.24 Networking ... Lists ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
Large page support in the MySQL server is disabled by default. You can also do so by adding the following line to the [mysqld] section of the server my.cnf file: large-pages=ON With this option enabled, InnoDB uses large pages automatically for its ...In MySQL, large pages can be used by InnoDB, to allocate memory for its buffer pool and additional memory ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html
The Performance Schema autosizes the history tables, or the sizes can be configured explicitly at server startup using table-specific system variables, as indicated in the sections that describe the individual history tables. The tables have names ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...