MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 63 total results

8.5.3.4 MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions

https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html

The number passes the Luhn check (an algorithm that performs a checksum verification against a check digit). Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string ...

28.3.15 The INFORMATION_SCHEMA FILES Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html

The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...

10.2.3 Optimizing INFORMATION_SCHEMA Queries

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 ...

10.5.8 Optimizing InnoDB Disk I/O

https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html

Review settings for the following configuration options when using non-rotational storage: innodb_checksum_algorithm The crc32 option uses a faster checksum algorithm and is recommended for fast storage systems. If you follow best practices for ...

17.9.1.5 How Compression Works for InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html

Other than the data, compressed overflow pages contain an uncompressed header and trailer comprising a page checksum and a link to the next overflow page, among other things. This section describes some internal implementation details about ...

17.10 InnoDB Row Formats

https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html

The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...

Chapter 2 Installing MySQL

https://dev.mysql.com/doc/refman/8.0/en/installing.html

To verify the integrity of the distribution, use the instructions in Section 2.1.4, “Verifying Package Integrity Using MD5 Checksums or GnuPG”. A summary of the procedure follows and later sections provide the details. If you plan to upgrade an ...

25.4.2.5 NDB Cluster mysqld Option and Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html

The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB Cluster. For a reference to all command-line options, system variables, and status ...

25.6.16.58 The ndbinfo table_info Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-info.html

The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.

2.4.3 Installing and Using the MySQL Launch Daemon

https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html

The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. To enable the launchd service, you can either: ...

Displaying 51 to 60 of 63 total results