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-purge-configuration.html
This removal operation, which only occurs after the row is no longer required for multi-version concurrency control (MVCC) or rollback, is called a purge. InnoDB does not physically remove a row from the database immediately when you delete it with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-compression.html
This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general tablespaces. Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-tables.html
This section covers topics related to InnoDB tables. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace.html
This section covers topics related to InnoDB tablespaces. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
This is in contrast to truncating InnoDB tables that are stored within the InnoDB system tablespace (tables created when innodb_file_per_table=OFF) and tables stored in shared general tablespaces, where only InnoDB can use the freed space after the ... To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
This also applies to its synonyms (--innodb=OFF, --disable-innodb, and so forth). Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-starting.html
On the same system where the server instance is running, open a terminal window (command prompt on Windows) and start MySQL Shell with the following command: mysqlsh --uri user@localhost You are prompted to input your password and then this ... You ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
This is likely to be the case if you get a “program not found” error whenever you attempt to run a MySQL program from any directory other than the bin directory. To invoke a MySQL program from the command line (that is, from your shell or ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. The following procedure shows how to configure MySQL to ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-server-config.html
This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces. The MySQL server listens on a single network socket for TCP/IP connections. To specify an address, set bind_address=addr at server ...