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/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
You can also get this list using the mysqlshow --status db_name command. With the removal of .frm files in MySQL 8.0, this column now reports a hardcoded value of 10, which is the last .frm file version used in MySQL 5.7. For example, InnoDB stores ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
Using perror, determine the error symbols: $> perror 10927 10914 1131 MySQL error code MY-010927 (ER_ACCESS_DENIED_FOR_USER_ACCOUNT_LOCKED): Access denied for user '%-.48s'@'%-.64s'. MySQL error code MY-010914 (ER_ABORTING_USER_CONNECTION): Aborted ... The log_filter_dragnet log filter component enables log filtering based on user-defined ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
Note that before MySQL 8.0.21, this time period defaulted to 5 seconds from the member becoming unavailable, which is just the detection period before a suspicion is created, because the additional expel timeout set by the ...From MySQL 8.0.16, a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. If ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-pool-tables.html
But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. Note The Performance Schema tables described here are available as of MySQL 8.0.14. Prior to ...They provide information about thread pool operation: tp_thread_group_state: Information about thread pool thread group ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-information-schema-tables.html
But it does not hold mutexes on all thread groups at the same time, to prevent a statement against TP_THREAD_STATE from blocking the entire MySQL server. Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...At this point, ...
https://dev.mysql.com/doc/refman/8.0/en/creating-database.html
To make menagerie the current database, use this statement: mysql> USE menagerie Database changed Your database needs to be created only once, but you must select it for use each time you begin a mysql session. Otherwise, you need to create it ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL Replication. Table 14.28 Positional Synchronization Functions Name Description Deprecated MASTER_POS_WAIT() Block ...