Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Writes to the tablespace that occur after setting the new compression algorithm use the new setting, but to apply the new compression algorithm to existing pages, you must rebuild the table using OPTIMIZE TABLE. To uncompress existing pages, you ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
| +--------------------------------------+ 1 row in set (0.03 sec) If the plugin is not able to connect to HashiCorp Vault during initialization or reconfiguration and there was no existing connection, the _commit_ system variables are set to 'Not ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
You can do this through the Directory Utility, and the mysql user should already exist. For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. You should keep the ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). This is the Reference Manual for ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The tables themselves continue to exist because their definitions are stored in the MySQL data dictionary, but they are empty when the server restarts. A server restart also sets the maximum size of existing MEMORY tables to the global ... The ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Assume that an existing 8.3 server is configured for the default TCP/IP port number (3306) and Unix socket file (/tmp/mysql.sock). -DMYSQL_TCP_PORT=port_number \ -DMYSQL_UNIX_ADDR=file_name \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-8.4.6 Here, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-send-buffers.html
To be backward-compatible with existing configurations, this parameter takes as its default value the sum of the maximum send buffer sizes of all configured transporters, plus an additional 32KB (one page) per transporter. The NDB kernel employs a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Note When using tot_key_writes, you should keep in mind that a write operation in this context updates the row if the key exists, and inserts a new row otherwise. In addition, a client may choose to end a scan before all potentially matching rows ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...