Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/9.7/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Access to this table should never be granted to any nonadministrative accounts. The validate_password plugin can be used to enforce a policy on acceptable password. Database ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. As described earlier, it is possible to find out by querying the setup_instruments table. Changes to this code occur often, ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-memory-model.html
The buffers are global to the server, so the instruments are displayed only in the memory_summary_global_by_event_name table, and not in other memory_summary_by_xxx_by_event_name tables. Memory used depends on the load actually seen, not the load ...
https://dev.mysql.com/doc/refman/9.7/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever ...
https://dev.mysql.com/doc/refman/9.7/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/9.7/en/proxy-users.html
As an alternative to proxy users, DBAs may find that roles provide a suitable way to map users onto specific sets of named privileges. In this case, employee_ext can access tables in the employees database. For example: GRANT PROXY ON 'proxied_user' ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/9.7/en/replication-applier-metrics-component.html
The Replication Applier Metrics component implements two Performance Schema tables, listed here: replication_applier_metrics: Shows statistics for the replication applier, for a given replication channel. Purpose: Provide replication applier ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. This feature ensures that the replica stays connected to the most suitable source server at ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...