Search Results
https://dev.mysql.com/doc/refman/8.4/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) and ...The private ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
MySQL supports many different storage engines (table types) and row formats. MySQL has many specialized types that save disk space and memory. If it is very likely that a long string column has a unique prefix on the first number of characters, it ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation. This includes all files with the extensions shown in the following list: .BAK .DAT .HSH .MRG .MYD ... DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
For example: mysql> DROP SPATIAL REFERENCE SYSTEM 4326; ERROR 3716 (SR005): Can't modify SRID 4326. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by ...
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system level. If you created any ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.4/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...