PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.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 database, it writes a message to its error log. This section describes how start the server on Unix and Unix-like systems. (For Windows, see ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Reparsing uses the default database and SQL mode that were in effect for the original conversion to internal form. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. The MySQL grant system takes stored routines into account as ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
db The default database for the thread, or NULL if there is none. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
db The default database for the statement, or NULL if there is none. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-full-table-scans.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-runtimes-in-95th-percentile.html
db The default database for the statement, or NULL if there is none. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have ...