PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html
In the following example, innodb_buffer_pool_size is set to 8G, and innodb_buffer_pool_instances is set to 16. $> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; ... You ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
Thus, compression applies only to tables (and indexes) stored in file-per-table or general tablespaces. The FILE_BLOCK_SIZE value must be a valid compressed page size in relation to the innodb_page_size value, and the page size of the compressed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...The commands for checking and increasing the open file limit varies by operating ... This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
Benchmarks suggest that queries and DML operations (inserts, updates, and deletes) that use the memcached interface are faster than traditional SQL. Reducing Transactional Overhead A default value of 1 for daemon_memcached_r_batch_size and ...When ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization can handle one IS NULL for any key part. In the following query, MySQL uses key lookups only on the expression (t1.a=t2.a AND t2.a IS NULL) and is not ... MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html
This is the preferred method for installing MySQL on Debian-like systems, as it provides a simple and convenient way to install and update MySQL products. The following are some information on the Debian packages available there and the instructions ... Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-membership.html
The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other information. We determine ...The president node is the node viewed by the current node as responsible for setting an arbitrator (see NDB Cluster Start ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-starting.html
However, the use of batching causes updates to be applied in batches of 32 KB each; this can result in higher throughput and less CPU usage, particularly where individual updates are relatively small. All outstanding updates are applied when the end ...Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 25.7.2, “General Requirements for NDB Cluster Replication”): shellS> mysqld --ndbcluster --server-id=id \ --log-bin --ndb-log-bin & This starts the server's mysqld process with binary logging enabled using the proper logging ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-implementation.html
For NDB Transparent Data Encryption (TDE), data nodes encrypt user data at rest, with security provided by a password (file system password), which is used to encrypt and decrypt a secrets file on each data node. NDB TDE encrypts user data files ...