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/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/mysql-cluster-programs-ndb-import.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. --idlespin=# Command-Line Format --idlespin=# Type Integer Default Value 0 ...Options supported by ndb_import include those for specifying field separators, escapes, and line terminators, and are described later in 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/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/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) ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...
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/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...In ...