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-file-format-enabling.html
You can set the value of innodb_file_format on the command line when you start mysqld, or in the option file (my.cnf on Unix, my.ini on Windows). The innodb_file_format configuration option enables an InnoDB file format for file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL option file (my.cnf or my.ini) or changed at runtime with the SET GLOBAL statement. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-multiple_io_threads.html
You can set values for these parameters in the MySQL option file (my.cnf or my.ini); you cannot change values dynamically. InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
You can control whether InnoDB uses its own memory allocator or an allocator of the operating system, by setting the value of the system configuration parameter innodb_use_sys_malloc in the MySQL option file (my.cnf or my.ini). When InnoDB was ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
A convenient way to accomplish this is to add lower_case_table_names=1 to the [mysqld] section of your my.cnf or my.ini file before creating databases, tablespaces, or tables: [mysqld] lower_case_table_names=1 When running ALTER TABLE ... This ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
Copy the my.cnf or my.ini option file used by the existing instance. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new instance: Create a new data directory.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
(For example, 100K means 100 × 1024 = 102400.) Parameter names and values are case-insensitive, unless used in a MySQL Server my.cnf or my.ini file, in which case they are case-sensitive. The [ndbd] and [ndbd default] sections are used to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
If your MySQL binary is built with partitioning support, nothing further needs to be done to enable it (for example, no special entries are required in your my.cnf file). Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To set the SQL mode at server startup, use the --sql-mode="modes" option on the command line, or sql-mode="modes" in an option file such as my.cnf (Unix operating systems) or my.ini (Windows). The MySQL server can operate in different SQL modes, ...