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/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...See also the notes ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
To see the default InnoDB stopword list, query the Information Schema INNODB_FT_DEFAULT_STOPWORD table. The stopword table must have a single VARCHAR column named value. The following example demonstrates creating and configuring a new global ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
When modifying multiple tables within a transaction, or different sets of rows in the same table, do those operations in a consistent order each time. Add well-chosen indexes to your tables so that your queries scan fewer index records and set fewer ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Define additional table identifiers in the innodb_memcache.containers table, and use the @@table_id.key ...This ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. --auto-generate-sql-add-autoincrement Command-Line Format --auto-generate-sql-add-autoincrement Type Boolean Default Value FALSE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. ERROR 1051 (42S02): Unknown ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/charset-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 COLLATE ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
An NDB tablespace to be dropped must not contain any data files; in other words, before you can drop an NDB tablespace, you must first drop each of its data files using ALTER TABLESPACE ... mysql> CREATE TABLESPACE myts -> ADD DATAFILE ... DROP ...