PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-system-support.html
As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ... Before MySQL Server can accept IPv6 connections, the ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
This permits tuning of the performance of I/O operations for index files. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. The best performance for I/O operations is ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host.