PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
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-server-states.html
If the group is fully functional and all members are communicating properly, all members report the same state for all other members. In this situation, the member does not attempt to guess the status of the other servers, and instead reports them ... The state of a Group Replication group member shows its current role in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html
Database page content is not written to the doublewrite buffer, and recovery does not use the doublewrite buffer to fix incomplete page writes. MySQL 8.0.30 onwards supports dynamic changes to the innodb_doublewrite setting that enables the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html
InnoDB monitor output begins with a header containing a timestamp and the monitor name. The --innodb-status-file option is intended for temporary use, as output generation can affect performance, and the innodb_status.pid file can become quite large ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using mysqld_safe. It can be used on systems such as Linux and Solaris that use System V-style run directories to start and stop ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
If synchronization of the object fails due to a temporary error, it is picked up and added back to the queue (and to this table) the next time NDB performs mismatch detection; if the attempts fails due a permanent error, the object is added to the ...Prior to NDB 8.0.21, the only information readily accessible to users about this process was in the form of logging messages and object counts available (beginning with NDB 8.0.18) as the status variables Ndb_metadata_detected_count, Ndb_metadata_synced_count, and Ndb_metadata_excluded_count (prior to NDB 8.0.22, this variable was named ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. If a statement that executed a long time ago took a lock but ...The relation is based on a nested set data model, so the join has several ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ...This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT statements are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
The views are calculated based on the overall and/or delta activity. If in_table is NULL and no snapshot exists, a new snapshot is created. The in_views parameter and the statement_performance_analyzer.limit configuration option affect the operation ... Creates a report of the statements running on the ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
In this case, the view is stored in a temporary table and thus you are not really selecting from the table in a subquery and modifying it at the same time. There is a general principle that you cannot modify a table and select from the same table in ... The maximum number of tables that can be referenced in the definition of a view is ...