PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application. The main benefits are increased speed and more simple management for embedded applications. Note The libmysqld embedded server ...
https://dev.mysql.com/doc/refman/5.7/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. This type of locking is internal because it is performed entirely ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root password. Choosing ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
MERGE tables can help you solve the following problems: Easily manage a set of log tables. For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a more sophisticated method called the midpoint insertion strategy. When using the midpoint insertion strategy, ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-servers.html
You can run multiple servers on Windows by starting them manually from the command line, each with appropriate operating parameters, or by installing several servers as Windows services and running them that way. General instructions for running ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
myisamchk uses no more memory than its memory-related variables are set to. If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. The default is to use only about 3MB to perform repairs.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...