PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an individual column, you can use ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 21.7.2, “General ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The setup_timers table contains a row with a NAME value of wait that indicates the unit for wait event timing. The Performance Schema instruments waits, which are events that take time. These tables store wait events: events_waits_current: The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. When binlog_format=ROW, you can prevent the replica from stopping ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement for that table to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Supported Platforms Page compression requires sparse file and hole punching support. Hole Punch Size on Linux On Linux systems, the file system block size ...Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
For any other region, you must also set keyring_aws_region explicitly in my.cnf. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. If a filesort must be done, all rows that match the query without the LIMIT ...MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. mysql> SELECT ATAN(-2,2); -> -0.78539816339745 mysql> SELECT ATAN2(PI(),0); -> 1.5707963267949 CEIL(X) CEIL() is a synonym for CEILING(). mysql> SELECT ...ABS(X) ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
A corresponding set of MBR functions defined according to the OpenGIS specification is described later in this section. mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); mysql> SET @g2 = ST_GeomFromText('Point(1 1)'); mysql> SELECT ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful on a database server), you can mount your file systems with the -o noatime option. For ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...