Search Results
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. For information about ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The ...It effectively is a subset of the cluster_operations table, in which operations for other SQL and API nodes are not ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
--keyring-migration-password[=password] Command-Line Format --keyring-migration-password[=password] Type String The password of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-transactions.html
The server_transactions table is subset of the cluster_transactions table, but includes only those transactions in which the current SQL node (MySQL Server) is a participant, while including the relevant connection IDs. (Currently, the MySQL Server ...The transaction ID (transid) is a unique 64-bit number which can be obtained using the NDB API's getTransactionId() ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-server-option.html
int mysql_set_server_option(MYSQL *mysql, enum enum_mysql_set_option option) Description Enables or disables an option for the connection. Option Description MYSQL_OPTION_MULTI_STATEMENTS_ON Enable multiple-statement support ...Enabling ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. This variable determines how large of a packet (that is, a single row) can be sent to the MySQL server. The max_allowed_packet option can be modified using the MySQL Workbench ...By default, the server only accepts a maximum size of 1MB from the client ...For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. This variable determines how large of a packet (that is, a single row) can be sent to the MySQL server. The max_allowed_packet option can be modified using the MySQL Workbench ...By default, the server only accepts a maximum size of 1MB from the client ...For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After ...
https://dev.mysql.com/doc/mysql-installer/en/server-advanced-options.html
The advanced-configuration options include: Server ID Set the unique identifier used in a replication topology. Table Names Case You can set the following options during the initial and subsequent configuration the server. For the MySQL 8.0 release ...If binary logging is enabled, you must specify a server ... This step is available if the Show Advanced ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-customize-name-ref.html
Figure 15.2 Customize MySQL Server Name Table 15.2 Customize Name Description Show MySQL Server Names as: Defines how hostnames are displayed. The following display settings are possible: Reported by Agent (default): the MySQL server names are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-compared.html
MySQL Server offers a number of choices in storage engines. Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. While NDB and InnoDB share common ...They see ...In many instances, decisions about when and where to use NDB Cluster must be made on a case-by-case basis, taking all factors into ...