What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward answer to this, quoting: InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is […]

In reply to John.

Not sure about the seg fault on docker. If I were you, I’d open another bug for that. As for the ANSI mode, it’s a drupal thing apparently, as per https://www.drupal.org/node/344575. Other than forcing sql_mode on each user to be specific, and even then I believe they set it at session level anyhow, I suspect we’ll just have to wait for it to be fixed in router v9.0 or similar. In order to help with that, maybe you could also open a bug against the same issue and help pressure the Router dev team? The more the merrier….

LikeLike …

Thanks Keith,

I’m having same trouble with MySQL Router 8.3 and drupal. sql_mode is set to ANSI

and MYSQL_ATTR_USE_BUFFERED_QUERY is ON.

Strangly Drupal 8.5 changed to ANSI_QUOTES

https://git.drupalcode.org/project/drupal/-/blame/10.5.x/core/modules/mysql/src/Driver/Database/mysql/Connection.php?ref_type=heads#L94

After a while, the router crash with a seg fault on docker.

LikeLike

MySQL January 2025 GA Releases Now Available

2024 was a productive year for HeatWave MySQL product line with many important enhancements in several areas. We achieved critical milestones in areas of availability, disaster recovery, performance, system management, operations and productivity. Let’s take a look some of the key features.

The financial services industry is facing a new regulation: the Digital Operational Resilience Act (DORA). One of the key requirements of DORA is that financial institutions must have a robust riskmanagement framework in place. This framework must identify, assess, and mitigate ICT risks. MySQL Enterprise Edition can help organizations achieve DORA compliance byproviding a number of features that can help to identify, assess, and mitigate ICT risks.

This blog shows how HeatWave MySQL delivers substantially more value than the MySQL cloud services offered by AWS, Google Cloud, and Azure. Furthermore, not only can you power your OLTP applications using HeatWave MySQL but you also get built-in lakehouse-scale analytics, generative AI, and machine learning at no additional cost

The 2024 JetBrains Developer Ecosystem Report reaffirms what millions of developers already know—MySQL is the #1 database. According to the report, "MySQL continues to be the most widely used database, favored by developers across various domains for its reliability and ease of use.