PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/multiple-data-directories.html
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. Warning Normally, you should never have two servers that update data in ...
https://dev.mysql.com/doc/refman/9.7/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. To do this, you must have a mysqld that has been compiled with debugging support. If the version number ends with -debug, it is ...
https://dev.mysql.com/doc/refman/9.7/en/changing-mysql-user.html
On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user.
https://dev.mysql.com/doc/refman/9.7/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation-methods.html
There are two methods for installing MySQL from source: Use a standard MySQL source distribution. To obtain a standard distribution, see Section 2.1.3, “How to Get MySQL”. For instructions on building from a standard distribution, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/source-ssl-library-configuration.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. If you compile MySQL from a source distribution, CMake configures the distribution to use the installed ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-management.html
The syntax of the routine body is checked at creation time; any errors cause the CREATE statement to be rejected, and the stored program not to be created. The program body must be demarcated using the AS keyword plus dollar-quoted delimiters such ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server-troubleshooting.html
This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.4, “Troubleshooting a Microsoft Windows MySQL Server Installation”. If you have problems ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server.html
This section describes how start the server on Unix and Unix-like systems. (For Windows, see Section 2.3.3.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and ...