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/table-cache.html
If table_open_cache is set too high, MySQL may run out of file descriptors and exhibit symptoms such as refusing connections or failing to perform queries. MySQL is multithreaded, so there may be many clients issuing queries for a given table ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
Several programs perform setup operations during MySQL installation or upgrading: comp_err This program is used during the MySQL build/installation process. mysql_install_db This program initializes the MySQL data directory, creates the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a “phantom” problem (one that you cannot duplicate at will), use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. Note Statements that update the information in the mysql system database, such as GRANT, REVOKE and the manipulation of triggers, ...
https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Figure 16.1 Using Replication to Improve Performance During Scale-Out If the part of your code that is responsible for database access has been properly abstracted/modularized, converting it to run with a replicated setup should be very smooth and ...Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing ... You can use replication as a scale-out solution; that is, where ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
CHARACTER_OCTET_LENGTH should be the same as CHARACTER_MAXIMUM_LENGTH, except for multibyte character sets. For example, if you say SHOW FULL COLUMNS FROM t, and you see in the COLLATION_NAME column a value of latin1_swedish_ci, the character set is ...TABLE_SCHEMA The name of the schema (database) to which the table containing the column ...The COLUMNS table has these ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. If the directory specified does not exist, NDB attempts to create it; the ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Note Replication filters cannot be set on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. REPLICATE_REWRITE_DB: ...