Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must begin ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must begin ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-numeric.html
Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less memory to transfer and compare them. For unique IDs or other values that can be represented as either strings or numbers, prefer ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
The argument format is the same as for --plugin-load, but multiple instances of --plugin-load-add can be used to avoid specifying a large set of plugins as a single long unwieldy --plugin-load argument. Server plugins must be loaded into the server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
This method is efficient and only takes a significant amount of time if the replica is behind the source by a large number of binary log files. GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
MySQL Enterprise Edition includes a thread pool plugin that manages connection threads to increase server performance by efficiently managing statement execution threads for large numbers of client connections. MySQL supports an plugin API that ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
Be careful with the medium setting and especially the full setting, which has a large performance impact. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The benefits of compression therefore occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. X Plugin supports compression of messages ...