https://dev.mysql.com/binary-log-transaction-compression.html
However, the effort required for data compression also increases, taking time and CPU and memory resources on the originating server. When decompression is required, it is carried out for one event from the payload at a time. From MySQL 8.0.20, you ...
https://dev.mysql.com/bnl-bka-optimization.html
Incremental buffers also provide a savings in processing time due to the reduction in copying time. In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA ...
https://dev.mysql.com/c-api-building-clients.html
For the MySQL C client library from a Commercial distribution of MySQL: If linking to the static C client library, link statically to the C runtime (use the /MT compiler option). If linking to the dynamic C client library, link either statically or ... This section provides guidelines for compiling C programs that use the MySQL C ...
https://dev.mysql.com/c-api-implementations.html
Client programs refer to C API header files at compile time and link to a C API library file, libmysqlclient, at link time. You must use the debug libraries when compiling clients built using the debug C runtime. The MySQL C API is a C-based API ...
https://dev.mysql.com/c-api-optional-metadata.html
They are equivalent, so either one suffices: At connect time, enable the CLIENT_OPTIONAL_RESULTSET_METADATA flag for the client_flag argument of mysql_real_connect(). When a client executes a statement that produces a result set, MySQL by default ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/c-api-server-client-versions.html
The string and numeric forms of the MySQL server version are available at compile time as the values of the MYSQL_SERVER_VERSION and MYSQL_VERSION_ID macros, and at runtime as the values of the mysql_get_server_info() and mysql_get_server_version() ...
https://dev.mysql.com/change-replication-filter.html
If the same filtering rule is specified multiple times, only the last such rule is actually used. Unlike the case with the server options, this statement does not require restarting the server to take effect, only that the slave SQL thread be ...
https://dev.mysql.com/checksum-table.html
For large tables, this could take a long time, thus you would only perform this operation occasionally. For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/client-connections.html
To enable N inactive connection threads to be cached, set thread_cache_size to N at server startup or at runtime. To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at ...
