Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
To do so, specify the autoextend attribute for the last data file in the innodb_data_file_path setting, and restart the server. InnoDB creates and initializes the new data file when you start the server. When using a raw disk partition, ensure that ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
The source and destination must differ, and the migration server must support both. --keyring-migration-host=host_name Command-Line Format --keyring-migration-host=host_name Type String Default Value localhost The host location of the running server ... MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Type String The destination keyring plugin or component for key ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ... # at 302 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. Normalization permits statements that are similar to be grouped and summarized to expose information about the types of statements the server is executing and how often they ...The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Thereafter, a new row is added each time the server creates a thread. NAME The name associated with the thread instrumentation code in the server. For example, thread/sql/one_connection ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. The server writes less information to the slow query log if you use the --log-short-format option. (Even with that variable ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. To determine which storage ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables used with MySQL Server. For example, X Plugin can have SSL key, certificate, and ... This section explains how to configure X Plugin to use encrypted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
You want the backup to complete quickly, with as little CPU overhead on the database server as possible. Comparing to the other backup types, it causes the least disruption to the database server, and it is a desirable backup option when you want to ... When it comes to formulating your backup strategy, performance and storage space are the key ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-13.html
It is suitable for use with MySQL Server versions 8.0, 5.7, 5.6, and 5.5. See Connecting to a Single MySQL Server Using Connection Pooling in the X DevAPI User Guide for details. (WL #11857) X DevAPI: A new connection property, ... Version 8.0.13 is ...