Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
In addition—due to rounding, the nature of threaded applications, and the fact that a nonzero length of time is required to create events and to signal their execution—events may be delayed by as much as 1 or 2 seconds. However, the time shown ...If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
When the replication SQL thread executes an event read from the source, it modifies its own time to the event timestamp. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds ...Must ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
These roles must exist at the time CREATE USER is executed; otherwise the statement raises an error (ER_USER_DOES_NOT_EXIST), and the user is not created. CREATE USER fails with an error if any account to be created is named as the DEFINER attribute ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. Setting the TIMED column affects Performance Schema table contents as described in Section 29.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
The MySQL Server may be closing idle connections that exceed the wait_timeout or interactive_timeout threshold. Ensure that any configurable firewall or router timeout settings allow for the maximum expected connection idle time. Questions 3.14.1: ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
The MySQL Server may be closing idle connections that exceed the wait_timeout or interactive_timeout threshold. Ensure that any configurable firewall or router timeout settings allow for the maximum expected connection idle time. Questions 16.1: ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37436220) Queries having a correlated subquery which performed aggregation were sometimes (incorrectly) rejected with duplicate key errors during execution. (Bug #37478594) InnoDB: Creating a secondary index on a VARCHAR column could allocate ...(Bug #37481548) Microsoft Windows: When upgrading a MySQL Server using MySQL Configurator, the process hung in the "Starting the server and upgrading system tables" step if a custom error log name was ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-debug-highload-diagnostics.html
Number of seconds between iterations of high load diagnostic data collection. About the Utility Requirements and Restrictions Running the Utility Options for Collecting High Load Diagnostics About the Utility util.debug.collectHighLoadDiagnostics() ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new EventHandler(script_ScriptCompleted); script.StatementExecuted += new MySqlStatementExecutedEventHandler(script_StatementExecuted); In VisualStudio, you ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new EventHandler(script_ScriptCompleted); script.StatementExecuted += new MySqlStatementExecutedEventHandler(script_StatementExecuted); In VisualStudio, you ...