Introducing Bulk Ingest Functionality in MySQL HeatWave on AWS

This blog post discusses using the [crayon-659c2fe27b13a472295750-i/]  command with the safety option [crayon-659c2fe27b141470126814-i/]  when you do not have enough disk space to store two datasets.In my previous blog post on the [crayon-659c2fe27b142478330007-i/]  command, The MySQL Clone Plugin Is Not Your Backup, I mentioned that using the option [crayon-659c2fe27b143176725038-i/]  helps to avoid situations where you need to re-initialize […]

In this blog post we will see how to use MySQL HeatWave Lakehouse to load data using MySQL Autopilot and have it automatically extract the header row to use as column names in the generated tables.

in this article, We’ll learn “INSERT INTO IF NOT EXISTS” with examples. We’ll also provide examples demonstrating its effective implementation. We will cover both core PHP and Laravel approaches. This allows you to add data to a table only if a matching record does not already exist. INSERT INTO MySQL IF NOT EXISTS Let’s demonstrate […]

The post PHP: MySQL Insert into if not exists appeared first on Phpflow.com.

Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: https://code.visualstudio.com/docs/cpp/cpp-debug#_memory-dump-debugging. When MySQL generates a core file, the VS code simplifies the process of debugging. This blog will discuss how to debug the core file in VS code.Installing c/c++ extensionWe need to install the c/c++ extension. Here are the instructions for doing so. In […]

This blog discusses recommender system models and their usage in MySQL HeatWave AutoML

A common practice among DBAs and developers is to copy table data and .frm files from the data dictionary. They often set up batch jobs to automate the recovery of these tables. This capability is also utilized in disaster recovery scenarios, where individuals well-versed in .frm files can reconstruct their metadata as needed.

In MySQL 8.0, the information is presented within serialized objects within the dictionary. In the case of InnoDB tablespaces, this information is incorporated into the tablespace itself, creating a fusion of metadata and data primarily to enhance performance. MySQL writes a .sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality.

Purpose of .sdi files

Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. This serialized data …

In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments.

Flame graphs are a graphical representation of function calls. It shows which code paths are more busy on the CPU in given samples. They can be generated with any OS profiler that contains stack traces such as perf, eBPF, and SystemTap.

An example of a flame graph can be found below:

Each box is a function in the stack, and wider boxes mean more time the system was busy on CPU on these functions.

Kubernetes limitations

In Linux, by default, performance system events can’t be collected by unprivileged users. In regular environments, this can be easily worked around by running the profiler with a sudo privilege.

On the other hand, in Kubernetes environments, pods are the smallest deployable unit that consists of one or more containers. Exploits are generally targeted to …

In this article we will see how we can deploy WordPress and MySQL on OKE in OCI using the MySQL Operator for Kubernetes.

Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets cluster we are using is OKE (Oracle Kubernetes Engine) in OCI (Oracle Cloud Infrastructure):

OKE Cluster

We start by creating a Kubernetes Cluster on OCI using the Console:

We select the Quick create mode:

We need to name our cluster and make some choices:

When created, we can find it in the OKE Clusters list:

And we can see the pool of workers nodes and the workers:

kubectl

I like to use kubectl directly on my latop to manage my K8s Cluster.

On my Linux Desktop, I need to install kubernetes-client package (rpm).

Then on the K8s Cluster details, you can click on Access Cluster to get all the commands to use:

We need to copy them on our terminal and then, I like to also enable the bash completion for …