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/windows-create-option-file.html
You need to tune the server settings, such as memory, cache, or InnoDB configuration information. 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 ...For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. This means that treatment of NULL varies between partitioning of different ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
(NDB 7.5.0) This refers to the Id set for one of the computers (hosts) defined in a [computer] section of the configuration file. A normal configuration uses the management server as arbitrator, setting its ArbitrationRank to 1 (the default for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...SQL ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
If the distance is 0, ST_Buffer() returns the geometry argument unchanged: mysql> SET @pt = ST_GeomFromText('POINT(0 0)'); mysql> SELECT ST_AsText(ST_Buffer(@pt, 0)); +------------------------------+ | ST_AsText(ST_Buffer(@pt, 0)) | ...See that ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. Your database has now been restored ... The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. The name of the performance_schema database is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
For the text protocol, this column is the external statement name assigned by the user. To control the size of this table, set the performance_schema_max_prepared_statements_instances system variable at server startup. The Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_PRETTY(json_val) Provides pretty-printing of JSON values similar to that implemented in PHP and by other languages and database systems. Formatting of the output from this ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...