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/thread-pool-tuning.html
Stalled statements generate a lot of extra overhead since they involve extra context switches and in some cases even extra thread creations. If the application has high requirements for the response time, it should most likely throttle users at a ...
https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html
However, the named_pipe_full_access_group system variable is available to control which MySQL users are permitted to use named-pipe connections. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be possible. Thus, if a statement contains substatements (such ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL Server has a practical set of features developed in close cooperation with our users. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. The following table shows the available servers for Windows in MySQL 5.7. Binary ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. Full backups are necessary, but it is not always convenient to create them. If you make sure to flush the logs ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. PARTITION_EXPRESSION The expression for the partitioning function used ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
See Section 13.1.18, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type ...