MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1181 to 1190 of 1675 total results

https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html

For source/replica replication connections, the configured compression algorithms and compression level are available from multiple sources: The Performance Schema replication_connection_configuration table has COMPRESSION_ALGORITHMS and ...

8.4.2 Connection Control Plugins

https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS implements an INFORMATION_SCHEMA table that exposes more detailed monitoring information for failed connection attempts. For more information about this table, see Section 28.6.2, “The INFORMATION_SCHEMA ...

1.6.3 How MySQL Deals with Constraints

https://dev.mysql.com/doc/refman/8.0/en/constraints.html

MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot ...Because of this, constraint handling is a bit different in MySQL than in other ...

5.3.4.8 Counting Rows

https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html

Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...

15.1.16 CREATE LOGFILE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html

For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. You can verify that the UNDO files were created and obtain information about them by querying the Information ...

11.1.3 Date and Time Literals

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html

This section describes the acceptable formats for date and time literals. The following alternative formats are also understood: ss, mmss, or hhmmss. Beginning with MySQL 8.0.19, you can specify a time zone offset when inserting TIMESTAMP and ...

7.9.1 Debugging a MySQL Server

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

This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables are getting slower and slower you should try to optimize the table with OPTIMIZE TABLE or myisamchk. If you are ...

15.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html

It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...

1.6.2 MySQL Differences from Standard SQL

https://dev.mysql.com/doc/refman/8.0/en/differences-from-ansi.html

For example, in MySQL, privileges for a table are not automatically revoked when you delete a table. You must explicitly issue a REVOKE statement to revoke privileges for a table. We try to make MySQL Server follow the ANSI SQL standard and the ...

10.2.1.18 DISTINCT Optimization

https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html

DISTINCT combined with ORDER BY needs a temporary table in many cases. If you do not use columns from all tables named in a query, MySQL stops scanning any unused tables as soon as it finds the first match. Because DISTINCT may use GROUP BY, learn ...

Displaying 1181 to 1190 of 1675 total results