PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
For example, you can run a cron job to check important tables once a week, using a line like this in a crontab file: 35 0 * * 0 /path/to/myisamchk --fast --silent /path/to/datadir/*/*.MYI This prints out information about crashed tables so that you ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-optimization.html
This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use. This optimizes seeks and makes table scans that use indexes faster. This makes your data much more ... To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
It is possible to update cluster configuration parameters marked as node online—that is, without shutting down the cluster—in this fashion. However, decreasing the values of such parameters—whether this is done using a node restart, node ...
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 ...