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/mysql-cluster-ndbinfo-logbuffers.html
One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer used during backup to copy fragments to backup files. The logbuffers table contains the following columns: node_id The ID of this data node. One each of these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it hosts. A fragment can have any number of fixed-size pages; when the last row on a ... memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). in_outfile VARCHAR(255): The name to use for the .dot output file. in_max_runtime DECIMAL(20,2): The maximum ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
This includes variables set within files specified using the init_file system variable. EXPLICIT The variable was set from an option file named with the --defaults-file option. EXTRA The variable was set from an option file named with the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it expired, and writes it to the server error log. The MySQL installation process involves initializing the data ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-catalog-dashboard.html
You must provide credentials with root privileges to reconfigure these items. This action is repeated during next startup if MySQL Installer encounters an error downloading the catalog. For upgrades, a check box enables you to skip the upgrade check ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error. If the timeout is reached without successful lock acquisition, an ER_LOCKING_SERVICE_TIMEOUT error ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily with SHOW REPLICA STATUS. These options can still be used when the GTID_ONLY option was set on the CHANGE ...When you use these options, you must start the receiver thread (IO_THREAD option) or all the replication threads; you cannot start the replication applier thread (SQL_THREAD option) ...] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | SOURCE_LOG_FILE = 'log_name', SOURCE_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ...Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled ...