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/general-tablespaces.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. Similar to the system tablespace, ... A ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries. Therefore, consider focussing initial development efforts on write-intensive applications that are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API functions access the InnoDB tables directly, and are mostly DML operations with the exception of TRUNCATE TABLE. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
The memcached flush_all command is mapped to the TRUNCATE TABLE command. Since DDL commands can only use statement-based logging, the flush_all command is replicated by sending a TRUNCATE TABLE statement. Because the daemon_memcached plugin ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
A session holding a WRITE lock can perform table-level operations such as DROP TABLE or TRUNCATE TABLE. For sessions holding a READ lock, DROP TABLE and TRUNCATE TABLE operations are not permitted. LOCK {TABLE | TABLES} tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. Options that can be used with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--lossy-conversions, -l Command-Line Format --lossy-conversions Allow attribute data to be truncated when converted to a smaller type. Usage The program is invoked with the names of the source and target tables; either or both of these may be ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-functions.html
Table 12.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...