Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. The -s option (short for --silent) causes ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-index-columns.html
This table provides information about indexes on NDB tables. The columns of the index_columns table are listed here, along with brief descriptions: table_id Unique ID of the NDB table for which the index is defined Name of the database containing ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do ...