www.bortolotto.eu

Newsfeeds
Planet MySQL
Planet MySQL - https://planet.mysql.com

  • Row Deletion Jobs Done Right
    I am continuing my blog post series on using indexes — or tables — as queues.  In this post, I cover Row Deletion Jobs (I do not call these purge jobs, to avoid confusion with the InnoDB Purge).  Such jobs are tempting to implement using an index, but this might be a wrong / suboptimal way.  I write about the right / better / cheaper way

  • Designing Continuous Availability: Active-Active HA for MySQL HeatWave Lakehouse
    In traditional MySQL, analytics require data to be ingested into InnoDB tables and processed on a single primary instance using row-based storage engine and limited parallelism. Scaling analytical workloads typically involves replicas, ETL pipelines, or even external analytics system.  With MySQL HeatWave, Oracle’s fully managed service in the cloud, analytics execution is offloaded to a […]

  • Top Ways to Engage with the MySQL Community 
    As discussed in the earlier blog post A new Era of Community Engagement, there are many ways to connect with the MySQL Community.  MySQL Community: Ways to Learn, Connect, and Contribute (and See What’s Next)  MySQL is shaped by the people who use it—developers, DBAs, educators, user group leaders, and contributors around the world. The […]

  • Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)
    I am starting a blog post series on using indexes — or tables — as queues.  I had this series in the back of my mind for some time.  This started a few years back when I worked on optimizing a row deletion job (I do not call this a purge job, to avoid confusion with the InnoDB Purge).  Such jobs can be generalized to using indexes (or tables) as queues (this is

  • Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 
    This guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper functions, and unified tooling so the same logic works reliably even when multiple database engines run side by side. The post Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2  appeared first on Devart Blog.