PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.0/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. Each user can be granted a given single role to, in effect, be granted the appropriate set of privileges. The ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
An SELinux context (the label applied to a system object) has the following fields: user, role, type, and security level. Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
Various employee roles within both the card processing company and the financial institution require access to that data. Some of these roles may require access only to masked data. Other roles may require access to the original data on a ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
This should be a literal name, or '%' to mean “any user.” ROLE Unused. The setup_actors table has these indexes: Primary key on (HOST, USER, ROLE) TRUNCATE TABLE is permitted for the setup_actors table. The setup_actors table contains ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
ndb_conflict_role Command-Line Format --ndb-conflict-role=value Introduced 8.0.23-ndb-8.0.23 System Variable ndb_conflict_role Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value NONE Valid Values NONEPRIMARYSECONDARYPASS ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
The roles of the primary and secondary NDB Clusters in this scenario are fully determined by mysql.ndb_replication table entries. In this scenario, primary and secondary roles are assigned to the two sources by setting the ndb_slave_conflict_role ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. The user account that is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...