Vultr Customer Portal

1. Navigate to Products and select Databases.
2. Click the target database instance.
3. Click Settings and select MySQL Configuration.
4. Then, navigate to Slow Query Logging.
5. Turn the feature to YES or NO and click Apply Changes.
6. If you turn the feature to YES specify a Long Query Time value in seconds. The minimum value is 10 seconds.

Vultr API

1. List all the database instances by sending a GET request to the List Managed Databases endpoint and note the database ID (For example, 43b4c774-5dff-4ac0-a01f-78a23c2205b5) and the active mysql_slow_query_log status.
   console

   $ curl "https://api.vultr.com/v2/databases" \
       -X GET \
       -H "Authorization: Bearer ${VULTR_API_KEY}"
   

2. Send a PUT request to the Update Managed Database endpoint and specify the database ID to change the mysql_slow_query_log status.
   console

   $ curl "https://api.vultr.com/v2/databases/database_id" \
       -X PUT \
       -H "Authorization: Bearer ${VULTR_API_KEY}" \
       -H "Content-Type: application/json" \
       --data '{
           "mysql_slow_query_log": false
       }'

Vultr CLI

1. List all database instances and note the database ID. For instance, d6ac2a3c-92ea-43ef-8185-71a23e58ad8c.
   console

   $ vultr-cli database list --summarize
   

2. Run the following command and specify a database ID to update mysql-slow-query-log and mysql-long-query-time.
   console

   $ vultr-cli database update database_id \
   --mysql-slow-query-log true \
   --mysql-long-query-time 20

Terraform

1. Open your Terraform configuration for the existing Managed Database for MySQL resource.
2. Add or update the mysql_slow_query_log and mysql_long_query_time arguments.
   terraform

   resource "vultr_database" "mysql" {
       # ...existing fields (database_engine, region, plan, label, etc.)
   
       mysql_slow_query_log = true
       mysql_long_query_time = 20
   }
   

3. Apply the configuration and observe the following output:

   Apply complete! Resources: 0 added, 1 changed, 0 destroyed.