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-programs-ndb-desc.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. Three of the table properties that can be set using NDB_TABLE comments ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
This is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. In MySQL 8.0.19 and later, a row alias with one or more optional column aliases can be used with ON DUPLICATE KEY UPDATE to refer ...| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Conversely, transactions performing inserts, updates and deletes on foreign key child tables (referencing) are not especially serialized with regard to one another. This means that the history size follows a sawtooth pattern over time, and therefore ...(The default is COMMIT_ORDER.) Writeset maintenance work in NDB is performed by the MySQL binary log injector thread as part of preparing and committing each epoch transaction to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
It backs up and restores a read-only database like any other, but enables the READ ONLY option at restore time if it was enabled at backup time. For any alter_option omitted from the statement, the database retains its current option value, with the ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
(This is a change from previous versions of MySQL.) To cause the server to refuse or permit LOAD DATA LOCAL statements explicitly (regardless of how client programs and libraries are configured at build time or runtime), start mysqld with ...To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
If YES, and the instrumentation is enabled and timed, CPU_TIME is measured. If you disable a consumer, the server does not spend time maintaining destinations for that consumer. For example, if you do not care about historical event information, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and ... This ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. Adjust the flush method In some versions of GNU/Linux ...If the Unix top tool or the Windows Task Manager shows that the CPU usage percentage with your workload is less than 70%, your workload is probably ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. (The latter table contains no Shutdown_priv ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
This information is accessible to everyone who has the time and ability to intercept it and use it for their own purposes. In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) ...