MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1221 to 1230 of 1234 total results

25.10 Performance Schema Statement Digests

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html

However, if the special row accounts for a significant percentage of the statements executed, it might be desirable to increase the summary table size by increasing performance_schema_digests_size. The MySQL server is capable of maintaining ...

8.2.5 Optimizing Database Privileges

https://dev.mysql.com/doc/refman/5.7/en/permission-optimization.html

Similarly, if you place no resource limits on any accounts, the server does not have to perform resource counting. The more complex your privilege setup, the more overhead applies to all SQL statements. Simplifying the privileges established by ...

16.1.7.3 Skipping Transactions

https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html

Make sure that you have identified the position accurately, because this statement does not take event groups into account. If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the ...

16.4.1.23 Replication and Partitioning

https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html

Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure except where an exception is specifically allowed (see Section 16.4.1.10, “Replication with Differing Table ...

16.1.4.1 Replication Mode Concepts

https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html

The ability to configure the replication mode online means that the gtid_mode and enforce_gtid_consistency variables are now both dynamic and can be set from a top-level statement by an account that has privileges sufficient to set global system ...

5.1.14 Server-Side Help Support

https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html

Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 13.8.3, “HELP ...

13.7.4 SET Statements

https://dev.mysql.com/doc/refman/5.7/en/set-statement.html

Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET PASSWORD assigns account passwords. Descriptions for those forms that are not associated with a specific server ...

13.7.6.7 SHUTDOWN Statement

https://dev.mysql.com/doc/refman/5.7/en/shutdown.html

Another way to stop the server is to send it a SIGTERM signal, which can be done by root or the account that owns the server process. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command ...

26.4.3.15 The latest_file_io and x$latest_file_io Views

https://dev.mysql.com/doc/refman/5.7/en/sys-latest-file-io.html

The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections). These views summarize file I/O activity, grouped by file and thread.

26.4.5.10 The ps_is_consumer_enabled() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html

(Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.

Displaying 1221 to 1230 of 1234 total results