PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. In multi-primary mode, slower members can also build up an excessive backlog of transactions to certify and apply, leading to a ... In ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate.html
The disk_write_speed_aggregate table provides aggregated information about the speed of disk writes during LCP, backup, and restore operations.
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
If the network is slow, this is not a good approximation; the replication applier thread may quite often be caught up with the slow-reading replication receiver thread, so Seconds_Behind_Source often shows a value of 0, even if the replication ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. For the bytes_sent and bytes_received fields to be populated, the system variable ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
ORDER BY RAND() LIMIT 15; Influencing ORDER BY Optimization For slow ORDER BY queries for which filesort is not used, try lowering the max_length_for_sort_data system variable to a value that is appropriate to trigger a filesort. Assuming that there ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
The main considerations for optimizing queries are: To make a slow SELECT ... Queries, in the form of SELECT statements, perform all the lookup operations in the database. Besides SELECT statements, the tuning techniques for queries also apply to ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
The InnoDB buffer pool caches both table data and index data, speeding up lookups for queries and keeping query results in memory for reuse. autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. This section describes how to configure audit logging characteristics, such as the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. LOCK clauses are described below, in ...Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL ...
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 ] ...