MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 471 to 480 of 481 total results

https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html

transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...

8.12.3.2 Using Symbolic Links for MyISAM Tables on Unix

https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html

For InnoDB tables, use the alternative technique explained in Section 14.6.1.2, “Creating Tables Externally” instead. For files used by tables for other storage engines, you may get strange problems if you try to use symbolic links. Do not ...

8.12.3 Using Symbolic Links

https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html

For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 14.6.1.2, “Creating Tables Externally”. You can move databases or tables from the database directory to other ...

B.3.6.2 TEMPORARY Table Problems

https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html

Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...

5.5.3 MySQL Enterprise Thread Pool

https://dev.mysql.com/doc/refman/5.7/en/thread-pool.html

Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in ...

5.1.13 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

MySQL 5.7 and higher uses InnoDB for the time zone tables. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to ...

2.3.2 Choosing an Installation Package

https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html

It also configures the installed MySQL server (including a sandbox InnoDB cluster test setup) and MySQL Router. For MySQL 5.7, there are multiple installation package formats to choose from when installing MySQL on Windows. The package formats ...

2.3.4.2 Creating an Option File

https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html

You need to tune the server settings, such as memory, cache, or InnoDB configuration information. If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file. For options ...

2.3 Installing MySQL on Microsoft Windows

https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html

Note InnoDB tablespace files cannot exceed 4 GB on Windows 32-bit systems. Running MySQL on a 4K Sector Hard Drive Running the MySQL server on a 4K sector hard drive on Windows is not supported with innodb_flush_method=async_unbuffered, which is the ... Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows ...

2.3.7 Windows Platform Restrictions

https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html

DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 14.6.1.2, “Creating Tables Externally”. The following restrictions apply to use ...

Displaying 471 to 480 of 481 total results