Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The innodb_file_per_table variable is not applicable to general tablespaces, nor is it applicable when using the TABLESPACE [=] innodb_system table option to store DYNAMIC tables in the system tablespace. Variable-length columns are an exception to ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Prepared statements transmit data between the client and server using C language variables on the client side that correspond to SQL values on the server side. If there is a mismatch between the C variable type on the client side and the ...MySQL ...The two codes together tell MySQL what conversion must be performed, if ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
Reinitializes session system variables to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as SET NAMES. The MySQL client library can perform an automatic reconnection to ...The related MYSQL_OPT_RECONNECT option is still available but now returns a deprecation warning to the standard error output if your application calls the mysql_get_option() or mysql_options() function with the option, even when setting it to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
The innodb_status_output and innodb_status_output_locks system variables are used to enable the standard InnoDB Monitor and InnoDB Lock Monitor. Enabling the Standard InnoDB Monitor Enable the standard InnoDB Monitor by setting the ... When InnoDB ...InnoDB sends the monitor output to stderr rather than to stdout or fixed-size memory buffers to avoid potential buffer ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
For busy systems capable of higher I/O rates, you can set a higher value to help the server handle the background maintenance work associated with a high rate of row changes. You can set the innodb_io_capacity value in the MySQL option file (my.cnf ...InnoDB attempts to perform these tasks in a way that does not adversely affect the normal working of the ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
Remove the option or system variable setting after the procedure is complete, so that it is not forgotten in the event of an unexpected server restart. IO_THREAD starts the replication receiver thread, which reads events from the source server and ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. Consequently, the server does not send OK packets that represent EOF. New servers recognize the absence of the flag to mean they should not.) New ...As ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
Note blob read batching can also be controlled in the mysql client and other MySQL client application using the MySQL Server's --ndb-blob-read-batch-bytes option and its associated MySQL Server system variables. Note Blob write batching can also be ...You should be aware that, when ndb_replica_blob_write_batch_bytesis not set,the effective blob batch size (that is, the maximum number of pending bytes to write for blob columns) is determined by the maximum of the default value of ndb_replica_blob_write_batch_bytes and the value set for the --ndb-blob-write-batch-bytes MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Semisynchronous replication source servers can also get performance benefits from enabling these system variables, because they use the same locking mechanisms as the replicas. As an alternative, you can configure the source so that the source waits ...Failover from source to replica in this case might result in failover to a server that is missing transactions relative to the ... In addition to ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-elements.html
A system variable enables clients to specify the list of version tokens that register the required server state. Version Tokens is based on a plugin library that implements these elements: A server-side plugin named version_tokens holds the list of ...Otherwise, the plugin returns an error to the client and the statement ...