Search Results
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_kerberos SONAME 'authentication_kerberos.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
The client connects to server 2 and registers its server requirements there by setting its version_tokens_session system variable: mysql> SET @@SESSION.version_tokens_session = 'emp=write'; For subsequent statements sent by the client to server 2, ...A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL servers but needs to manage them for load balancing purposes by monitoring them and adjusting server assignments according to load ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
--plugin-authentication-webauthn-client-preserve-privacy={OFF|ON} Command-Line Format --plugin-authentication-webauthn-client-preserve-privacy Type Boolean Default Value OFF Determines how assertions are sent to server in case there is more than one ...(MySQL 8.4.6 and later:) --binary-mode, when enabled, causes the server to disregard any setting for ... mysql supports the following ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
It involves relatively low overhead on the server, so you might query it periodically on a production server to check the overall efficiency of the compression feature. Overall application performance, CPU and I/O utilization and the size of disk ...This section builds on the performance tuning advice from Section 17.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
To download the MySQL Community Edition image from the Oracle Container Registry (OCR), run this command: docker pull container-registry.oracle.com/mysql/community-server:tag The tag is the label for the image version you want to pull (for example, ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...See the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.4 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is utf8mb4_0900_ai_ci, whereas lookups are case-sensitive if the collation is utf8mb4_0900_as_cs or ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
--bootstrap URI, -B URI Command-Line Format --bootstrap URI, -B URI Type String The main option to perform a bootstrap of MySQL Router by connecting to the InnoDB Cluster metadata server at the URI provided. MySQL Router configures itself based on ... mysqlrouter Option Summaries mysqlrouter Option Descriptions MySQL Router accepts command line options that are passed into mysqlrouter to affect its behavior, or to bootstrap router based on an InnoDB ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
This is what I'd call a "distinguishing characteristic" because in all the major DBMSs (like IBM DB2, Microsoft SQL Server, and Oracle), the main or default or classic structure is the heap-and-index. Compare Oracle's Index Organized Tables, and ...