PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does not exist. For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table ... The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you evaluate the performance and usefulness of compression for specific ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
For example, you might allow get and set operations to query or update a table and the memcached memory cache at the same time (using the caching setting), while making delete, flush, or both operate only on the in-memory copy (using the cache_only ...When a memcached operation inserts, updates, or deletes data in the underlying InnoDB table, the change might be committed to the InnoDB table instantly (if daemon_memcached_w_batch_size=1) or some time later (if the daemon_memcached_w_batch_size value is greater than ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-file.html
config.ini: This file, sometimes known as the global configuration file, is read only by the NDB Cluster management server, which then distributes the information contained therein to all processes participating in the cluster. This includes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. Or wait for a day, or whatever time period you consider safe for your deployment. A safer method in the sense that it does ...This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. Then, whenever you need age, you can calculate it as the difference between the current date and the birth date. Use a CREATE TABLE statement to specify the layout of ...This can be called the pet table, and it should contain, as a bare minimum, each animal's ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
When a given index value yields a large number of rows, the index is less useful and MySQL is less likely to use it. The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
When you use a randomly generated value as a primary key in an InnoDB table, prefix it with an ascending value such as the current date and time if possible. For character and string columns, follow these guidelines: Use binary collation order for ...You can use the BINARY operator to use binary collation within a particular ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...Fortunately, this is the default behavior for a new MySQL ...