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/mysql-cluster-install-shutdown-restart.html
On the SQL node host (198.51.100.20), execute the following command: C:\> SC START mysql In a production setting, it is usually not desirable to shut down the cluster completely. To shut down the cluster, enter the following command in a shell on ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. The discussion here relies on the ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
If explicit COLLATE Y and COLLATE Z occur, raise an error. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
DURATION How long statement execution remained in the given state, in seconds. SOURCE_FUNCTION, SOURCE_FILE, and SOURCE_LINE Information indicating where in the source code the profiled state executes. Its contents correspond to the information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-names.html
MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation characteristics. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
| +-----+---------------------------------------------------------------+ 20 rows in set (0.00 sec) Use EXPLAIN to check the way this query is executed: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 ...The ... The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html
MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a source running MySQL 5.6 to a replica running MySQL 5.7, from a source running MySQL 5.7 to a replica running MySQL 8.0, and ...