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/reserved-accounts.html
During data directory initialization, MySQL creates user accounts that should be considered reserved: 'root'@'localhost: Used for administrative purposes. This account is locked so that it cannot be used for client connections. This account is ...
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
A user with the SUPER or REPLICATION CLIENT privilege may execute this statement. SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-argument-handling.html
This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. SRID 0 is the default for new geometry values if no SRID is specified. Spatial values, or geometries, have the properties ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
(Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse pointer does not move. Please examine your system log file (/var/log/messages or similar) for reasons for your problem. Use the “copy and ...This can normally be checked by pressing the Caps Lock ...
https://dev.mysql.com/doc/refman/5.7/en/windows-extract-archive.html
Make sure that you are logged in as a user with administrator privileges. To install MySQL manually, do the following: If you are upgrading from a previous version please refer to Section 2.10.8, “Upgrading MySQL on Windows”, before beginning ...If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. Whether a word is too short is determined from ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. For full instructions to configure and start sources and replicas using GTID-based ...When ...To start a replica using GTID-based replication, you do not include MASTER_LOG_FILE or MASTER_LOG_POS options in the CHANGE MASTER TO statement used to direct the replica to replicate from a given ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. With simple tests, you usually test how ...Benchmarks are typically long-running and elaborate performance tests, where the results could dictate high-level choices such as hardware and storage configuration, or how soon to upgrade to a new MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
This should be similar to what is shown here, where password is the MySQL root password for a given MySQL server instance: $> mysqladmin -uroot -ppassword shutdown 081208 20:19:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
Run the chosen script as follows: $> mysql -u root -p < install_rewriter.sql Enter password: (enter root password here) The example here uses the install_rewriter.sql installation script. To verify that, connect to the server and execute this ...