Search Results
https://dev.mysql.com/doc/refman/8.4/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
Example: mysql> CREATE TABLE t1 ( i1 INT CHECK (i1 <> 0), -- column constraint i2 INT, CHECK (i2 > i1), -- table constraint CHECK (i2 <> 0) NOT ENFORCED -- table constraint, not enforced ); mysql> SHOW CREATE TABLE t1\G *************************** 1. For example, when changing the storage engine from InnoDB to MyISAM, options specific to InnoDB, such as ROW_FORMAT=COMPACT, are retained, as shown here: mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB; mysql> ALTER TABLE t1 ENGINE=MyISAM; mysql> SHOW CREATE TABLE t1\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
If you compile MySQL from a source distribution, CMake configures the distribution to use the installed OpenSSL library by default. If the installed OpenSSL version is older than 1.0.1, CMake produces an error at MySQL configuration time. The ... An ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The DEFINER Attribute A stored object definition can include a DEFINER attribute that names a MySQL account. To obtain information ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
In older versions of MySQL, the monitoring tables were INFORMATION_SCHEMA tables (see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”). The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL.
https://dev.mysql.com/doc/refman/8.4/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 ...