Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. To verify that events are being logged, issue a statement such as SHOW DATABASES and check ... MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
Using MySQL HeatWave GenAI, you can perform natural-language searches in a single step using either in-database or external large language models (LLMs). MySQL HeatWave GenAI includes the following: In-Database and OCI Generative AI Service LLMs ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
To view the lists of available LLMs, see MySQL HeatWave In-Database LLMs and OCI Generative AI Service LLMs. Possible values are float values between: 0 and 5 for the MySQL HeatWave In-Database LLMs. Note This parameter is supported for MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
How about age? That might be of interest, but it is not a good thing to store in a database. Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays.
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Is there a way to view all stored procedures and stored functions in a given database? A.4.7. Is there a MySQL equivalent to using mod_plsql as a gateway on Apache to talk directly to a stored procedure in the database? A.4.17. You can obtain ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
As the database operates, pages in the buffer pool that are not accessed “age” by moving toward the tail of the list. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). YourSQL','In the following database ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The INDEX_ID is an identifier for the index that is unique across all databases in an instance. Example 17.4 Joining InnoDB INFORMATION_SCHEMA Schema Object Tables This example demonstrates joining three InnoDB INFORMATION_SCHEMA schema object ...