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/triggers.html
Additional Resources You may find the MySQL User Forums helpful when working with triggers. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. A trigger can be set ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
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/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the ...
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/information-schema-tp-thread-state-table.html
0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait type. The TP_THREAD_STATE table has one row per thread created by the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. On Windows, MySQL Installer interacts with the user and creates a file named ...
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 ...