Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/restore.partial.html
Here are some general requirements for performing a TLR or partial restore: The destination server must be running. The required parameters for connecting to the server (port number, socket name, etc.) are provided as command-line options for ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-encrypted-connections.html
By default, MySQL programs attempt to connect using encryption if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted connection cannot be established (see Configuring MySQL to Use Encrypted ... This ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-real-connect-dns-srv.html
mysql_real_connect_dns_srv() is similar to mysql_real_connect(), except that the argument list does not specify the particular host of the MySQL server to connect to. Instead, it names a DNS SRV record that specifies a group of servers. For ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). To review the ... Copying a MySQL Configuration 19.2 Copying a MySQL Configuration While it is not possible to change the values of any variables once a configuration has been created, you can create a custom configuration by copying and modifying an existing ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...For details, see the description of innodb_read_only in Section 17.14, “InnoDB Startup Options and System Variables” Previously, tables in the mysql system database were visible to DML and DDL ...Table creation and ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description accounts Connection statistics per client account ...
https://dev.mysql.com/doc/refman/9.7/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Using Partial Revokes The partial_revokes system variable controls whether privilege restrictions can be placed on accounts. The server ...For ...Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while leaving the privileges in place for other ...
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 ...