PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Innodb_row_lock_time_max The maximum time to acquire a row lock for InnoDB tables, in milliseconds. Max_execution_time_exceeded The number of SELECT statements for which the execution timeout was exceeded. Com_xxx The Com_xxx statement counter ...| ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
PROCESSLIST_TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. row ... The ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For example, a CHAR(255) column can exceed 768 bytes if the ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. The ...SHOW WARNINGS displays information about the conditions resulting from execution of the most recent nondiagnostic statement in the current ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
There are two ways to execute a GROUP BY query through index access, as detailed in the following sections. The second method first performs a range scan, and then groups the resulting tuples. The most general way to satisfy a GROUP BY clause is to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
If a lock request conflicts with an existing lock and cannot be granted because it would cause deadlock, an error occurs. It allows you to choose how to trade off between predictable sequences of auto-increment values and maximum concurrency for ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
(The files need not have been generated automatically; what matters is that they have those names and are valid.) If the server does not find valid certificate and key files in the data directory, it continues executing but without support for ...
https://dev.mysql.com/doc/refman/5.7/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. The following examples show other common error messages you might encounter when installing MySQL and starting the ...This section helps you diagnose and correct some of these ...The default data directory location is C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... A schema mismatch ...