PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-thread_concurrency.html
InnoDB uses operating system threads to process requests from user transactions. When InnoDB receives a new request from a user session, if the number of threads concurrently executing is at a pre-defined limit, the new request sleeps for a short ...(Transactions may issue many requests to InnoDB before they commit or roll back.) On modern operating systems and servers with multi-core processors, where context switching is efficient, most workloads run well without any limit on the number of concurrent ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. The row format of a table determines how its rows are physically stored, which in turn can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
When using a raw disk partition, ensure that the user ID that runs the MySQL server has read and write privileges for that partition. For example, if running the server as the mysql user, the partition must be readable and writeable by mysql. The ...
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/internal-temporary-tables.html
This includes user-defined variables having a string value because they are treated as BLOB or TEXT columns, depending on whether their value is a binary or nonbinary string, respectively. In some cases, the server creates internal temporary tables ...
https://dev.mysql.com/doc/refman/5.7/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
Log in to the Oracle Key Vault management console as a user who has the System Administrator role. For details, consult the section named Add a KMIP Server in the KeySecure User Guide. Note The keyring_okv plugin is an extension included in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...