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/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
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 ...