MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 50 of 948 total results

B.3.2.16 File Not Found and Similar Errors

https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html

If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. You can either ...

2.8.7 MySQL Source-Configuration Options

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html

If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options: DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE DISABLE_PSI_IDLE DISABLE_PSI_MEMORY ... The CMake ...

12.14.1 Collation Implementation Types

https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html

MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Collations for ...It is ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

row *************************** Level: Note Code: 4569 Message: filter configuration accepted: SET @@GLOBAL.dragnet.log_error_filter_rules= 'IF prio!=ERROR THEN unset prio.'; The value displayed by SHOW WARNINGS indicates the “decompiled” ...If ... The MySQL server maintains many system variables that affect its ...

29.12.21.2 The error_log Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html

row *************************** LOGGED: 2020-08-06 09:25:00.338624 THREAD_ID: 0 PRIO: System ERROR_CODE: MY-010116 SUBSYSTEM: Server DATA: mysqld (mysqld 8.0.23) starting as process 96344 *************************** 2. row ... Of the logs the MySQL ...Typically, the server writes diagnostics to a file on the server host or to a system log ...

9.6.3 How to Repair MyISAM Tables

https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html

Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ...This ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...

6.4.1 comp_err — Compile MySQL Error Message File

https://dev.mysql.com/doc/refman/8.0/en/comp-err.html

comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: As of MySQL 8.0.19, ...Invoke comp_err like this: comp_err [options] comp_err supports the following ...

14.8 String Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html

[USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of those integers. mysql> SELECT FORMAT(12332.123456, 4); -> '12,332.1235' mysql> SELECT ...For ...

15.6.7.7 The MySQL Diagnostics Area

https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html

Condition area list: Condition area 1: error code for condition 1 error message for condition 1 ... Condition area 2: error code for condition 2: error message for condition 2 ... Condition area 3: error code for condition 3 error message for ...

15.6.7.3 GET DIAGNOSTICS Statement

https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html

Displaying 41 to 50 of 948 total results