We are excited to launch the Independent Software Vendor (ISV) Catalog for MySQL HeatWave.  This catalog will enable both customers and partners to easily find 3rd party ISV products and services for MySQL HeatWave.     MySQL HeatWave is a fully managed database service for transactions, real- time analytics across data warehouses and data lakes, […]

This Independent Software Vendor (ISV) Catalog for MySQL HeatWave will enable both customers and partners to easily find 3rd party ISV products and services for MySQL HeatWave.    

A comprehensive continuous integration (CI) and continuous deployment (CP) process should include automated testing of code. In this post, we will discuss how to use GitHub Actions to run tests for Node.js code that interacts with a MySQL database.

Recently, I have been talking about how to write and run tests for Node.js code that interacts with a MySQL database. These posts have included details on how to use third-party libraries such as Testcontainers to run the tests in a clean database and Knex to manage database changes. Today, I will discuss how to automate running these tests using GitHub Actions when […]

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability.

What are Transparent Huge Pages?

In order to understand THP, we should first start with a brief description of Linux HugePages. The concept of HugePages in Linux has existed for many years, first introduced in 2007. By default, the majority of widely used Linux distributions employ a virtual memory page size of 4KB. However, the inclusion of the HugePages feature allows the Linux kernel to efficiently handle substantial memory pages alongside the standard 4KB size.

In order for an application to utilize HugePages, however, it must explicitly include an …

As previously announced on Aug 15, 2023, you can find the MySQL team at following conferences in October 2023: Please mark your calendars and we look forward to speaking with you!        

Where can you find MySQL team in October 2023

We’re excited to announce that we are adding support for vector storage and search into MySQL and PlanetScale. Soon, you’ll be able to use PlanetScale as a vector database for all of your AI needs without needing to adopt a second tool. You can sign up to be notified of release at planetscale.com/ai. What are vectors? A vector is a one-dimensional array of real number values: [1, 1] is a vector, as is [1.5, 8.889, 9.234]. Each element represents an attribute or a dimension, and the position of that element in the array represents a “point.” In three-dimensional space, a vector of [2, 3, 5] would have 2 as the x-coordinate, 3 as the y-coordinate and 5 as the z-coordinate. In real-world applications of artificial intelligence, vectors are in significantly higher dimensionality — well above 1,000! Modern databases are already very good at storing lists of numbers. Storing vectors as a raw datatype is not interesting, like points on a globe or …

This post was originally published in 2011 and was updated in October 2023.

I see this message on our forums, and I think it’s a great question: “Which version of Percona Server is currently recommended?” It’s really the same question as “Which version of MySQL is currently recommended?” In this blog, we cover everything you need to know about how to choose the right version of MySQL for your needs, as well as key information on the latest versions, 5.7 and 8.0.

Understanding MySQL Versions

MySQL versions play a pivotal role in database management, as each MySQL version represents a distinct release, encompassing enhancements, bug fixes, and new features that affect the performance, security, and functionality of the database and applications. Staying informed about MySQL version updates is vital for anyone tasked with managing databases, as it directly impacts the efficiency and reliability of data …

This article will explore how to connect to Oracle in Delphi using the Devart ODAC library. We'll cover the installation of Devart ODAC, provide concrete examples of its usage, and even compare it to FireDAC.

The post How to Connect to Oracle in Delphi with Devart ODAC appeared first on Devart Blog.