Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. It can also be used for queries that specify just a last_name value because that column is a leftmost prefix of the index (as ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
Use this for tables that are heavily used for searches but that are not updated. This feature enables you to assign different table indexes to different key caches. Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
This can also be changed by changing the source and recompiling. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. myisamchk --fast checks only those tables that don't have this ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
This enables you to specify all tables in a directory by using the pattern *.MYI. You should then ensure that no one is using the tables while you are running myisamchk However, the easiest way to avoid this problem is to use CHECK TABLE instead of ... The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
The easiest way to accomplish this is to do a search-and-replace on the file that contains the definitions and replace all instances of ENGINE=engine_name with ENGINE=NDBCLUSTER. Note The information in this section applies to NDB Cluster running ...Working with database tables and data in NDB Cluster is not much different from doing so in standard ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data nodes. Note that string '/BACKUP' is always appended to this setting, so that ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). In this context, VARCHAR and CHAR are considered the same if they are declared as the same ...