PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable Package, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
A newer user interface for displaying query results, where different views are presented from result sets returned by a MySQL Server like: Multiple tabs for each result set returned by an executed query. Designed and developed as a Visual Studio ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
For example, you can set up a source/replica relationship over a dial-up link where the link is up only sporadically and for short periods of time. How can I use replication to improve performance of my system? Set up one server as the source and ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. They have the binary character set and collation, and comparison and sorting are based on the numeric ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
If DML action is concentrated on a few tables, keep the innodb_purge_threads setting low so that the threads do not contend with each other for access to the busy tables. InnoDB does not physically remove a row from the database immediately when ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| wait/io/file/sql/binlog ...| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...Stored ...A stored routine is a set of SQL statements that can be stored in the ...Once this has been done, clients don't need to keep ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
For example: mysql> SET GLOBAL keycache1.key_buffer_size=128*1024; To destroy a key cache, set its size to zero: mysql> SET GLOBAL keycache1.key_buffer_size=0; You cannot destroy the default key cache. Shared access to the key cache improves ...To ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write access to MySQL database directories. For files used by tables for other storage engines, you may get strange ...Do ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...