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/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. In this way, aggregations at higher levels are available directly without the need for user-defined views that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
Cycle counters also have disadvantages: End users expect to see timings in wall-clock units, such as fractions of a second. For example, on Pentiums, the instruction is RDTSC (an assembly-language rather than a C instruction) and it is theoretically ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. MySQL Perl support requires that you have installed MySQL client programming ...
https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. List the options in an option file that ...
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-howto.html
Optionally, create a separate user for your replicas to use during authentication with the source when reading the binary log for replication. This section describes how to set up a MySQL server to use binary log file position based replication.
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. If the replication I/O thread state says Connecting to master, check the following: Verify the privileges for the user being used for replication on the source. If ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates with users by setting the message column of table rows. MySQL supports query rewrite plugins that can examine and possibly modify SQL ...