PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. You ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. MySQL uses mmap() when possible to perform memory mapping on compressed tables. Please note the following: If the mysqld server was invoked with ...This results in much better performance when accessing individual rows, because you only have to uncompress exactly one ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. To work around this issue, use the --result-file option, which ...It ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 13.7.2.2, “CHECK TABLE ...On ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ...mysql_upgrade communicates directly with the MySQL server, sending it the SQL statements required to perform an ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, which means that a user account and its associated privileges created on one SQL node are not available on the cluster's other SQL nodes.
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. When compression is working well for a data ...The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of ...