Search Results
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-memory.html
If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. The following formula yields the amount of space required: (largest_key + row_pointer_length) * number_of_rows * 2 You can check the ...myisamchk uses no more memory than its memory-related variables are set ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. Table 25.26 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-top.html
This user must be able to read tables in the ndbinfo database (ndb_top uses information from ndbinfo.cpustat and related tables). The following table includes all options that are specific to the NDB Cluster program ndb_top. ndb_top displays ...
https://dev.mysql.com/doc/refman/9.7/en/network-namespace-support.html
Each namespace has its own IP addresses, network interfaces, routing tables, and so forth. Group Replication, only when using the MySQL communication stack to establish group communication connections. Network Namespace Monitoring For replication ...
https://dev.mysql.com/doc/refman/9.7/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...This difference makes user_defined_functions preferable to mysql.func for checking which loadable functions are ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/9.7/en/parenthesized-query-expressions.html
| TABLE | VALUES order_by_clause: ORDER BY as for SELECT limit_clause: LIMIT as for SELECT into_clause: INTO as for SELECT set_op: UNION | INTERSECT | EXCEPT MySQL 9.7 supports parenthesized query expressions according to the preceding syntax.
https://dev.mysql.com/doc/refman/9.7/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 ...