# MySQL

MySQL is an open-source relational SQL database management system.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## CVE-2026-133476 - Dolibarr SQL Injection Vulnerability

DevFeed: [CVE-2026-133476 - Dolibarr SQL Injection Vulnerability](<https://devfeed.tech/articles/cve-2026-133476-dolibarr-sql-injection-vulnerability-144403.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-133476>)

Author: CVEFEED.io

Published: 2026-11-19T21:27:43Z

Content type: news

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [account takeover](<https://devfeed.tech/topics/account-takeover.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [account](<https://devfeed.tech/tags/account.md>), [account-takeover](<https://devfeed.tech/tags/account-takeover.md>), [administrator](<https://devfeed.tech/tags/administrator.md>), [api](<https://devfeed.tech/tags/api.md>), [api-key](<https://devfeed.tech/tags/api-key.md>), [application](<https://devfeed.tech/tags/application.md>), [bearer](<https://devfeed.tech/tags/bearer.md>), [boolean](<https://devfeed.tech/tags/boolean.md>), [column](<https://devfeed.tech/tags/column.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-133476](<https://devfeed.tech/tags/cve-2026-133476.md>), [dolibarr](<https://devfeed.tech/tags/dolibarr.md>), [dolibarr-erp-crm](<https://devfeed.tech/tags/dolibarr-erp-crm.md>), [erp-crm](<https://devfeed.tech/tags/erp-crm.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [pass](<https://devfeed.tech/tags/pass.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>)

### AI overview

In Dolibarr versions before 24.0.3, dolForgeSQLCriteriaCallback() checks Universal Search Filter fields after removing only one table prefix. MariaDB and MySQL accept deeper qualification, so a field such as dolibarr.u.pass_crypted can bypass the denylist and reach the SQL WHERE clause. An authenticated user with only holiday read and readall permissions can reportedly exploit the holidays API as a boolean oracle to recover users' bcrypt password hashes and API keys character by character. Since the REST API accepts api_key as a bearer credential, the report says this can enable administrator control. The issue also bypasses CVE-2026-89012's case-normalization fix; the denylist additionally omits pass_temp and several personal or sensitive fields. The excerpt does not identify affected versions beyond "before 24.0.3" or provide mitigation steps.

### Source excerpt

CVE ID :CVE-2026-133476 Published : Nov. 19, 2026, 9:27 p.m. | 41 minutes ago Description :In Dolibarr before 24.0.3, dolForgeSQLCriteriaCallback() in htdocs/core/lib/functions.lib.php allows account takeover because it strips only a single table-name prefix from a Universal Search Filter (sqlfilters) operand before checking it against the forbidden-field denylist (pass, pass_crypted, api_key). MariaDB and MySQL accept a two-level qualification such as schema.alias.column, so an operand of the form dolibarr.u.pass_crypted survives the check and is emitted into the WHERE clause. A remote authenticated user holding only the holiday read and readall permissions, which confer no user-management or administrative access, can use the resulting boolean oracle at GET /api/index.php/holidays to recover any user's bcrypt password hash and api_key one character at a time, including an administrator's. Because api_key is accepted directly by the REST API as a bearer credential, this yields full administrative control of the application. This bypasses the fix for CVE-2026-89012, which added only a strtolower() call and did not address prefix depth. The same denylist also omits pass_temp, which stores a password in cleartext, as well as national_registration_number, salary, birth, address, personal_mobile and note_private. Severity: 8.8 | HIGH Visit the link for more details, such as CVSS details, affected products, timeline, and more...

## Researcher Demonstrates Database RCE Exploits Affecting PostgreSQL, MySQL and Oracle

DevFeed: [Researcher Demonstrates Database RCE Exploits Affecting PostgreSQL, MySQL and Oracle](<https://devfeed.tech/articles/researcher-demonstrates-database-rce-exploits-affecting-postgresql-mysql-and-oracle-142875.md>)

Original publisher: [Read original article](<https://thehackernews.com/2026/11/researcher-demonstrates-database-rce.html>)

Author: The Hacker News

Published: 2026-11-19T08:14:00Z

Content type: news

Language: en

Sources: [Cyber Newsroom](<https://devfeed.tech/sources/cyber-newsroom.md>)

Topics: [Memory Safety](<https://devfeed.tech/topics/memory-safety.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [application](<https://devfeed.tech/tags/application.md>), [bugs](<https://devfeed.tech/tags/bugs.md>), [can](<https://devfeed.tech/tags/can.md>), [code](<https://devfeed.tech/tags/code.md>), [corruption](<https://devfeed.tech/tags/corruption.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-116331](<https://devfeed.tech/tags/cve-2026-116331.md>), [database](<https://devfeed.tech/tags/database.md>), [database-security](<https://devfeed.tech/tags/database-security.md>), [exploits](<https://devfeed.tech/tags/exploits.md>), [memory](<https://devfeed.tech/tags/memory.md>), [memory-corruption](<https://devfeed.tech/tags/memory-corruption.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rce](<https://devfeed.tech/tags/rce.md>), [remote-code-execution](<https://devfeed.tech/tags/remote-code-execution.md>), [run](<https://devfeed.tech/tags/run.md>), [server](<https://devfeed.tech/tags/server.md>), [software-security](<https://devfeed.tech/tags/software-security.md>), [table](<https://devfeed.tech/tags/table.md>), [this](<https://devfeed.tech/tags/this.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>)

### AI overview

The researcher's proofs of concept show that limited SQL access can reach memory-unsafe database engine code and lead to server-side code execution, even without access to application tables. PostgreSQL and MySQL attacks use accounts allowed to create temporary objects; the PostgreSQL flaw was fixed, and MySQL's CVE affects Server and Cluster 26.7.0-26.7.1. The Oracle chain is distinct: it combines Oracle Text and Oracle REST Data Services flaws to reach an exposed endpoint without a login; both components have been patched. ClickHouse's reported binary-row-format overflow is triggered by setting `format_binary_max_string_size` to zero; the excerpt gives no CVE or confirmed fix. The researcher reports no known real-world attacks, and the full chains were not independently reproduced. The excerpt recommends installing updates and reviewing temporary-object privileges; that does not address Oracle's no-login path.

### Source excerpt

Researcher Demonstrates Database RCE Exploits Affecting PostgreSQL, MySQL and Oracle Low-privilege database accounts that cannot read a single application table can still be used to run code on the database server itself, a researcher has shown, by reaching memory-corruption bugs in t ... Read more Published Date: Nov 19, 2026 (2 hours, 45 minutes ago) Vulnerabilities has been mentioned in this article. CVE-2026-114819 CVE-2026-116331 CVE-2026-118383 CVE-2026-91609 CVE-2026-101786

## Amazon RDS for MySQL LTS version 9.7 is now generally available

DevFeed: [Amazon RDS for MySQL LTS version 9.7 is now generally available](<https://devfeed.tech/articles/amazon-rds-for-mysql-lts-version-9-7-is-now-generally-available-141384.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/amazon-rds-for-mysql-lts-version-9-7-is-now-generally-available/>)

Author: Sabalesh Mahajan

Published: 2026-11-18T20:52:19Z

Content type: release

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Deployment Strategies](<https://devfeed.tech/topics/deployment-strategies.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [zero downtime deployment](<https://devfeed.tech/topics/zero-downtime-deployment.md>), [mysql group replication](<https://devfeed.tech/topics/mysql-group-replication.md>)

Tags: [active-active](<https://devfeed.tech/tags/active-active.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-relational-database-service](<https://devfeed.tech/tags/amazon-relational-database-service.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [automation](<https://devfeed.tech/tags/automation.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-database-migration-service](<https://devfeed.tech/tags/aws-database-migration-service.md>), [blue-green-deployment](<https://devfeed.tech/tags/blue-green-deployment.md>), [buffer-pool](<https://devfeed.tech/tags/buffer-pool.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [cdc](<https://devfeed.tech/tags/cdc.md>), [cdc-tools](<https://devfeed.tech/tags/cdc-tools.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [checklist](<https://devfeed.tech/tags/checklist.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [lts](<https://devfeed.tech/tags/lts.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [rds](<https://devfeed.tech/tags/rds.md>), [rds-for-mysql](<https://devfeed.tech/tags/rds-for-mysql.md>)

### AI overview

Amazon RDS for MySQL 9.7 is generally available as the community's latest LTS version. Upgrade from 8.4 directly to 9.7; MySQL 8.0 must first move to 8.4, and 5.7 requires staged upgrades through 8.0 and 8.4. The post recommends Blue/Green deployments to test compatibility before promotion. Before upgrading, address key changes: `rdsproxyadmin` is reserved; `mysql_native_password`, `MD5()` and `SHA1()` are unavailable; TLS is required by default; password validation moves to renamed component settings; and `EXPLAIN` defaults to TREE format. RDS 9.7 uses `gtid_mode=ON_PERMISSIVE`, so outbound replicas must be at least `OFF_PERMISSIVE`. Multi-AZ DB clusters with two readable standbys are unsupported at launch. New capabilities include opt-in Hypergraph optimization, JSON Duality Views and Group Replication components for metrics, flow control, member recovery and primary election.

### Source excerpt

Amazon RDS for MySQL now supports MySQL 9.7, the latest community LTS version, alongside 8.0 and 8.4. This post covers what's new in 9.7, the key breaking changes, and how to upgrade safely from MySQL 8.4 using Amazon RDS Blue/Green deployments.

## Fix Amazon Aurora MySQL error 63955: Virtual index ID overflow

DevFeed: [Fix Amazon Aurora MySQL error 63955: Virtual index ID overflow](<https://devfeed.tech/articles/fix-amazon-aurora-mysql-error-63955-virtual-index-id-overflow-133436.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/fix-amazon-aurora-mysql-error-63955-virtual-index-id-overflow/>)

Author: Kartik Saini

Published: 2026-11-13T21:10:28Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Elastic Block Store (Amazon EBS)](<https://devfeed.tech/topics/amazon-elastic-block-store-amazon-ebs.md>), [TTL in DNS](<https://devfeed.tech/topics/ttl-in-dns.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [backups](<https://devfeed.tech/tags/backups.md>), [dump](<https://devfeed.tech/tags/dump.md>), [error](<https://devfeed.tech/tags/error.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [index](<https://devfeed.tech/tags/index.md>), [limit](<https://devfeed.tech/tags/limit.md>), [logical](<https://devfeed.tech/tags/logical.md>), [migration](<https://devfeed.tech/tags/migration.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [rebuild](<https://devfeed.tech/tags/rebuild.md>), [restore](<https://devfeed.tech/tags/restore.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [virtual](<https://devfeed.tech/tags/virtual.md>)

### AI overview

Aurora MySQL error 63955 means the cluster has exhausted virtual index IDs: indexes containing virtual columns--including functional and multi-valued indexes--fail, while existing data and ordinary indexes remain usable. Changing a generated column to STORED can unblock that particular index, but does not reset the IDs. The documented fix is a logical dump and restore; snapshots, clones, point-in-time recovery, and Blue/Green deployments copy physical structures and do not clear the condition. The described migration uses a clone, binary log replication, MyDumper/MyLoader, and a new Aurora MySQL 3.10.0-or-later cluster. It requires planning for a source reboot to enable binary logging, preserving the clone's source log position, migrating users and grants separately, validating the restore, and limiting rollback because schema changes can break reverse replication. On 3.10.0 or later, monitor the error log for VIRTUAL_INDEX_ID_OVERFLOW_WARNING; it is the only stated advance signal.

### Source excerpt

An Amazon Aurora MySQL cluster can exhaust its virtual index ID limit, after which any CREATE INDEX that includes a virtual column fails with error 63955 until you rebuild the databases. This post shows how to recognize the error, why backups cannot clear it, and how to run a logical dump-and-restore migration with monitoring to catch it next time.

## Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management

DevFeed: [Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management](<https://devfeed.tech/articles/introducing-percona-database-service-pds-an-experiment-in-simplifying-database-management-131068.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-database-service-pds/>)

Author: Andrey Glazkov

Published: 2026-11-12T16:43:13Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [self-service](<https://devfeed.tech/topics/self-service.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [AI Integration Strategies](<https://devfeed.tech/topics/ai-integration-strategies.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [access-controls](<https://devfeed.tech/tags/access-controls.md>), [account](<https://devfeed.tech/tags/account.md>), [actions](<https://devfeed.tech/tags/actions.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-assistant](<https://devfeed.tech/tags/ai-assistant.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-eks](<https://devfeed.tech/tags/amazon-eks.md>), [amazon-elastic-kubernetes-service](<https://devfeed.tech/tags/amazon-elastic-kubernetes-service.md>), [application](<https://devfeed.tech/tags/application.md>), [database](<https://devfeed.tech/tags/database.md>), [database-management](<https://devfeed.tech/tags/database-management.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [developer](<https://devfeed.tech/tags/developer.md>), [environment](<https://devfeed.tech/tags/environment.md>), [experiment](<https://devfeed.tech/tags/experiment.md>), [management](<https://devfeed.tech/tags/management.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-announcements](<https://devfeed.tech/tags/percona-announcements.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prototype](<https://devfeed.tech/tags/prototype.md>), [service](<https://devfeed.tech/tags/service.md>)

### AI overview

Percona Database Service (PDS) is an experimental centralized platform for provisioning and managing MySQL and PostgreSQL on Kubernetes while databases remain in the customer's AWS account. Built on OpenEverest, its current setup connects an EKS environment to a control plane; a generated local command can create a four-node cluster and S3 bucket or reuse an existing PDS installation. Database creation uses Dev, Staging, and Prod profiles, with high availability enabled from Staging onward. Public access adds a provider-billed load balancer and requires an IP or CIDR allowlist. The interface supports status and basic metrics, scaling, scheduled or on-demand backups, and activity history; PMM integration adds deeper performance diagnostics. Teams, users, and invitations provide initial shared management, while finer governance controls remain under development. AI clients such as Cursor and Claude can be connected through separate browser authentication and configurable permissions, including distinct authorization for deletion or restoration. PDS is an early preview whose capabilities may change.

### Source excerpt

It's Thursday afternoon, and a developer has an idea. Nothing complicated. They are working on a new application feature and want to test an idea before committing to a larger implementation. A quick prototype is already running locally. So far, so good. Next, they want to deploy the application to a shared environment so their ... Continued The post Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management appeared first on Percona.

## Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test

DevFeed: [Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test](<https://devfeed.tech/articles/inside-an-openeverest-mysql-cluster-galera-health-and-a-live-failover-test-131066.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/inside-an-openeverest-mysql-cluster-galera-health-and-a-live-failover-test/>)

Author: Arunjith Aravindan

Published: 2026-11-12T03:51:17Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [health check](<https://devfeed.tech/topics/health-check.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [Logging and metrics](<https://devfeed.tech/topics/logging-and-metrics.md>), [container-networking](<https://devfeed.tech/topics/container-networking.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [created](<https://devfeed.tech/tags/created.md>), [data](<https://devfeed.tech/tags/data.md>), [data-loss](<https://devfeed.tech/tags/data-loss.md>), [failover](<https://devfeed.tech/tags/failover.md>), [first](<https://devfeed.tech/tags/first.md>), [galera](<https://devfeed.tech/tags/galera.md>), [health](<https://devfeed.tech/tags/health.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [inside](<https://devfeed.tech/tags/inside.md>), [k3s](<https://devfeed.tech/tags/k3s.md>), [live](<https://devfeed.tech/tags/live.md>), [look](<https://devfeed.tech/tags/look.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [node](<https://devfeed.tech/tags/node.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [test](<https://devfeed.tech/tags/test.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

The excerpt reports a three-node Percona XtraDB Cluster managed by OpenEverest. Galera health is checked through wsrep status: healthy nodes were Synced and Primary, with cluster size three and matching last-committed values. In a live test, deleting the writer pod shifted new one-second inserts through HAProxy to another node with no failed writes; after rejoining, the original writer became preferred again. It caught up via IST from a donor's gcache in about 0.2 seconds. All three nodes ended with 1,007 rows and matching checksums. The test depended on short, newly opened connections: existing connections close and uncommitted transactions are lost, so applications need reconnect-and-retry logic. With local-path storage, the pod must return to the node holding its volume; loss of that volume would require SST. The excerpt also cautions against taking two of three nodes offline because the remaining node loses quorum.

### Source excerpt

Part 2 of 2: Reading wsrep status, killing the writer, and proving zero data loss In Part 1 we built a 3-node K3s cluster, installed OpenEverest, and created a 3-node Percona XtraDB Cluster (PXC) named mysql-vjg. In this post we look inside that cluster. Section A explains how to read Galera's wsrep_* status variables, so ... Continued The post Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test appeared first on Percona.

## Help prevent out-of-memory restarts on Aurora MySQL 8.4

DevFeed: [Help prevent out-of-memory restarts on Aurora MySQL 8.4](<https://devfeed.tech/articles/help-prevent-out-of-memory-restarts-on-aurora-mysql-8-4-129584.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/help-prevent-out-of-memory-restarts-on-aurora-mysql-8-4/>)

Author: Aayushi Mittal

Published: 2026-11-11T16:51:16Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [memory handling](<https://devfeed.tech/topics/memory-handling.md>)

Tags: [1-3](<https://devfeed.tech/tags/1-3.md>), [2](<https://devfeed.tech/tags/2.md>), [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [control](<https://devfeed.tech/tags/control.md>), [event](<https://devfeed.tech/tags/event.md>), [help](<https://devfeed.tech/tags/help.md>), [learn](<https://devfeed.tech/tags/learn.md>), [management](<https://devfeed.tech/tags/management.md>), [memory](<https://devfeed.tech/tags/memory.md>), [memory-management](<https://devfeed.tech/tags/memory-management.md>), [memory-pressure](<https://devfeed.tech/tags/memory-pressure.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oom](<https://devfeed.tech/tags/oom.md>), [out-of-memory](<https://devfeed.tech/tags/out-of-memory.md>), [prevent](<https://devfeed.tech/tags/prevent.md>), [protection](<https://devfeed.tech/tags/protection.md>), [take](<https://devfeed.tech/tags/take.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

Aurora MySQL 8.4 enables automatic memory management by default to respond to memory pressure before the operating system kills `mysqld` and restarts the cluster. The article shows how to monitor `AuroraMemoryHealthState`, recovery status and CloudWatch counters, then use error logs and Performance Schema to identify whether connection buffers, temporary tables or another consumer is driving pressure. In its test, Aurora shed work with query declines and connection terminations while keeping the database up; disabling protection led to an OOM restart. The article recommends keeping automatic management on for most 8.4 workloads and alerting on sustained memory-health values above zero. Manual control requires explicitly setting `aurora_oom_response` on 8.4, where it is empty by default when automatic management is off; some actions have pairing or deployment limits. Serverless v2 scales capacity before terminating connections and does not support `tune` or `tune_buffer_pool`. Applications should handle error 1041.

### Source excerpt

Out-of-memory restarts drop every connection and force an Aurora MySQL cluster restart. Learn how Aurora MySQL 8.4's automatic memory management prevents them: confirm protection is active, read the signals during a memory-pressure event, monitor OOM avoidance with CloudWatch, and decide when to take manual control.

## Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights

DevFeed: [Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights](<https://devfeed.tech/articles/diagnose-amazon-aurora-mysql-performance-using-cloudwatch-database-insights-129583.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/diagnose-amazon-aurora-mysql-performance-using-cloudwatch-database-insights/>)

Author: Aayushi Mittal

Published: 2026-11-11T16:46:38Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [database](<https://devfeed.tech/tags/database.md>), [diagnose](<https://devfeed.tech/tags/diagnose.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-performance](<https://devfeed.tech/tags/mysql-performance.md>), [performance](<https://devfeed.tech/tags/performance.md>)

### AI overview

CloudWatch Database Insights represents database activity as average active sessions (DB load), plots it against Max vCPU, and breaks it down by wait event and top SQL. Sustained load above capacity suggests queuing, though lock waits can stall work even below that line. The article recommends tracing dominant waits to correlated SQL before changing the system: tune CPU-heavy queries; use EXPLAIN and indexes for table reads; batch Aurora redo-log writes; reduce hot-key contention and transaction length for SYNCH waits; use connection pooling for connection churn; and limit or paginate results when client-return waits dominate. Scaling or Aurora replicas are options when CPU remains the bottleneck after tuning. Standard mode provides per-instance views and seven days of history; Advanced mode adds fleet monitoring and past-period analysis, with additional cost. Fleet triage ranks instances by load before drilling into waits and SQL.

### Source excerpt

When an Aurora MySQL or Amazon RDS for MySQL database slows down, it can be hard to tell why. This post shows how to read DB load in Amazon CloudWatch Database Insights, interpret the most common MySQL wait events, and turn each into a concrete action, so you can fix the real bottleneck instead of scaling up to a larger instance.

## Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL

DevFeed: [Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL](<https://devfeed.tech/articles/heavy-mysql-reports-in-seconds-open-source-htap-with-dbtrail-and-percona-server-for-mysql-127457.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/heavy-mysql-reports-in-seconds-open-source-htap-with-dbtrail-and-percona-server-for-mysql/>)

Author: Vadim Tkachenko

Published: 2026-11-10T21:04:03Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [column](<https://devfeed.tech/tags/column.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [docker](<https://devfeed.tech/tags/docker.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [hammerdb](<https://devfeed.tech/tags/hammerdb.md>), [history](<https://devfeed.tech/tags/history.md>), [htap](<https://devfeed.tech/tags/htap.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [reports](<https://devfeed.tech/tags/reports.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

In a DBTrail project benchmark, 12 of 14 analytical reports ran faster on DBTrail's columnar copy than on a Percona Server for MySQL replica; the slowest fell from 225 seconds to 7.94 seconds, while the two lightest reports favored Percona Server. Across 4,436 paired rounds, the copy was 6.5x faster by geometric mean, but it lagged the source by one to five minutes. DBTrail follows the database and uses query plans to route most SELECTs between the server and its copy without requiring rewritten or tagged queries. Its read-only port can be paired with ProxySQL to send writes and transactions to the source. In a separate MariaDB workload test with reports running alongside 400 transactions per second, routing through DBTrail kept p95 latency near 13 ms versus 6,960 ms with reports on the database, and 22x more reports completed. These are project-run results on specific workloads; the excerpt recommends benchmarking one's own reports.

### Source excerpt

In Part 1 we ran analytical reports in DuckDB on a DBTrail copy instead of on MySQL. This time I want to look at a different question: what if the application does not need to know the copy exists? Most MySQL servers have a few queries that make someone wait. The monthly report that aggregates ... Continued The post Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL appeared first on Percona.

## Introduction to Python SQL Libraries

DevFeed: [Introduction to Python SQL Libraries](<https://devfeed.tech/articles/introduction-to-python-sql-libraries-121711.md>)

Original publisher: [Read original article](<https://realpython.com/python-sql-libraries/>)

Author: Usman Malik

Published: 2026-11-06T14:00:00Z

Content type: tutorial

Language: en

Sources: [Real Python](<https://devfeed.tech/sources/real-python.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>)

Tags: [17](<https://devfeed.tech/tags/17.md>), [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [about](<https://devfeed.tech/tags/about.md>), [addition](<https://devfeed.tech/tags/addition.md>), [all](<https://devfeed.tech/tags/all.md>), [also](<https://devfeed.tech/tags/also.md>), [application](<https://devfeed.tech/tags/application.md>), [connect](<https://devfeed.tech/tags/connect.md>), [databases](<https://devfeed.tech/tags/databases.md>), [introduction](<https://devfeed.tech/tags/introduction.md>), [libraries](<https://devfeed.tech/tags/libraries.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [queries](<https://devfeed.tech/tags/queries.md>), [run](<https://devfeed.tech/tags/run.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

The tutorial builds a small social media database in SQLite, MySQL, and PostgreSQL using Python, then demonstrates table creation and common insert, select, update, and delete queries. SQLite uses the built-in `sqlite3` module and creates a database file when connecting to a path. MySQL requires a third-party driver such as `mysql-connector-python`; creating a database takes a separate server connection and `CREATE DATABASE` query. PostgreSQL uses `psycopg2` (the text says Psycopg 3 may suit new projects) and likewise requires creating the database before connecting to it. Query execution generally uses cursors; MySQL examples show both SQL strings and `executemany()` with placeholders, while the PostgreSQL examples pass placeholder-based records to `execute()`. The tutorial notes database-specific syntax for auto-incrementing IDs and foreign keys, and uses `fetchall()` to read rows and joins across related tables. MySQL and PostgreSQL servers must be running to follow those sections.

### Source excerpt

Connect to SQLite, MySQL, and PostgreSQL databases with Python SQL libraries, then run common queries from a single Python application.

## Fix One, Miss Another: Leveraging Historical Bug Fixes to Uncover Residual Bugs in Database Systems

DevFeed: [Fix One, Miss Another: Leveraging Historical Bug Fixes to Uncover Residual Bugs in Database Systems](<https://devfeed.tech/articles/fix-one-miss-another-leveraging-historical-bug-fixes-to-uncover-residual-bugs-in-database-systems-120821.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.07739>)

Author: Yankai Rong, Zhaoyang Zhang, Shuang Liu, Wei Lu, Xiaoyong Du

Published: 2026-11-06T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Software Engineering](<https://devfeed.tech/sources/arxiv-software-engineering.md>)

Topics: [bugfixes](<https://devfeed.tech/topics/bugfixes.md>), [Test automation](<https://devfeed.tech/topics/test-automation.md>), [Vulnerabilities](<https://devfeed.tech/topics/vulnerabilities.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [CockroachDB](<https://devfeed.tech/topics/cockroachdb.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>)

Tags: [bug](<https://devfeed.tech/tags/bug.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [bugs](<https://devfeed.tech/tags/bugs.md>), [cockroachdb](<https://devfeed.tech/tags/cockroachdb.md>), [cs-se](<https://devfeed.tech/tags/cs-se.md>), [database](<https://devfeed.tech/tags/database.md>), [database-management](<https://devfeed.tech/tags/database-management.md>), [grammar](<https://devfeed.tech/tags/grammar.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [systems](<https://devfeed.tech/tags/systems.md>), [test](<https://devfeed.tech/tags/test.md>), [tests](<https://devfeed.tech/tags/tests.md>)

### AI overview

Reaper uses historical database bug fixes to find related defects in syntactic sibling handlers, which may share implementation patterns such as argument extraction, type checking, and permission validation. It infers a trigger profile and a validation profile from each fix, uses grammar-guided test mutation to exercise corresponding paths in sibling handlers, then applies staged validation to reduce false positives. Evaluated on MariaDB, MySQL, OceanBase, and CockroachDB, Reaper found 61 previously unknown bugs; developers confirmed 57, and 13 had been fixed at the time of writing.

### Source excerpt

arXiv:2611.07739v1 Announce Type: new Abstract: Database management systems (DBMSs) implement SQL constructs through grammar-driven dispatch handlers. Although handlers for syntactic siblings implement different SQL constructs, they often share a common implementation pattern, including argument extraction, type checking, and permission validation. Consequently, a bug fix that hardens the handler exercised by a historical bug may leave the corresponding logic in sibling handlers vulnerable to the same semantic flaw. We refer to such defects as sibling bugs. Despite the structural similarity among sibling handlers, existing bug-finding techniques rarely exploit historical fixes to systematically uncover these related defects. We present Reaper, a novel approach for detecting sibling bugs guided by historical bug fixes. Reaper first analyzes a bug fix to infer a trigger profile, which characterizes the conditions under which the defect is exposed, and a validation profile, which captures the semantic evidence needed to distinguish buggy behavior from correct behavior. It then projects the trigger profile onto syntactic siblings through grammar-guided test mutation, generating tests that exercise corresponding semantic paths in sibling handlers. Finally, Reaper validates suspicious behaviors using the inferred validation profile through a staged validation process, reducing false positives caused by complex DBMS behavior. We evaluate Reaper on four widely used DBMSs, including MariaDB, MySQL, OceanBase, and CockroachDB. Reaper uncovers 61 previously unknown bugs, of which 57 have been confirmed by developers and 13 have been fixed at the time of writing. These results demonstrate that historical bug fixes contain actionable semantic knowledge that can be systematically transferred across syntactic siblings to uncover otherwise overlooked defects.

## AWS contributes a large-transaction binary log optimization to MySQL

DevFeed: [AWS contributes a large-transaction binary log optimization to MySQL](<https://devfeed.tech/articles/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-112630.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql/>)

Author: Xueting Wu

Published: 2026-11-02T16:57:08Z

Content type: news

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [transaction-log](<https://devfeed.tech/topics/transaction-log.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bolt](<https://devfeed.tech/tags/bolt.md>), [crash-recovery](<https://devfeed.tech/tags/crash-recovery.md>), [large](<https://devfeed.tech/tags/large.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [rds-for-mysql](<https://devfeed.tech/tags/rds-for-mysql.md>), [throughput](<https://devfeed.tech/tags/throughput.md>), [transaction](<https://devfeed.tech/tags/transaction.md>)

### AI overview

BOLT removes the large-transaction binlog copy that can block all MySQL commits: once a transaction exceeds a configurable threshold (128 MB by default), MySQL promotes its spill file into the binlog sequence. A header event lets crash recovery seek to the transaction's end instead of scanning its contents. In the described controlled benchmarks, a 50 GiB transaction's commit took about 2.5 seconds with BOLT versus about 7 minutes without it; binlog recovery took about 0.1 seconds versus about 4 minutes. Throughput also rose in tested workloads containing large transactions. These results are benchmark-specific, and remaining commit time includes durable spill-file writes and InnoDB commit. BOLT is enabled by default in Aurora MySQL; a future MySQL innovation release is planned. Large transactions can still reduce replica parallelism and cause lag, so the post recommends batching them where the application allows.

### Source excerpt

When MySQL commits a large transaction, writing it to the binary log can freeze every other commit on the server for minutes. This post introduces Binary Log Optimization for Large Transactions (BOLT), an AWS contribution to community MySQL that makes commit latency independent of transaction size, speeds crash recovery, and improves throughput.

## The key syntax differences between MySQL and PostgreSQL - everything you should know

DevFeed: [The key syntax differences between MySQL and PostgreSQL - everything you should know](<https://devfeed.tech/articles/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know-101272.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know/>)

Author: Aisha Bukar

Published: 2026-10-26T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [syntax](<https://devfeed.tech/topics/syntax.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>)

Tags: [aishabukar-mysql-postgresql](<https://devfeed.tech/tags/aishabukar-mysql-postgresql.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [fetch](<https://devfeed.tech/tags/fetch.md>), [limit](<https://devfeed.tech/tags/limit.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-syntax](<https://devfeed.tech/tags/sql-syntax.md>), [syntax](<https://devfeed.tech/tags/syntax.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

MySQL-to-PostgreSQL migration requires checking behavior as well as SQL syntax. MySQL identifier backticks must be replaced with PostgreSQL double quotes, whose use makes names case-sensitive; renaming keyword conflicts may be easier to maintain. PostgreSQL offers sequence-backed SERIAL and SQL-standard IDENTITY in place of AUTO_INCREMENT, but neither automatically adds a uniqueness constraint; PostgreSQL RETURNING replaces separate retrieval with LAST_INSERT_ID(). Basic LIMIT and OFFSET work in both, while MySQL's LIMIT offset,count shorthand does not; PostgreSQL also supports FETCH FIRST. MySQL's INSERT IGNORE and ON DUPLICATE KEY UPDATE translate to PostgreSQL ON CONFLICT DO NOTHING or DO UPDATE. TRUNCATE differs more substantially: PostgreSQL supports rollback and explicit identity restart/continuation, while MySQL InnoDB TRUNCATE implicitly commits; foreign-key and cascade behavior also needs review.

### Source excerpt

Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and more.... The post The key syntax differences between MySQL and PostgreSQL - everything you should know appeared first on Simple Talk.

## MySQL Monitor: MySQL Monitoring Script

DevFeed: [MySQL Monitor: MySQL Monitoring Script](<https://devfeed.tech/articles/mysql-monitor-mysql-monitoring-script-98999.md>)

Original publisher: [Read original article](<https://linuxblog.io/mysql-monitor-script/>)

Author: Hayden James

Published: 2026-10-24T15:52:11Z

Content type: article

Language: en

Sources: [Hayden James](<https://devfeed.tech/sources/hayden-james.md>)

Topics: [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Monitoring & Alerting](<https://devfeed.tech/topics/monitoring-alerting.md>), [health check](<https://devfeed.tech/topics/health-check.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>)

Tags: [alerts](<https://devfeed.tech/tags/alerts.md>), [blog](<https://devfeed.tech/tags/blog.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [health-checks](<https://devfeed.tech/tags/health-checks.md>), [linux](<https://devfeed.tech/tags/linux.md>), [live](<https://devfeed.tech/tags/live.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [script](<https://devfeed.tech/tags/script.md>), [scripts](<https://devfeed.tech/tags/scripts.md>), [sysadmins](<https://devfeed.tech/tags/sysadmins.md>)

### AI overview

MySQL Monitor is a single Bash script that turns MySQL status counters into a live terminal dashboard with per-second rates, recent-history sparklines, alerts, health checks, and process and top-query views. Its health checks suggest settings to review; process controls include sorting, filtering, and confirmed query termination. The top-query view reads statement totals from `performance_schema`, which is enabled by default in MySQL 5.7 and 8.0 but must be enabled and restarted on MariaDB; it also requires SELECT access. The script works with MySQL 5.7, 8.0, MariaDB, and gawk, mawk, or BusyBox awk, and supports one-shot output for SSH or cron. Run it as root or configure credentials in a mode-restricted `~/.my.cnf`; it does not accept passwords on the command line. Since-boot statistics need about 24 hours of normal traffic to be meaningful, while live rates become available after the second refresh.

### Source excerpt

Updated October 2026: MySQL Monitor has had a major update. The single table of counters is now a live dashboard with per-second rates, alerts, health checks and process and top-query views. Continue reading...

## \[webapps\] Automotive Shop Management System 1.0 - SQLi

DevFeed: [\[webapps\] Automotive Shop Management System 1.0 - SQLi](<https://devfeed.tech/articles/webapps-automotive-shop-management-system-1-0-sqli-93099.md>)

Original publisher: [Read original article](<https://www.exploit-db.com/exploits/52697>)

Author: nu11secur1ty

Published: 2026-10-21T00:00:00Z

Content type: news

Language: en

Sources: [Exploit-DB.com RSS Feed](<https://devfeed.tech/sources/exploit-db-com-rss-feed.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [automotive](<https://devfeed.tech/tags/automotive.md>), [critical](<https://devfeed.tech/tags/critical.md>), [management](<https://devfeed.tech/tags/management.md>), [multiple](<https://devfeed.tech/tags/multiple.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [shop](<https://devfeed.tech/tags/shop.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>), [status](<https://devfeed.tech/tags/status.md>), [webapps](<https://devfeed.tech/tags/webapps.md>)

### AI overview

The report says Automotive Shop Management System 1.0's `id` parameter in `products/view_product.php` appears vulnerable to SQL injection. It describes submitting an injected subquery that calls MySQL `load_file` with a UNC path pointing to an external domain; the reported interaction with that domain is presented as evidence that the query executed. The text labels the issue critical, but provides no independent validation or further impact details.

### Source excerpt

Automotive Shop Management System 1.0 - SQLi

## How We Stopped a Weekly Batch Job From Taking Down a Live MySQL Service

DevFeed: [How We Stopped a Weekly Batch Job From Taking Down a Live MySQL Service](<https://devfeed.tech/articles/how-we-stopped-a-weekly-batch-job-from-taking-down-a-live-mysql-service-88646.md>)

Original publisher: [Read original article](<https://hackernoon.com/how-we-stopped-a-weekly-batch-job-from-taking-down-a-live-mysql-service?source=rss>)

Author: Rajesh Gomathinayagam

Published: 2026-10-16T05:33:40Z

Content type: article

Language: en

Sources: [HackerNoon](<https://devfeed.tech/sources/hackernoon.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>)

Tags: [assets](<https://devfeed.tech/tags/assets.md>), [database](<https://devfeed.tech/tags/database.md>), [database-design](<https://devfeed.tech/tags/database-design.md>), [database-performance](<https://devfeed.tech/tags/database-performance.md>), [database-queue-architecture](<https://devfeed.tech/tags/database-queue-architecture.md>), [high-volume-data-ingestion](<https://devfeed.tech/tags/high-volume-data-ingestion.md>), [inno-db-row-locking](<https://devfeed.tech/tags/inno-db-row-locking.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-lock-contention](<https://devfeed.tech/tags/mysql-lock-contention.md>), [mysql-performance-optimization](<https://devfeed.tech/tags/mysql-performance-optimization.md>), [mysql-table-partitioning](<https://devfeed.tech/tags/mysql-table-partitioning.md>), [production](<https://devfeed.tech/tags/production.md>), [queue](<https://devfeed.tech/tags/queue.md>), [resumable-batch-processing](<https://devfeed.tech/tags/resumable-batch-processing.md>), [rotation](<https://devfeed.tech/tags/rotation.md>)

### AI overview

A weekly bulk update to a MySQL table held row locks that blocked live inserts and caused production timeouts. The team moved new requests to a separate queue table, merged them into the primary table hourly, and rotated queues through a checkpointed workflow. Partitioning the primary table and retaining only recent data online helped keep the live workload bounded. The design trades immediate status visibility for simpler live-path isolation: a new request may take up to an hour to appear in the primary table.

### Source excerpt

How a team eliminated production timeouts caused by MySQL bulk updates using queue tables, resumable rotation, and workload isolation.

## JavaScript in MySQL: Extending SQL, Not Moving the Application

DevFeed: [JavaScript in MySQL: Extending SQL, Not Moving the Application](<https://devfeed.tech/articles/javascript-in-mysql-extending-sql-not-moving-the-application-87983.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/javascript-in-mysql-extending-sql-not-moving-the-application/>)

Author: Marco Tusa

Published: 2026-10-15T15:12:30Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [JavaScript](<https://devfeed.tech/topics/javascript.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [application-logic-vs-database-logic](<https://devfeed.tech/tags/application-logic-vs-database-logic.md>), [component-js-lang](<https://devfeed.tech/tags/component-js-lang.md>), [data-validation](<https://devfeed.tech/tags/data-validation.md>), [database-administration-dba](<https://devfeed.tech/tags/database-administration-dba.md>), [database-architecture](<https://devfeed.tech/tags/database-architecture.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [json-processing](<https://devfeed.tech/tags/json-processing.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona-live-europe-2026](<https://devfeed.tech/tags/percona-live-europe-2026.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [stored-procedures](<https://devfeed.tech/tags/stored-procedures.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [v8-engine](<https://devfeed.tech/tags/v8-engine.md>)

### AI overview

The article explains how JavaScript routines in MySQL can extend SQL with specialized data operations while keeping business decisions in application code. It describes runtime restrictions, demonstrations involving deduplication and validation, and criteria for deciding which functions belong in the database. It also recommends a shared review process for developers and database administrators. The feature is available as a technology preview in Percona Server for MySQL, with SQL execution from JavaScript still on its roadmap.

### Source excerpt

At Percona Live Europe 2026, Dmitry Lenev and I presented JavaScript in My Database? Over My Dead Query, the story of component_js_lang, the V8-based JavaScript engine for Percona Server for MySQL 8.4. That experience told us few things: The presentation was seen as "for developers" What most DBA or DevOps heard was "JavaScript in the ... Continued The post JavaScript in MySQL: Extending SQL, Not Moving the Application appeared first on Percona.

## How to make database schema changes without downtime in MySQL: complete guide

DevFeed: [How to make database schema changes without downtime in MySQL: complete guide](<https://devfeed.tech/articles/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide-85267.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/mysql/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide/>)

Author: Lukas Vileikis

Published: 2026-10-12T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [zero downtime deployment](<https://devfeed.tech/topics/zero-downtime-deployment.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [databases](<https://devfeed.tech/tags/databases.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [featured](<https://devfeed.tech/tags/featured.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [online-ddl](<https://devfeed.tech/tags/online-ddl.md>), [percona](<https://devfeed.tech/tags/percona.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

This guide explains how to reduce downtime when changing MySQL database schemas. It covers causes of disruption, built-in online DDL, and tools such as Percona Toolkit and gh-ost, with the method depending on the change and use case.

### Source excerpt

Learn how to make MySQL schema changes without downtime. Compare online DDL, Percona Toolkit, and gh-ost to keep your database available during updates.... The post How to make database schema changes without downtime in MySQL: complete guide appeared first on Simple Talk.

## Meet MySQL 26.7: A New Versioning Era Begins

DevFeed: [Meet MySQL 26.7: A New Versioning Era Begins](<https://devfeed.tech/articles/meet-mysql-26-7-a-new-versioning-era-begins-85124.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/meet-mysql-26-7-a-new-versioning-era-begins/>)

Author: Anil Joshi

Published: 2026-10-12T04:05:49Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [versioning](<https://devfeed.tech/topics/versioning.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [Deployment & Scaling](<https://devfeed.tech/topics/deployment-scaling.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [availability](<https://devfeed.tech/tags/availability.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [featured](<https://devfeed.tech/tags/featured.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [lts](<https://devfeed.tech/tags/lts.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-asynchronous-replication](<https://devfeed.tech/tags/mysql-asynchronous-replication.md>), [mysql-gtid](<https://devfeed.tech/tags/mysql-gtid.md>), [mysql-replication](<https://devfeed.tech/tags/mysql-replication.md>), [mysql-thread-pool](<https://devfeed.tech/tags/mysql-thread-pool.md>), [mysql-v26-7](<https://devfeed.tech/tags/mysql-v26-7.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-services](<https://devfeed.tech/tags/percona-services.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [release](<https://devfeed.tech/tags/release.md>), [storage-engine](<https://devfeed.tech/tags/storage-engine.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [versioning](<https://devfeed.tech/tags/versioning.md>)

### AI overview

MySQL 26.7 introduces calendar-based Year.Month.Patch versioning and keeps quarterly Innovation releases, with LTS releases expected roughly every two years. The release also adds the Change Stream Applier for parallel transaction work, makes the Thread Pool Plugin available in Community editions, and changes several InnoDB and group replication behaviors.

### Source excerpt

Over the period, we have witnessed how MySQL versioning evolved from 8.0 to 9.7 LTS, and now it has entered a new era: a calendar-based model. Let's first take a brief look at how MySQL versioning has evolved over time. Phase 1 - MySQL 8.0 (2018-2026) used a traditional single-track release model, with all new ... Continued The post Meet MySQL 26.7: A New Versioning Era Begins appeared first on Percona.

## DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1

DevFeed: [DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1](<https://devfeed.tech/articles/dbtrail-analytical-reports-on-your-mysql-data-without-running-them-on-mysql-part-1-65637.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/dbtrail-analytical-reports-on-your-mysql-data-without-running-them-on-mysql-part-1/>)

Author: Vadim Tkachenko

Published: 2026-10-06T16:28:16Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [streaming data to S3 with Parquet](<https://devfeed.tech/topics/streaming-data-to-s3-with-parquet.md>)

Tags: [apache](<https://devfeed.tech/tags/apache.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [database](<https://devfeed.tech/tags/database.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>)

### AI overview

The article tests DBTrail, an open-source approach for querying MySQL data with DuckDB while transactional workloads continue. DBTrail copies tables into Parquet files, then follows MySQL's binary log to apply changes. In the reported tests, the initial copy caused a brief latency increase, while subsequent reporting queries ran against DuckDB. The article also reports the test setup and performance measurements.

### Source excerpt

MySQL is very good at serving application workloads, but things get more complicated when somebody decides to run a large report on the same server. A scan can push hot pages out of the buffer pool. A long-running read can hold back purge. A GROUP BY over millions of rows can start writing temporary tables ... Continued The post DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1 appeared first on Percona.

## How MySQL Implicit Type Conversion Turned an Indexed Query Into a 7M-Row Scan

DevFeed: [How MySQL Implicit Type Conversion Turned an Indexed Query Into a 7M-Row Scan](<https://devfeed.tech/articles/how-mysql-implicit-type-conversion-turned-an-indexed-query-into-a-7m-row-scan-64959.md>)

Original publisher: [Read original article](<https://hackernoon.com/how-mysql-implicit-type-conversion-turned-an-indexed-query-into-a-7m-row-scan?source=rss>)

Author: Oluwaseun

Published: 2026-10-05T15:49:22Z

Content type: tutorial

Language: en

Sources: [HackerNoon](<https://devfeed.tech/sources/hackernoon.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>), [Tech Debt](<https://devfeed.tech/topics/tech-debt.md>)

Tags: [batching](<https://devfeed.tech/tags/batching.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [database-indexes](<https://devfeed.tech/tags/database-indexes.md>), [implicit-type-conversion](<https://devfeed.tech/tags/implicit-type-conversion.md>), [mvcc](<https://devfeed.tech/tags/mvcc.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-data-types](<https://devfeed.tech/tags/mysql-data-types.md>), [optimize-mysql-queries](<https://devfeed.tech/tags/optimize-mysql-queries.md>), [query](<https://devfeed.tech/tags/query.md>), [sql-performance-tuning](<https://devfeed.tech/tags/sql-performance-tuning.md>), [sql-query-optimization](<https://devfeed.tech/tags/sql-query-optimization.md>)

### AI overview

A production UPDATE intended to change a few customer records risked scanning millions of rows because a numeric literal was compared with a VARCHAR column, leading MySQL to apply implicit type conversion and bypass the index. The article describes correcting the literal, accounting for a date filter absent from the composite index, and safely extracting target IDs before updating them in batches with production safeguards.

### Source excerpt

A missing quote made MySQL scan 7.2 million rows. Here's how EXPLAIN exposed the problem and what it taught us about safe production updates.

## Thread Pool in Percona Server and MySQL (Part 1)

DevFeed: [Thread Pool in Percona Server and MySQL (Part 1)](<https://devfeed.tech/articles/thread-pool-in-percona-server-and-mysql-part-1-64993.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/thread-pool-in-percona-server-and-mysql-part-1/>)

Author: Bogdan Degtyariov

Published: 2026-10-05T10:48:57Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [threadpools](<https://devfeed.tech/topics/threadpools.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [server](<https://devfeed.tech/tags/server.md>), [thread-pool](<https://devfeed.tech/tags/thread-pool.md>)

### AI overview

The article explains MySQL thread pooling and compares its efficiency in Percona Server for MySQL. Its benchmarks show that pooling can greatly improve throughput under heavy, I/O-bound connection loads, while an unpooled configuration performs better with fully buffered data. The article also reports tighter p95 latency at 2,560 connections with pooling and stresses that results depend on careful tuning.

### Source excerpt

Thread Pool in Percona Server and MySQL (Part 1) A new version of Community MySQL Server July release contains two versions 26.7.0 and 9.7.2. It is an important milestone because it finally brings a Thread Pooling feature to the community. The official MySQL Server Thread Pool plugin existed for a long time, but was available ... Continued The post Thread Pool in Percona Server and MySQL (Part 1) appeared first on Percona.

## Someone Got Doom In an SQL Database

DevFeed: [Someone Got Doom In an SQL Database](<https://devfeed.tech/articles/someone-got-doom-in-an-sql-database-64450.md>)

Original publisher: [Read original article](<https://developers.slashdot.org/story/26/10/03/0125235/someone-got-doom-in-an-sql-database>)

Author: BeauHD

Published: 2026-10-03T16:00:00Z

Content type: news

Language: en

Sources: [Slashdot](<https://devfeed.tech/sources/slashdot.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [browser-game](<https://devfeed.tech/topics/browser-game.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [doom](<https://devfeed.tech/tags/doom.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

SQLDoom uses CedarDB tables and SQL queries to implement Doom's game logic and render full-color 640x480 frames at 35 frames per second. A small Python client handles input, output, timing, and display. The report compares it with an earlier SQL-based Doom project and says the code, CedarDB, and a Doom WAD file are needed to run it locally.

### Source excerpt

An anonymous reader quotes a report from Ars Technica: Rendering Doom in a database is obviously a bad idea," Lukas Vogel writes in a lengthy blog post explaining how exactly he managed to render Doom using an SQL database. OK, that's not entirely accurate. The SQLDoom project uses a small Python client to handle input and output, drive the game's timing, and display each frame to the screen. Behind that, a series of CedarDB tables tracks the game geometry and state, while about 1,300 lines of SQL queries spread across 89 common table expressions implement the game logic and generate 35 bitmap framebuffers per second. In this, SQLDoom is a major improvement over Vogel's previous DoomQL project, which last year set out to build "a multiplayer Doom-like shooter entirely in SQL." Unfortunately, that effort ended up with raycasting-based, grayscale ASCII graphics that were more akin to the simplistic 90-degree-angled maps of Wolfenstein 3D. The newer SQLDoom, on the other hand, generates full-color 640x480 frames that look like they could have come from the original Doom executable. [...] If you want to run a Doomtabase on your own local machine, you can do so simply with the GitHub code, a copy of CedarDB, and a Doom WAD file. Or you can jump into a free online hosted demo match to test it out without all the setup [...]. Read more of this story at Slashdot.

## LibreDB Studio: open-source, free, self-hosted SQL IDE that runs in your browser, for 46 databases

DevFeed: [LibreDB Studio: open-source, free, self-hosted SQL IDE that runs in your browser, for 46 databases](<https://devfeed.tech/articles/libredb-studio-open-source-free-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-64443.md>)

Original publisher: [Read original article](<https://noted.lol/libredb-studio/>)

Author: Abdullah Kaya

Published: 2026-10-03T12:37:09Z

Content type: article

Language: en

Sources: [Noted](<https://devfeed.tech/sources/noted.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [text2sql](<https://devfeed.tech/topics/text2sql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [ai-assistant](<https://devfeed.tech/tags/ai-assistant.md>), [databases](<https://devfeed.tech/tags/databases.md>), [docker](<https://devfeed.tech/tags/docker.md>), [ide](<https://devfeed.tech/tags/ide.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>), [self-hosted-web-tools](<https://devfeed.tech/tags/self-hosted-web-tools.md>), [sql](<https://devfeed.tech/tags/sql.md>), [ssh](<https://devfeed.tech/tags/ssh.md>)

### AI overview

LibreDB Studio is an open-source database editor deployed as a container alongside databases and accessed through a browser. The article describes its deployment options, database drivers, OpenID Connect sign-on and role controls, and optional AI assistant. The assistant can draft and run read-only SQL against supported engines, while writes require user action; without a configured model, no data leaves the network.

### Source excerpt

LibreDB Studio is a free, open-source database editor that runs in Docker, letting you securely manage your databases directly from your browser without exposing ports, opening SSH tunnels, or installing additional software.

[Next page](<https://devfeed.tech/topics/mysql.md?cursor=WyIyMDI2LTEwLTAzVDEyOjM3OjA5KzAwOjAwIiwgImQ5MmQ2MDJhLTJlYmYtNDg4Mi05ZDdjLTA5ZTAyMTMxNmI4ZSJd>)