Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Loading a page-compressed tablespace on a server that does not support the compression algorithm that was used causes an I/O error. Page-compressed tablespaces can be copied between Linux and Windows servers if the compression algorithm that was ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. As a C language interface, callable as a plugin service from server plugins or loadable functions.
https://dev.mysql.com/doc/refman/8.4/en/linux-installation.html
The required script, mysql.server, can be found in the support-files directory under the MySQL installation directory or in a MySQL source tree. Linux supports a number of different solutions for installing MySQL. You can also use My Oracle Support ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. Since GET_LOCK() establishes a lock only on a single mysqld, it is not suitable for use with NDB Cluster, which has no ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
For example, to enable all memory instruments, add this rule to your configuration file and restart the server: performance-schema-instrument='memory/%=COUNTED' Note Enabling memory instruments at startup ensures that memory allocations that occur ... The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
An uninterruptible power supply (UPS) protecting the electrical power to all computer servers and storage devices that run MySQL servers and store MySQL data. For distributed or hosted data applications, the particular characteristics of the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-added-deprecated-removed.html
Options and Variables Introduced in NDB 8.4 The following system variables, status variables, and server options have been added in NDB 8.4. Ndb_schema_participant_count: Number of MySQL servers participating in NDB schema change distribution.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-first-start.html
This option requires that --initial or --reload also be specified; see Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”, for details. Starting the cluster is not very difficult after it has been configured. Each cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
The output should appear similar to what is shown here: C:\mysql\bin> ndb_mgmd 2010-06-23 07:53:34 [MgmtSrvr] INFO -- NDB Cluster Management Server. Once the NDB Cluster executables and needed configuration files are in place, performing an initial ...