Some users, myself included, have noticed that their MySQL error log contains many lines like this one: Where does that error come from? The error MY-010914 is part of the Server Network issues like: Those are usually more problematic than the ones we are covering today. The list is not exhaustive and in the source ..read more

We saw in the previous post how we can deal with data stored in the new VECTOR datatype that was released with MySQL 9.0. We implemented the 4 basic mathematical operations between two vectors. To do so we created JavaScript functions. MySQL JavaScript functions are available in MySQL HeatWave and MySQL Enterprise Edition (you can ..read more

MySQL 9.0.0 has brought the VECTOR datatype to your favorite Open Source Database. There are already some functions available to deal with those vectors: This post will show how to deal with vectors and create our own functions to create operations between vectors. We will use the MLE Component capability to create JavaScript functions. JS ..read more

MySQL HeatWave 9.0 was released under the banner of artificial intelligence. It includes a VECTOR datatype and can easily process and analyze vast amounts of proprietary unstructured documents in object storage, using HeatWave GenAI and Lakehouse. Oracle Cloud Infrastructure also provides a wonderful GenAI Service, and in this post, we will see how to use OCI GenAI with MySQL HeatWave to build a custom RAG solution using the content of a WordPress site. This article was written with the help of my colleague Ivan Ma and based on the original blog of Ashul Dupare. The Plan The plan is to generat ..read more

As you can read in my previous post related to MySQL 9 and authentication, the old mysql_native_password plugin has been removed. In that post, I showed an example using PHP 7.2, the default version in OL8. If you are using PHP and you want to use MySQL 9, you must be using a more recent version that fully supports the default authentication plugin caching_cha2_password. Here is a summary table illustrating which PHP versions are compatible with MySQL 9: This is the test using OL8 and PHP from the official repository and from Remi’s repo: [root@mysql1 ~]# php test.php PHP version: 7.2.24 PH ..read more

With the latest MySQL Innovation Release, we decided that it was time to remove the remaining weak authentication plugin: mysql_native_password. We previously deprecated it and made it not default loaded in MySQL 8.4 LTS and, now, in 9.0 it’s gone! Reasons Oracle places significant attention on the security of all its products, and MySQL is no exception. The removal of the weak authentication plugin has been carefully considered, we had some extra time for the LTS release as it was initially intended for version 8.4, but it is now fully effective. But why is the mysql_native_password considere ..read more

Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7. Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver compatible with the caching_sha2_password for Rocky Linux 8 (EL8 or OL8 compatible). Therefore, I build two new packages supporting the latest perl-DBD-MySQL driver, version 5.005. The difference is related to the version of libmysql they are linked to. libmysql.so.21 for MySQL 8.0 and libmysql.so.24 for MySQL 8.4 LTS: MySQL 8.0 $ r ..read more

In MySQL HeatWave, the Database as a Service (DBaaS) offered by Oracle, Machine Learning is incorporated to provide database administrators (DBAs) and developers with an optimal experience. Those tools are the Auto ML advisors like the autopilot indexing for example. MySQL HeatWave is also an invaluable asset for Data Analysts, offering straightforward tools that streamline the process of creating predictive models through data training and scoring. The Data The data we are using is the Bank Marketing data related to marketing campaigns over phone calls of a Portuguese banking institution. The ..read more

MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse. When we talk about analytics, we also think about data visualization solutions. In OCI, you can use Oracle Analytics Cloud. In this article, we explore the procedure to establish a connection between Oracle Analytics Cloud (OAC) and a MySQL HeatWave DB instance within Oracle Cloud Infrastruc ..read more

Yesterday, MySQL 8.4, the very first LTS version of MySQL was released. A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications. The default value of 20 InnoDB variables has been modified! Let’s have a look at those variables and explain the reason for such modification: innodb_buffer_pool_in_core_file Previous Value: ON New Value (8.4 LTS): OFF if MADV_DONTDUMP is supported else ON MADV_DONTDUMP is a macro supported in Linux 3.4 and later, (“sys/mman.h” header file is present ..read more