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/mysql-cluster-overview.html
Thus, in a payroll application storing data in a cluster, if one application updates the salary of an employee, all other MySQL servers that query this data can see this change immediately. Because transactional applications are expected to handle ... NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html
--ndb-nodeid Command-Line Format --ndb-nodeid=# Type Integer Default Value [none] Set node ID for this node, overriding any ID set by --ndb-connectstring. Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ...
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
The following Perl script reset-replica.pl serves as an example of how you can do this. # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software ... It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before displaying it. This is done by returning the result set using the mysql_use_result() C API function ... mysql is a simple SQL shell with input line editing ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
This may not entirely prevent running out of file descriptors because in some circumstances the server may attempt to extend the cache size temporarily, as described in Section 8.4.3.1, “How MySQL Opens and Closes Tables”. You can remove the # ... If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces. (That is, this width is present in the metadata returned with result sets. As with integer types, this attribute prevents negative values from being stored in the ... MySQL supports an extension for optionally specifying ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
This does not update any indexes and therefore is very fast. This creates the index tree in memory before writing it to disk, which is much faster than updating the index during LOAD DATA because it avoids lots of disk seeks. UNLOCK TABLES; This ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
This clause has the same syntax as that as used with CREATE TABLE for creating a partitioned table, and always begins with the keywords PARTITION BY. MySQL 5.7 provides a number of ways to modify partitioned tables. It is possible to add, drop, ...
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
When you test for a match for this type of pattern, use the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms). (This differs from a LIKE pattern match, which succeeds only if the pattern matches the entire value.) To ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, “Performance Schema Connection Tables”. This is NULL for an internal thread, or for a user session that ...