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/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(): Waits until all transactions in a given GTID set have been executed. To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. Inconsistencies in the sequence of transactions that have been executed from the relay log can occur ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
MAXIMUM_SIZE For InnoDB: The maximum number of bytes permitted in the file. SELECT FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE, DATA_FREE, STATUS FROM ... The ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
For example: $> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES a24888f0d6f4 mysql/mysql-server "/entrypoint.sh my..." 14 seconds ago Up 13 seconds (health: starting) 3306/tcp, 33060/tcp mysql1 The container initialization might take ...Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; Substitute password with the password of your ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. As of MySQL 5.7.18, for any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a new row for that thread is added. The events_stages_history table contains the N most recent stage events that have ended per thread.