This new AI tech, called generative AI (or GenAI), can dive deep
into what people are saying and tell us if they’re feeling
positive, negative, or neutral.
Let’s see how HeatWave GenAI, can help you to enhance your
understanding of customer sentiment, improve decision-making, and
drive business success.
The post HeatWave GenAI: Sentiment Analysis Made Easy-Peasy first appeared on dasini.net - Diary of a MySQL expert.
Oracle HeatWave provides automated, integrated, and secure generative AI and machine learning in one fully managed cloud service for transactions and lakehouse-scale analytics. New features are available across the HeatWave portfolio—on both OCI and AWS.
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 on to learn basics about invalid objects and how to identify them in SQL Server, MySQL, and Oracle databases using dbForge Edge or from the command line.
The post Find Invalid Objects in Your Databases appeared first on Devart Blog.
MySQL Enterprise Edition has the ability to mask and de-identify data. Find out how to use it in this article!
Codership will be a sponsor at DOAG 2024 in Nuremberg, Germany. There will also be 2 Galera Cluster related talks to attend:
There are also a few Galera Cluster blog posts in German from our partner Ordix that are useful:
By now you must have read our documentation on isolation levels and also our Support for Transaction Isolation Levels. It is worth noting that the default transaction isolation level in MySQL 8 is REPEATABLE READ.
Here is a simple example of this, in action (you can test this on two different nodes, even across a 9-node Galera Cluster!).
First we do some simple setup:
CREATE DATABASE isolate;
USE isolate;
CREATE TABLE products (
id INT PRIMARY KEY,
name VARCHAR(50),
price DECIMAL(10, 2)
);
Then we insert some initial data:
INSERT INTO products (id, name, …[Read more]
Just thought I’d share a script I use daily and helps me redirect my attention if needed.
This is but a mere pointer, guideline and starting point in any task. I just thought I’d share and hope someone else’s day becomes slightly easier thanks to some brief investigation and command tweaking.
Now the really handy thing here is that I only hard code the router01 node name, as I’m using that as a potential endpoint (thinking cloud, XaaS, etc…) where it could also be a VIP, LBR or similar. It’s the entry point so I can query the P_S table error_log so I can get different views and act accordingly.
For example:
I have been scratching my head about MySQL startup for some time. There is much to say about this, and many other posts will probably follow. For now, it is enough to know that with many tables (millions) the startup of MySQL 8.0+ (including 8.0, 8.4 and 9.0) is suboptimal (to say the least). With very little changes, I was able to speed it up, from 2:39 to 1:09 (1 minute and 9
The aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest (MySQL).
Nice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your private DBaaS. For sure the easiest part will be to run new environments to get better understanding and experience on how the solution works. However, the day when you will look to migrate your existing environments will come. What should you do?
Prepare a plan! In which the first step is to understand your current environment.
When I say understand the current environment, I mean that you need to have a clear understanding of: