Anomaly detection is a technique to find abnormalities in the data. It has found applications in a wide variety of fields such as fraud detection, network intrusion, detecting life-threatening medical conditions, quality control etc.
May
09
2023
May
08
2023
One of the best ways to learn is to read and study others’ fantastic content. And that’s just what I do each week in OpenLampTech. Get ready for another knowledge-packed newsletter. This is OpenLampTech.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
In OpenLampTech issue #77, I’m looking at content covering:
- Linux File Permissions
- 5 Solid MySQL Books
- PHP isset() …
May
08
2023
One of our customers recently had a Corrupted Index that affected the health of his database and caused latency for his customers. To identify and handle a corrupted index in MySQL, here are some common FAQs:
What is a MySQL corrupted index?
A MySQL corrupted index refers to a situation where the index data within a MySQL database becomes inconsistent or damaged, resulting in incorrect or incomplete query results. It can occur due to various reasons, such as hardware failures, software bugs, improper shutdowns, or disk errors.
What are the common symptoms of a MySQL corrupted index?
When a MySQL index is corrupted, you may experience several symptoms, such as slow query performance, incorrect or missing query results, frequent crashes or errors during database operations, or unusually high CPU or disk usage.
What are the common error messages related to MYSQL Index Corruption?
You can receive …
[Read more]
May
05
2023
In 2023, FOSSASIA returned as a physical event after 2 years of being virtual. With this comeback, the MySQL team was again part of the 2023 edition with MySQL keynote, several technical sessions and the MysQL booth. Despite the fact that only 200 participants turned out to be from the initially announced 1000 expected […]
May
05
2023
FOSSASIA Apr 2023
May
05
2023
Some times it’s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster.
Today we will see the different possibilities to have an idea of the size of transactions.
First we need to split the transaction in two types:
- those generating data (writes, like insert, delete and update, DML)
- those only ready data (select, DQL)
To implement High Availability, only the first category is important.
Size of DML
To know the size of a DML transaction, the only possibility we have is to parse the binary log (or query the binlog event).
We need to check the binlog event from the binlog file and then calculate its size. To illustrate this, let’s try to find the transaction identified by a specific GTID: …
[Read more]
May
05
2023
In this article you will learn how to retrieve the size of a transaction, DML or DQL in MySQL.
May
04
2023
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region MySQL HeatWave on AWS is now available in Japan Tokyo region. The new region enables customers with applications deployed in the Tokyo region to: Minimize network latency between the application and database, enhancing the user experience on the application Reduce the high […]
May
04
2023
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region
May
04
2023
Some times it’s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster. Today we will see the different possibilities to have an idea of the size of transactions. First we […]