Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
If you access a table mostly by searching on a combination of columns, create a single composite index on them rather than a separate index for each column. Design your tables to minimize their space on the disk. This can result in huge ...
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
ICU_VERSION() The version of the International Components for Unicode (ICU) library used to support regular expression operations (see Section 14.8.2, “Regular Expressions”). It may be used to time how quickly MySQL processes the expression. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
A UNIQUE index may display as MUL if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. The related ST_GEOMETRY_COLUMNS table provides ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgm.html
The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and performing other administrative functions. The management client ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
The combination of --base64-output=DECODE-ROWS and --verbose provides a convenient way to see row events only as SQL statements: $> mysqlbinlog -v --base64-output=DECODE-ROWS log_file ... The following examples illustrate how mysqlbinlog displays ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Some signal values cause statement termination; see Effect of Signals on Handlers, Cursors, and Statements. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...