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/mysql-cluster-what-is-new-7-6.html
On systems performing initial bulk loads of data, it may be necessary to break up very large transactions into smaller parts. ndb_import, added in NDB Cluster 7.6, loads CSV-formatted data directly into an NDB table using the NDB API (a MySQL server ... New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
Rows are grouped into events smaller than this size if possible. You can pipe the output of mysqlbinlog into the mysql client to execute the events contained in the binary log. The server's binary log consists of files containing “events” that ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is NULL. When retrieved, values stored into an ENUM ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Suppose that you generate an AUTO_INCREMENT value with one statement, and then refer to LAST_INSERT_ID() in a multiple-row INSERT statement that inserts rows into a table with its own AUTO_INCREMENT column. For SELECT * FROM t1 INTO OUTFILE ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If you are using lookup values that contain spaces, transform or hash them into values without spaces before using them as keys in calls to add(), set(), get(), and so on. CREATE VIEW numbers AS SELECT c1 KEY, CAST(c2 AS UNSIGNED INTEGER) val FROM ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
It also inserts a single row of data into the demo_test table. Normally, the memcached data also disappears at this point, and you would require application logic to load the data back into memory when memcached is restarted. mysql> UNINSTALL PLUGIN ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
One of these is to modify the table definition before importing it into the Cluster database. Then modify the table definitions as just described and import the file into the SQL node of the cluster like this: $> mysql world < /tmp/world.sql If you ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
If you are using a recent version of mysqldump to generate a dump to be reloaded into a very old MySQL server, use the --skip-opt option instead of the --opt or --extended-insert option. These are the source server coordinates from which the replica ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this value. Placement of rows into partitions is determined by comparing the tuple from a row to ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
[into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY {col_name | expr | position} [ASC | DESC], ... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] ...