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/innodb-dedicated-server.html
Warning Prior to MySQL 8.0.14, O_DIRECT_NO_FSYNC was not suitable for file systems such as XFS and EXT4, which require an fsync() system call to synchronize file system metadata changes. As of MySQL 8.0.14, fsync() is called after creating a new ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
You can create a new table for data, or use existing tables. The combination of InnoDB tables and memcached offers advantages over using either by themselves. Data written using the memcached protocol is transparently written to an InnoDB table, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. You can use the CHECK TABLE statement to check whether a table is corrupt, although CHECK TABLE naturally cannot detect every possible kind ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. Then the keys are sorted and finally the rows are retrieved from ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. For completeness, it can also back up tables from MyISAM and other storage engines. MySQL Enterprise Backup does a hot backup of all tables ... MySQL Enterprise Backup performs hot backup operations for MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
Figure 19.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then limiting the binary log statements that each replica processes by using the --replicate-wild-do-table ... There may be situations where you have a single source server and want to replicate different databases to different ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Suppose that a customer table containing customer records has these columns: id: ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
Dropping a database does not remove any TEMPORARY tables that were created in that database. TEMPORARY tables are automatically removed when the session that created them ends. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ n/a Created STZ n/a Last altered STZ n/a . To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. The session time ...Event Scheduler Time Representation Each session in MySQL has a session time zone ...