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-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. Additionally, there ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors occur. To start with, execute myisamchk -s each night on all tables that have been updated during the last 24 hours. If you are performing ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. When an equal when_value is found, the corresponding THEN clause statement_list ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html
When the replica's copy of the table is partitioned but the source's copy is not, statements acting on partitions cannot be run on the source without causing errors there. Replication is supported between partitioned tables as long as they use the ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the mysqlcheck program reads the [mysqlcheck] and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
Although in the past large log files could make crash recovery take excessive time, starting with MySQL 5.5, performance enhancements to crash recovery make it possible to use large log files with fast startup after a crash. Making your log files ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. After completing the installation process, you can edit the default option file ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...