PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux.html
Each NDB Cluster host computer must have the correct executable programs installed. This section covers installation methods for NDB Cluster on Linux and other Unix-like operating systems. While the next few sections refer to a Linux operating ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
This differs from their use at function invocation time, for which you can use any lettercase. MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the ...
https://dev.mysql.com/doc/refman/5.7/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table ...To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
System variables enable audit log configuration and status variables provide runtime operational information. MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-backup-file.html
Usage ndb_print_backup_file file_name file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. These files are found in the data node's backup directory under the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-thread-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
EXTENT_SIZE: This option is specific to NDB, and is not supported by InnoDB, where it fails with an error. The minimum size is 32K, and theoretical maximum is 2G, although the practical maximum size depends on a number of factors. In theory, up to ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
This table has a maximum size of 100 rows by default. The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
Most of the time, these problems would be much easier to fix if the systems were not already in production. Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a ...