Search Results
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. Your first resource when troubleshooting server ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log file. Authentication Notes Improved log messages to provide clear reasons for Access denied errors when ...It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
Attempting to do either of these things causes an error, as shown here: mcm> set DataDir=/var/cluster-data mycluster; ERROR 3 (00MGR): Illegal syntax mcm> set DataDir:ndb_mgmd,ndbd,mysqld=/var/cluster-data mycluster; ERROR 3 (00MGR): Illegal syntax ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
An error occurs if a transaction is already active, or if the kernel metadata is locked. In the event of an error, the transaction is immediately aborted. Return value Returns 0 on success; on failure, returns -1 and sets an error. As with many ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld. InnoDB Strict Mode Is Off Description To guard against ignored typos and syntax errors in SQL, or other ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
Alternatively, run the following statement: mysql> ALTER TABLE tbl_name SECONDARY_LOAD; The following error is reported if the table is already loaded: mysql> ERROR 13331 (HY000): Table is already loaded. Problem: You have encountered an ...Solution ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). If an ON UPDATE CASCADE or ON DELETE CASCADE subclause is only defined for one FOREIGN KEY clause, cascading operations fail with an ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. If that is not the case, a GET STACKED DIAGNOSTICS when handler not active error occurs. Condition area list: ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...