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/spatial-geohash-functions.html
For the second syntax, a POINT value is required, where the X and Y coordinates are in the valid ranges for longitude and latitude, respectively. Characters past the 433rd are ignored, even if they are otherwise illegal and produce an error. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
If a table relies on a feature that is specific to another storage engine, you receive an error. In this case, add the ENGINE=other_engine_name clause to the CREATE TABLE statement to avoid the error. If InnoDB is not the default storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. In addition, to maintain consistency and service despite the silent ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host's file ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Some operating systems use a swap device in some contexts even if you have free memory. The --external-locking and ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. If you have many MyISAM tables in the same database ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
dl The name of the function library file containing the executable function code. The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
By default, these are latin1 and latin1_swedish_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...
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 ...