Planet MySQL https://planet.mysql.com Sun, 12 Apr 2026 17:42:17 +0000 en Planet MySQL - https://planet.mysql.com 50 SQL Interview Questions and Answers (2026 Advanced Edition) https://codeforgeek.com/?p=36360 https://codeforgeek.com/top-50-essential-sql-interview-questions-and-answers/ We understand that tackling SQL interviews can feel challenging, but with the right focus, you can master the required knowledge. Structured specifically for the 2026 job market, this comprehensive resource provides 50 real, frequently asked SQL interview questions covering everything from basic definitions and data manipulation to advanced analytical queries and performance optimisation. Section 1: SQL […] Fri, 10 Apr 2026 19:06:19 +0000 Shahid shaikh Mysql Celebrating 30 Years of MySQL: Free Training & Certification Results  7849fbd95af195174a092823ab04d41f https://blogs.oracle.com/mysql/celebrating-30-years-of-mysql-free-training-certification-results In 2025, MySQL celebrated its 30th anniversary—and to mark the milestone, Oracle University (together with the MySQL Community team) offered free MySQL training and free certification exams from April 20 through July 31, 2025.  The goal was simple: make it easy for developers, DBAs, architects, and newcomers to build practical skills and validate them with […] Wed, 08 Apr 2026 12:25:36 +0000 Oracle MySQL Group MySQL MySQL Community mysql mysqlcommunity Thanks AWS Open Source tag:blogger.com,1999:blog-9188714267863327820.post-6366517915152485539 https://jfg-mysql.blogspot.com/2026/04/thanks-aws-open-source.html I would like to thank AWS Open Source for their support. For some time, I am maintaining Planet for the MySQL Community, a blog / news aggregator for the MySQL Community/Ecosystem.  I am also maintaining a similar aggregator for the Valkey Community. Maintaining blog / news aggregators is not free.  It incurs hosting, domain registration, and other costs (in addition to time, Tue, 07 Apr 2026 20:11:00 +0000 Jean-François Gagné MySQL Planet MySQL Community Planet Valkey Community Valkey MySQL Tools for Performance Tuning and Test Data Generation https://kedar.nitty-witty.com/blog/?p=3560 https://kedar.nitty-witty.com/blog/mysql-tools-for-performance-tuning-and-test-data-generation?utm_source=rss&utm_medium=rss&utm_campaign=mysql-tools-for-performance-tuning-and-test-data-generation As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to… The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable. As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…

The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable.]]> Mon, 06 Apr 2026 14:00:00 +0000 Kedar Vaijanapurkar MySQL free MySQL tools generate test data MySQL MySQL advisor tool MySQL benchmarking tools MySQL configuration tuning MySQL DBA tools MySQL optimization tools MySQL performance analysis MySQL performance tuning MySQL query optimization MySQL random data How to fix write latency in MySQL 8.4 Upgrade https://kedar.nitty-witty.com/blog/?p=3575 https://kedar.nitty-witty.com/blog/how-to-fix-write-latency-in-mysql-8-4-upgrade?utm_source=rss&utm_medium=rss&utm_campaign=how-to-fix-write-latency-in-mysql-8-4-upgrade During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if… The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable. During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…

The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable.]]> Sat, 04 Apr 2026 17:01:09 +0000 Kedar Vaijanapurkar MySQL Technical innodb_change_buffering MySQL 8.0 to 8.4 MySQL 8.4 upgrade MySQL Best Practices MySQL configuration tuning MySQL latency MySQL upgrade MySQL upgrade issues MySQL write performance How to Enable MySQL HeatWave Telemetry and Analyze Logs with OCI Log Analytics 0368c0efc02779b1aeb52ae00e75fce1 https://blogs.oracle.com/mysql/how-to-enable-mysql-heatwave-telemetry-and-analyze-logs-with-oci-log-analytics MySQL HeatWave Service on Oracle Cloud Infrastructure (OCI) provides built-in telemetry and logging capabilities that help organizations monitor database activity, troubleshoot issues, and maintain operational health. These logs are valuable not only for operations and performance tuning, but also for governance and regulatory compliance, where audit logging can be essential for tracking database activity and […] Fri, 03 Apr 2026 18:06:32 +0000 Oracle MySQL Group MySQL Basics/How-To MySQL HeatWave log analytics monitoring mysql observability telemetry data troubleshooting Oracle Ignites AI Innovation at TEDAI San Francisco 83873bf560ade0cbc1f4266489993204 https://blogs.oracle.com/mysql/oracle-ignites-ai-innovation-at-tedai-san-francisco Oracle was proud to sponsor and participate in TEDAI San Francisco, a sold-out event that brought together over 1,200 attendees from across industries to explore, debate, and celebrate the transformative potential of artificial intelligence. Through a mix of key panels, a 48-hour hackathon, and thought leadership engagement, Oracle showcased its commitment to responsible AI innovation […] Thu, 02 Apr 2026 14:45:37 +0000 Oracle MySQL Group MySQL Community News GenAI mysql mysqlcommunity Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments https://www.percona.com/blog/?p=104715 https://www.percona.com/blog/benchmarking-myrocks-vs-innodb-in-memory-constrained-environments/ Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments It is a well-known fact in the database world that InnoDB is incredibly fast when the entire database fits into memory. But what happens when your data grows beyond your available RAM? MyRocks, built on RocksDB, is frequently recommended as a superior choice for environments constrained by memory, […] Wed, 01 Apr 2026 13:31:27 +0000 MySQL Performance Blog Benchmarks MySQL benchmark Benchmarking memory-constrained MyRocks Open Source Performance Introducing MySQL HeatWave Telemetry data with OCI Log Analytics 9959a555c90e73e13976ec0f91e551da https://blogs.oracle.com/mysql/introducing-mysql-heatwave-telemetry-data-with-oci-log-analytics Announcing MySQL HeatWave Telemetry data publishing into OCI Log Analytics — the easiest way to view , analyze the MYSQL Heatwave Logs New build-in feature to publish the MySQL Logs to OCI Log Analytics Telemetry Data: The Following data will be published based on the user selection1. Error log: Contains a record of mysqld startup and shutdown […] Tue, 31 Mar 2026 16:00:00 +0000 Oracle MySQL Group MySQL HeatWave News log analytics monitoring mysql observability telemetry data troubleshooting MyVector v1.26.3: Maintenance, CI, and Readiness for MySQL 9.7 http://askdba.net/?p=2772 https://askdba.net/2026/03/29/myvector-v1-26-3-maintenance-ci-and-readiness-for-mysql-9-7/ In my recent series on Scoped Vector Search, we looked at the query patterns that make vector search a first-class citizen in MySQL. While the logic for those searches is now established, the infrastructure supporting them requires constant attention as the MySQL ecosystem moves toward its new release model. Today, I’m announcing MyVector v1.26.3. This is a foundational release focused on environment compatibility and CI/CD robustness. What’s in v1.26.3? This release ensures that MyVector remains stable and buildable across the shifting landscape of MySQL Innovation and LTS releases. MySQL 8.4 & 9.6 Compatibility: We’ve updated the component sources and build logic to align with the headers and requirements for MySQL 8.4 (LTS) and the 9.6 Innovation release. Ready for 9.7: The build system has been adapted to handle the upcoming 9.7 release, ensuring that users can transition to the next Innovation branch without delay. Modernized Release Workflow: We’ve bumped our GitHub Actions (softprops/action-gh-release) from v1 to v2. While invisible to the user, this ensures our release pipeline remains secure and compatible with the latest GitHub runner environments. Think of v1.26.3 as the “maintenance and readiness” layer that ensures the high-performance HNSW search you rely on continues to compile and run perfectly on the newest versions of MySQL. Looking Ahead: The Architecture Pivot (PR #76) While v1.26.3 keeps us current, the real excitement is happening in the lab. There is a fundamental architecture change currently in development under Component migration (8.4–9.6) and release workflow update. Unlike the compatibility fixes in today’s release, PR #76 is a structural overhaul. We are re-engineering how the plugin interacts with the MySQL core. This shift is designed to move MyVector closer to a full Component Architecture, which will eventually offer better lifecycle management and even deeper integration with MySQL’s internal services. This is a significant pivot in how MyVector is built, and it will set the stage for the next generation of vector performance and observability. Summary v1.26.3 is the stable, verified update you need for today’s MySQL 8.4/9.6 environments and tomorrow’s 9.7 upgrade. Meanwhile, work continues on the architectural evolution that will define the future of the project. Download the Release: v1.26.3 on GitHub Watch the Evolution: Component migration (8.4–9.6) and release workflow update

In my recent series on Scoped Vector Search, we looked at the query patterns that make vector search a first-class citizen in MySQL. While the logic for those searches is now established, the infrastructure supporting them requires constant attention as the MySQL ecosystem moves toward its new release model.

Today, I’m announcing MyVector v1.26.3. This is a foundational release focused on environment compatibility and CI/CD robustness.

What’s in v1.26.3?

This release ensures that MyVector remains stable and buildable across the shifting landscape of MySQL Innovation and LTS releases.

  • MySQL 8.4 & 9.6 Compatibility: We’ve updated the component sources and build logic to align with the headers and requirements for MySQL 8.4 (LTS) and the 9.6 Innovation release.
  • Ready for 9.7: The build system has been adapted to handle the upcoming 9.7 release, ensuring that users can transition to the next Innovation branch without delay.
  • Modernized Release Workflow: We’ve bumped our GitHub Actions (softprops/action-gh-release) from v1 to v2. While invisible to the user, this ensures our release pipeline remains secure and compatible with the latest GitHub runner environments.

Think of v1.26.3 as the “maintenance and readiness” layer that ensures the high-performance HNSW search you rely on continues to compile and run perfectly on the newest versions of MySQL.

Looking Ahead: The Architecture Pivot (PR #76)

While v1.26.3 keeps us current, the real excitement is happening in the lab.

There is a fundamental architecture change currently in development under Component migration (8.4–9.6) and release workflow update.

Unlike the compatibility fixes in today’s release, PR #76 is a structural overhaul. We are re-engineering how the plugin interacts with the MySQL core. This shift is designed to move MyVector closer to a full Component Architecture, which will eventually offer better lifecycle management and even deeper integration with MySQL’s internal services.

This is a significant pivot in how MyVector is built, and it will set the stage for the next generation of vector performance and observability.

Summary

v1.26.3 is the stable, verified update you need for today’s MySQL 8.4/9.6 environments and tomorrow’s 9.7 upgrade. Meanwhile, work continues on the architectural evolution that will define the future of the project.

]]> Sun, 29 Mar 2026 18:38:59 +0000 Alkin Tezuysal mysql Technical ai artificial-intelligence llm myvector rag technology MySQL HeatWave observability updates in OCI 805b900d19b8968f26139f09c1f07514 https://blogs.oracle.com/mysql/mysql-heatwave-observability-updates-in-oci Moving from Ops Insights/Database Management to OCI Monitoring and Unified Log Analytics OCI is updating the recommended approach for observing MySQL HeatWave. This includes changes to existing integrations, along with a path forward that provides stronger log analytics and AI-assisted analysis—while continuing to use OCI Monitoring as the foundational layer for metrics and alarms. What’s […] Fri, 27 Mar 2026 20:36:18 +0000 Oracle MySQL Group MySQL Community MySQL HeatWave log analytics monitoring OCI Binary Log Compression is Safe since MySQL 8.0.34 tag:blogger.com,1999:blog-9188714267863327820.post-8638821240123831146 https://jfg-mysql.blogspot.com/2026/03/binlog-compression-now-safe.html This is a quick one.  My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet : The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would Thu, 26 Mar 2026 20:41:00 +0000 Jean-François Gagné Binary Logs Bug Documentation Bugs MySQL 8.0 Replication Replication Breakage Understanding MySQL Views & HeatWave In-Memory Execution b3a6234e2675eedae8858cefcea68dd5 https://blogs.oracle.com/mysql/understanding-mysql-views-heatwave-in-memory-execution In the world of database management, MySQL HeatWave offers powerful in-memory analytics capabilities that can supercharge your OLTP queries. But what happens when you introduce views into the mix? A common question I get is: “If I create a view in MySQL, does this view run against the data stored in the tables in HeatWave […] Thu, 26 Mar 2026 17:56:32 +0000 Oracle MySQL Group MySQL MySQL HeatWave Unified MySQL Monitoring Across HeatWave and On-Prem with Grafana Dashboard ed064c3202a8cc77a349dcdecfb1b796 https://blogs.oracle.com/mysql/unified-mysql-monitoring-across-heatwave-and-on-prem-with-grafana-dashboard MySQL observability is essential in modern enterprises, whether you run a few critical databases or operate at massive scale. With the right real‑time monitoring, teams reduce MTTD/MTTR, avoid cascading failures, and continuously track workload health—CPU, memory, I/O, buffer pool efficiency, session contention, transaction/replication lag, error rates, and query latency. This Grafana monitoring template helps teams […] Thu, 26 Mar 2026 15:32:01 +0000 Oracle MySQL Group MySQL Community MySQL Enterprise MySQL HeatWave heatwave mysql mysqlcommunity OCI Strengthening the MySQL Community: Highlights from Our Second Public Discussion 05edab2056b9b8d1919809e6415b9afe https://blogs.oracle.com/mysql/strengthening-the-mysql-community-highlights-from-our-second-public-discussion On March 23, 2026, the MySQL Community Team hosted our second public discussion focused on shaping a new era of MySQL community engagement. With over 50 attendees participating, the session brought together members of the MySQL ecosystem to share feedback, discuss priorities, and help guide future efforts. Building on our earlier session, this webinar continued […] Thu, 26 Mar 2026 06:00:00 +0000 Oracle MySQL Group MySQL MySQL Community mysql mysqlcommunity MysqlCommunity mysql MySQL Early Access Release Builds Available: What to Test and How to Share Feedback   2721c5310bcf5f19d2bf8d6166576659 https://blogs.oracle.com/mysql/mysql-early-access-release-builds-available-what-to-test-and-how-to-share-feedback Last week, we published MySQL Early Access Release builds available for community testing and feedback ahead of the upcoming stable releases. Early Access builds are ideal for developers and DBAs who want to validate compatibility, behavior, and performance in non-production environments—and help us catch regressions early or identify areas where the documentation could be clearer. We […] Tue, 24 Mar 2026 18:06:53 +0000 Oracle MySQL Group MySQL MySQL Community News 10 Simple Steps to Solve SQL Problems [2026] https://codeforgeek.com/?p=37051 https://codeforgeek.com/10-steps-to-solve-sql-problems/ If you find yourself getting confused or going blank while working on SQL questions, we have found 10 simple steps/methods to solve SQL problems with ease. In our previous tutorials in this SQL series, we have already covered: 150+ SQL Commands Explained With Examples to help you understand every major SQL command100 SQL MCQ Tests […] Tue, 24 Mar 2026 11:38:05 +0000 Shahid shaikh Mysql Continued Momentum Leading up to MySQL Community Edition Release 36631471413a0d4685f26d3219a5bc83 https://blogs.oracle.com/mysql/continued-momentum-leading-up-to-mysql-community-edition-release More MySQL Worklogs and MySQL Developer Guide published As we ramp up to the MySQL Community Edition release in April, and as part of your our updated community engagement approach (see: A New Era of MySQL Community Engagement), we are announcing more MySQL worklogs, a MySQL Developer Guide and a reminder to please provide feedback […] Fri, 20 Mar 2026 16:11:30 +0000 Oracle MySQL Group MySQL MySQL Community News Where can you find MySQL next? (Updated events list for March–May 2026) 24c832e631e8d543b5ee96cacb89cb90 https://blogs.oracle.com/mysql/where-can-you-find-mysql-next-updated-events-list-for-march-may-2026 As a follow-up to our previous blog post, “Where can you find MySQL during January to April 2026” (published at the end of January 2026), we would like to share an update. With the dynamic nature of event planning, we have slightly adjusted our plans—both for in-person conferences and for online sessions—so you always have […] Wed, 18 Mar 2026 11:59:03 +0000 Oracle MySQL Group MySQL MySQL Community How to install MySQL on Ubuntu 26.04 https://www.rosehosting.com/blog/?p=51536 https://www.rosehosting.com/blog/how-to-install-mysql-on-ubuntu-26-04/ In this blog post, we will show you how to install MySQL server on Ubuntu 26.04. MySQL is a very ... Read More The post How to install MySQL on Ubuntu 26.04 appeared first on RoseHosting. In this blog post, we will show you how to install MySQL server on Ubuntu 26.04. MySQL is a very ...

Read More

The post How to install MySQL on Ubuntu 26.04 appeared first on RoseHosting.

]]> Mon, 16 Mar 2026 17:30:00 +0000 RoseHosting Ubuntu how to install mysql ubuntu 26.04 Mapping your data to file(s) in your Lakehouse table 645aa88396ad5177ea7f8e4581f23869 https://blogs.oracle.com/mysql/mapping-your-data-to-files-in-your-lakehouse-table MySQL HeatWave is a fully-managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Introduction In the 9.6.1 release of MySQL HeatWave, Lakehouse now supports the _metadata_filename column […] Fri, 13 Mar 2026 15:59:33 +0000 Oracle MySQL Group MySQL HeatWave heatwave Lakehouse mysql MySQL Community Early Access Builds 8a9dddddd993da6c28a7cfb8c54ca633 https://blogs.oracle.com/mysql/mysql-community-early-access-builds MySQL benefits from a large and technically rigorous community—people who run MySQL at scale, test it in diverse environments, and surface issues (and ideas) that make the product better. Over the last year, we’ve been listening to community feedback and, since January 2026, sharing our updated community engagement approach (see: A New Era of MySQL Community […] Fri, 13 Mar 2026 14:44:31 +0000 Oracle MySQL Group MySQL Community News