Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-runtimes-in-95th-percentile.html
err_count The total number of errors produced by occurrences of the statement. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
If you encounter a full-table error, there are several reasons why it might have occurred: The disk might be full. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace.html
The data for each action, a span, includes possible error information and timing data. Tracing telemetry enables you to visualize the flow of any processing action as it is processed through your server. Traces are generated for COM_QUERY commands ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-installation.html
If the plugin fails to initialize, check the server error log for diagnostic messages. This section describes how to install MySQL Enterprise Thread Pool. For general information about installing plugins, see Section 7.6.1, “Installing and ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
For more restrictive treatment of invalid TIME values, enable strict SQL mode to cause errors to occur. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
Note The following examples use DEFAULT 0, a default that can produce warnings or errors depending on whether strict SQL mode or the NO_ZERO_DATE SQL mode is enabled. TIMESTAMP and DATETIME columns can be automatically initialized and updated to ...
https://dev.mysql.com/doc/refman/8.4/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. The permitted number of connections is controlled by the max_connections system variable. The ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
If the tablespace was created with an earlier version and resides in an unknown directory, InnoDB creates the new tablespace in the default location and writes the following warning to the error log: The DATA DIRECTORY location must be in a known ...