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/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. Tables in the performance_schema database cannot be locked with LOCK TABLES, except the ...If ...Instruments that apply to storage engines might not be implemented for all storage ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
This column uses the SET data type, so multiple flags from the following list can be set per instrument: singleton: The instrument has a single instance. row *************************** NAME: thread/sql/event_scheduler ENABLED: YES HISTORY: YES ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
To permit assessment at a more fine-grained level, the Performance Schema also collects histogram data for statement latencies. The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
(The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server up to date incrementally from the time of the full backup to a more recent time.
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
The BLACKHOLE storage engine accepts data but discards it and does not store it. When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. Updates and deletes are handled differently ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
If the destination table does not exist, logging occurs as follows. ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. Prior to MySQL 8.0.21, the statement is logged as two transactions. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql schema are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
At a minimum, this is likely to cause the distribution of data among partitions to be different in the source's and replica's copies of a given table. Using different server SQL mode settings on the source and the replica may cause the same INSERT ...