PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
After any port is closed, it remains in a TIME_WAIT status for 120 seconds. On the Edit menu, click Add Value, and then add the following registry value: Value Name: TcpTimedWaitDelay Data Type: REG_DWORD Value: 30 This sets the number of seconds to ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If the optional M value is given, it specifies the fractional seconds precision. If the optional M value is given, it specifies the fractional seconds precision. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
This is true even for the second string; the _latin1 introducer does not affect escape processing. Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-concurrent-ddl.html
The clone_ddl_timeout variable defines the time in seconds on the donor and recipient that a cloning operation waits for a backup lock. Prior to MySQL 8.0.27, DDL operations on the donor and recipient MySQL Server instances, including TRUNCATE ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
It takes more than connect_timeout seconds to obtain a connect packet. The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. If connection problems occur such as communication ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. gen_blocklist(str, dictionary_name, replacement_dictionary_name) ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The argument is the delay, in tenths of seconds, subject to machine capabilities. The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package ...