PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/select-benchmarking.html
It shows that MySQL can execute 1,000,000 simple addition expressions in 0.32 seconds on that system. To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
The second column is Instruction, which contains an SQL statement (usually changed from the original source), or a directive which has meaning only to the stored-routine handler. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension ...
https://dev.mysql.com/doc/refman/8.0/en/show-tables.html
The optional FULL modifier causes SHOW TABLES to display a second output column with values of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
The second, because it is a SELECT statement is considered nondiagnostic and does clear the message list. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the file. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
For the second syntax, a POINT value is required, where the X and Y coordinates are in the valid ranges for longitude and latitude, respectively. Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...