Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
The allocation algorithm reserves memory in large amounts to reduce the number of allocation operations. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
The difference in statistics, which is not expected to affect workload performance, is due to the different algorithm used to populate the index. InnoDB performs a bulk load instead of inserting one index record at a time when creating or ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
-DWITH_ZSTD=zstd_type Connection compression using the zstd algorithm (see Section 6.2.8, “Connection Compression Control”) requires that the server be built with zstd library support. The CMake program provides a great deal of control over how ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
The string might be shorter than max_length characters because the algorithm that creates the geohash value continues until it has created a string that is either an exact representation of the location or max_length characters, whichever comes ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
For details about internal representation of temporal values, see MySQL Internals: Important Algorithms and Structures. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
DDL operations that rebuild the table and are not performed online using the ALGORITHM=INPLACE technique create a temporary copy of the original table in the same directory as the original table. On Unix, MySQL uses the value of the TMPDIR ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
Passwords stored in the user table are encrypted using plugin-specific algorithms. MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for mysqlbackup. Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
PROCESS, to process DDL statements with the ALGORITHM = INPLACE clause. The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. You can either create a new user with a limited set ...