Search Results
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/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/9.7/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/relnotes/mysql-shell/9.7/en/news-9-3-0.html
(Bug #37629756) It is now possible to define the Oracle Cloud Infrastructure Object Storage connection details using the oci-cli environment variables. OCI_CLI_CONFIG_FILE OCI_CLI_PROFILE OCI_CLI_AUTH Using API Key-based authentication: OCI_CLI_USER ...Segmentation fault (core dumped) As of this release, all Routing Guidelines affected are reassigned to the target Cluster instead of the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-page-compression.html
Hole Punch Size on Linux On Linux systems, the file system block size is the unit size used for hole punching. Therefore, page compression only works if page data can be compressed to a size that is less than or equal to the InnoDB page size minus ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/9.7/en/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the ...If ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-mgm.html
The management client accesses the management server using a C API. To start the management client, it is necessary to supply the host name and port number of the management server: $> ndb_mgm [host_name [port_num]] For example: $> ndb_mgm ... The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads-monitor-main.html
As for any other client connection, the timeouts for this depend on the values of net_write_timeout and net_retry_count; for more information about these, see Section 7.1.8, “Server System Variables”. On the source server, the output from SHOW ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/9.7/en/validate-password-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). INSTALL COMPONENT loads the component, and also registers it in the mysql.component system ...Note If you install MySQL 9.7 using the MySQL Yum repository, MySQL SLES Repository, or RPM packages provided by Oracle, the validate_password component is enabled by default after you start your MySQL Server for the first ...