Search Results
https://dev.mysql.com/doc/refman/9.7/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-securing.html
To secure distributed recovery connections in the group, ensure that user credentials for the replication user are properly secured, and use SSL for distributed recovery connections if possible. Important When using the MySQL communication stack ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-resource-groups-table.html
User resource groups have a priority that ranges from 0 to 19. The RESOURCE_GROUPS table provides access to information about resource groups. For general discussion of the resource group capability, see Section 7.1.16, “Resource Groups”. You ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-role-column-grants-table.html
The ROLE_COLUMN_GRANTS table has these columns: GRANTOR The user name part of the account that granted the role. GRANTEE The user name part of the account to which the role is granted. The ROLE_COLUMN_GRANTS table provides information about the ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-role-routine-grants-table.html
The ROLE_ROUTINE_GRANTS table has these columns: GRANTOR The user name part of the account that granted the role. GRANTEE The user name part of the account to which the role is granted. The ROLE_ROUTINE_GRANTS table provides information about the ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user name part of the account that granted the role. GRANTEE The user name part of the account to which the role is granted. The ROLE_TABLE_GRANTS table provides information about the table ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-thread_concurrency.html
InnoDB uses operating system threads to process requests from user transactions. When InnoDB receives a new request from a user session, if the number of threads concurrently executing is at a pre-defined limit, the new request sleeps for a short ...(Transactions may issue many requests to InnoDB before they commit or roll back.) On modern operating systems and servers with multi-core processors, where context switching is efficient, most workloads run well without any limit on the number of concurrent ...
https://dev.mysql.com/doc/refman/9.7/en/internal-locking.html
Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, ...
https://dev.mysql.com/doc/refman/9.7/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...