Search Results
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If you modify the grant tables indirectly using an account-management statement, the server notices these changes and loads the grant tables into memory again immediately. Any user can connect and perform any operation, which is insecure. If the ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. For example: USE test; SET GLOBAL innodb_file_per_table=1; SET GLOBAL autocommit=0; -- Create an uncompressed table with a million or two rows. \! ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
You can also create custom listeners to allow trace messages to be written to other destinations as mobile devices and web services. The first thing you need to do is create a suitable app.config file for your application. mysql Information: 1 : 1: ... The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-stored-procedures.html
Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create different kinds of stored routines. For the purposes of this tutorial, you will create a simple stored procedure to see ...Putting database-intensive operations into stored procedures lets you define an API for your database ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create different kinds of stored routines. For the purposes of this tutorial, you will create a simple stored procedure to see ...Putting database-intensive operations into stored procedures lets you define an API for your database ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%'; About Lakehouse Auto Parallel Load Schema Inference Lakehouse Auto Parallel Load includes schema inference, and uses it in one of two ways: Lakehouse Auto Parallel Load analyzes the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
For every major MySQL release, NL2ML creates a new vector store from the MySQL HeatWave User Guide documentation. After creating each new vector store, the old vector store gets deleted. Due to the creation of vector stores, some NL2ML calls may ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-bulk-ingest-feature.html
Do the following to bulk ingest data to a DB System: Create an IAM policy to access the Amazon S3 bucket. See Creating an IAM Policy to Access an Amazon S3 Bucket. Create an IAM role that grants the DB System access to read data from the desired ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-ibr-config-privatelink.html
Create an Egress PrivateLink in MySQL HeatWave on AWS and associate it with the VPC Endpoint Service and Egress Endpoints for your source database. Configuring Inbound Replication over an Egress PrivateLink 8.2.2 Configuring Inbound Replication ...