PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
A statement becomes blocked if it encounters a disk I/O operation or a user level lock (row lock or table lock). While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
Users should make sure the package has been installed on the system before installing the server. When installed, MySQL does not need to be executed using a user with Administrator privileges. MySQL Installer automatically installs MySQL Server and ... Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). The following restrictions apply to use of MySQL on ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. It updates the grant tables with any changes that have ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. Also, if it is important ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. Note Statements that update the information in the mysql system database, such as GRANT, REVOKE and the manipulation of triggers, ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. In such a setup, applications and users would have no access to the database tables directly, but can only ...A ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is granted full permissions to this new my.ini file. In other words, be sure that the MySQL Server ...