Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/show-variables.html
System variable information is also available from these sources: Performance Schema tables. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-column.html
String getTableLabel(): Retrieves the alias for the table in which the column occurs. getTableName(): Gets the name of the table in which the column occurs. The Column object represents the column metadata in a result set. Column has the methods ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server-troubleshooting.html
If you are going to use storage engines that support transactional tables (InnoDB, NDB), be sure that you have them configured the way you want before starting the server. If you are using InnoDB tables, see Section 17.8, “InnoDB Configuration” ... This section provides troubleshooting suggestions for problems starting the ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server.html
If the server is unable to access the data directory it starts or read the grant tables in the mysql schema, it writes a message to its error log. Such problems can occur if you neglected to create the grant tables by initializing the data directory ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/9.7/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/9.7/en/sys-extract-schema-from-file-name.html
For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table option. Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-statement.html
This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Configuration Options format_statement() operation can be modified using the following configuration options ... Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. full_scans The total number of full table scans by statements for the host.