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/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.0/en/making-trace-files.html
In a console window, use this command: C:\> mysqld-debug --debug --standalone After this, you can use the mysql.exe command-line tool in a second console window to reproduce the problem. The trace file can become very large! To generate a smaller ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Normally this behavior does not occur because max_write_lock_count by default has a very large value. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking applies not just to ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
If you are using --extend-check and have plenty of memory, setting the key_buffer_size variable to a large value helps the repair operation run faster. myisamchk supports the following options for table checking operations: --check, -c Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
--set-auto-increment[=value], -A[value] Force AUTO_INCREMENT numbering for new records to start at the given value (or higher, if there are existing records with AUTO_INCREMENT values this large). If value is not specified, AUTO_INCREMENT numbers ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
If you are using large Disk Data tables, you may also need to increase DiskPageBufferMemory. As with single-threaded backups, you may also want or need to make adjustments to settings for BackupDataBufferSize, BackupMemory, and other configuration ... It is possible in NDB 8.0 to take a backup with multiple local data managers (LDMs) acting in parallel on the data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-management.html
MySQL Cluster Manager provides an advanced command-line interface that simplifies many otherwise complex NDB Cluster management tasks, such as starting, stopping, or restarting an NDB Cluster with a large number of nodes. Managing an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Because NDB Cluster requires large numbers of ports to be open for communications between nodes, the recommended option is to use a segregated network. In this section, we discuss basic network security issues as they relate to NDB Cluster. It is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
For these reasons, hot backups are desirable when your database “grows up” -- when the data is large enough that the backup takes significant time, and when your data is important enough to your business that you must capture every last change, ... MySQL Enterprise Backup performs hot backup operations for MySQL ...