PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. Given these considerations, for many applications, some tables compress more effectively than others, and you might find that your workload performs ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. With ...The ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for INFORMATION_SCHEMA? See the MySQL User Forums. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ...It is ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an internal optimizer object with no user significance. For SELECT statements, the EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
Instead, users of NDB Cluster binaries from Oracle should upgrade to the most recent binary release of NDB Cluster for supported platforms—these include RPMs that should work with most Linux distributions. NDB Cluster users who build from source ...While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section 21.2.7, “Known Limitations of NDB ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
Users should make sure the package has been installed on the system before installing the server. When installed, MySQL does not need to be executed using a user with Administrator privileges. MySQL Installer automatically installs MySQL Server and ... Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows ...This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable Package, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
In addition, the table is compressed periodically at a user-configurable rate; see mysql.gtid_executed Table Compression, for more information. For example, the values stored by the gtid_executed and gtid_purged system variables are GTID sets. The ...If a client transaction is not written to the binary log (for example, because the transaction was filtered out, or the transaction was read-only), it is not assigned a GTID on the server of ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. The ...