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/performance-schema-prepared-statements-instances-table.html
To control the size of this table, set the performance_schema_max_prepared_statements_instances system variable at server startup. If the statement is successfully instrumented, a new row is added to the prepared_statements_instances table. Prepared ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
row *************************** GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57'): 1 1 row in set (0.00 sec) mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23-25', -> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The OBJECT_TYPE column indicates the type of object to which a row applies. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
For an inner join between two tables, the join returns a row from one table as many times as there are matches in the other table. Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
statement_performance_analyzer.limit, @sys.statement_performance_analyzer.limit The maximum number of rows to return for views that have no built-in limit. mysql> CALL sys.statement_performance_analyzer('delta', 'mydb.tmp_digests_ini', ... Creates a ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. Alternatively, ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Depending on how the query is structured, a function could be called once for every row in the result set, or even once for every row in the table, greatly magnifying any inefficiency. (When you reach a certain level of expertise, reading the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90; From the mysql ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...