Showing entries 1 to 10 of 44043
10 Older Entries »
New Monitoring Capabilities for MySQL in OCI Database Management

We're now expanding OCI Database Management capabilities with a new set of enhanced monitoring features - designed to reduce operational burden on DBAs and developers, strengthen observability, and support high availability across modern MySQL deployments.

MySQL: Release Notes Database

I’ve hacked together a horrible thing in Python, and made it available in mysql-release-notes

on GitHub.

It’s a Python project (done with uv) that downloads all MySQL release notes, dumps them into a release_notes folder, and then parses them, pushing everything into a database.

It uses SQLAlchemy and mysqlclient to connect to the database.

It generates a schema (not preserving any data), and fills it with all the release notes we have.

The schema is a simple star.

For each release, we have many issues, and for each issue we store a number of properties. Properties aren’t stored as plain text — they’re encoded, and we only keep the property ID.

Sample queries like

select t.contributor,
       min(r.release_date), min(r.version),
       max(r.release_date), max(r.version), …
[Read more]
HeatWave MySQL Database Audit

HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats, and maintain detailed records for regulatory requirements. The audit system is easy to set up, supports granular activity tracking, and provides actionable insights directly through the SQL interface.

The post HeatWave MySQL Database Audit first appeared on dasini.net - Diary of a MySQL expert.

MySQL Analysis: With an AI-Powered CLI Tool

MySQL Analysis: With an AI-Powered CLI Tool

As DBAs with MySQL we often live on a Linux terminal window. We also enjoy free options when available. This post shows an approach that allows us to stay on our terminal window and still use an AI-powered tool. You can update to use other direct AI providers but I set this example up to use aimlapi.com as it brings multiple AI models to your terminal for free with limited use or very low cost for more testing.

Note: I'm not a paid spokesperson for AIMLAPI or anything - this is just an easy example to highlight the idea.

The Problem

You're looking at a legacy database with hundreds of tables, each with complex relationships and questionable design decisions made years ago. The usual process involves:

  • Manual schema inspection
  • Cross-referencing documentation (if it exists)
  • Running multiple EXPLAIN queries
[Read more]
How to Use AI for MySQL: Optimizing Queries and Database Management 

Boost your MySQL performance with AI for MySQL. Learn how AI tools can optimize queries, enhance troubleshooting, and automate database management. Get started now!

The post How to Use AI for MySQL: Optimizing Queries and Database Management  appeared first on Devart Blog.

Register now for the MySQL Global Forum – a Free Virtual Event

Reflecting on 30 Years of MySQL and Looking Ahead

This year marks an incredible milestone as MySQL celebrates 30 years of powering applications worldwide! Whether you’re a long-time fan or just starting your journey, you’re invited to join the MySQL Global Forum a virtual event bringing together MySQL leaders, experts, and community members from around the globe.

Seamlessly connect to your HeatWave MySQL from VS Code using the MySQL Shell Extension

In the previous post, we explored how the MySQL Shell extension for Visual Studio Code brings database development directly into your editor. In this follow-up, we'll walk through how to connect to a HeatWave MySQL database which is hosted in the cloud on Oracle Cloud Infrastructure (OCI) and how to browse schemas and run queries, all without leaving VS Code. Here is an architecture diagram that gives an idea of how VS Code connects to the HeatWave MySQL DB system.

Fintech startups choose HeatWave MySQL

Fintech (financial technology) companies continue to disrupt the financial services industry. The technology they rely on is paramount; it often determines their ability to deliver an innovative solution exhibiting the performance, scalability, security, reliability, and cost-efficiency that will sway customers. Let’s consider in this blog why 3 fintech startups migrated to HeatWave MySQL, and the results they achieved.

MySQL Shell in VS Code: A Modern Way to Work with Your Data

Modern development demands tools that minimize context switching and improve efficiency. The MySQL Shell extension for Visual Studio Code makes that possible by bringing powerful database interaction directly into the developer's workspace. With seamless support for connecting, querying, and scripting in SQL, Javascript, and TypeScript - all inside the familiar VS Code environment - it helps developers stay focused and productive.

Track MySQL Table Activity: Know your Hot, Cold, and Static Tables

It's incredibly useful to know which tables in your MySQL databases are seeing active changes versus those tables that are more static. To do this, we need to examine DML (Data Manipulation Language) activity—specifically, updates, inserts, and deletes. MySQL offers various mechanisms to gather this information.

Showing entries 1 to 10 of 44043
10 Older Entries »