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/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 14.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial testing. You can use this data to help decide whether or not ... Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive data. Because memcached does not use an authentication mechanism by default, and the ...Do not allow memcached access to these servers from the Internet; only allow access from within a firewalled intranet, ideally from a subnet whose membership you can ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
Setting this variable does not in itself enable the logs; they must be enabled separately. In this case, because the default log destination is FILE, you could omit the log_output setting. (This assumes that the general query log itself is enabled.) ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. myisamchk -e tbl_name This does a complete and thorough check of all data (-e means “extended check”). This may take a long time for a ...
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. --ndb-nodeid Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. The names of these files have the following pattern: ... ndbmtd is a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for redundancy), there should be a total of four replication nodes, two per cluster. Replication of an NDB Cluster as ... A ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Because the default is to buffer all types of data change operations, only change this setting if you need to reduce the amount of buffering. You might change this setting during periods of unusual activity, then restore it to its original setting.
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. To set a larger value, start mysql like this: $> mysql ... A ...