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/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Example Enable a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html
Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. This procedure disables ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "5.7.3-m13", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns ...
https://dev.mysql.com/doc/refman/5.7/en/while.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 Security_type: DEFINER Comment: character_set_client: utf8 collation_connection: ...It returns ...A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 13.7.5.20, “SHOW FUNCTION STATUS ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
For more information on security settings, see Section 17.6, “Group Replication Security”. For example: [mysqld] # server configuration datadir=<full_path_to_data>/data/s1 basedir=<full_path_to_bin>/mysql-8.0/ port=24801 ...It is also possible ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help Support”). The following descriptions indicate the forms that the result set can take. The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
For example, a system view named GEOMETRY_COLUMNS contains a description of geometry columns, one row for each geometry column in the database. The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information ... The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial ...
https://dev.mysql.com/doc/refman/5.7/en/optimization.html
This chapter explains how to optimize MySQL performance and provides examples. Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single ...