MySQL HeatWave ML supports various scoring metrics. User needs to keep in mind the characteristics of these metrics, to use them effectively.
Sep
13
2022
Sep
12
2022
This architecture is fine for development, but is somewhat lacking for production: There is no way to scale out the application tier or database tier to meet increasing load. The application server and database can only be scaled up by adding resource. Both the application server and database are single points of failure (SPOF). Further, there is no way maintenance can be performed on either the application server or database without affecting availability.
Sep
12
2022
This is one of the exciting troubleshooting related to XA transactions let’s dive in. Let me provide a few backgrounds.
For one of our clients, when we try to drop a table, it is waiting for metadata lock. On debugging it is one of the XA transactions is holding the shared write lock and causing metadata lock on all the other local transactions.
Let us view the metadata locks from the Performance Schema.
mysql> select OBJECT_TYPE,OBJECT_SCHEMA,OBJECT_NAME,
LOCK_TYPE,LOCK_STATUS,SOURCE from
performance_schema.metadata_locks\G |
Sep
12
2022
I can’t thank you all enough for making OpenLampTech a successful endeavor for me. We are continuing to publish great newsletters that get read and draw in new subscribers. This week’s issue is loaded with great content so enjoy those articles you like most. Please share with others…
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 #43 we have content on:
- The PHP Constructor
- WordPress needs writing
- MySQL Window Functions
- Managing 1,300 WordPress sites
- A list of great free …
Sep
12
2022
Update June 12, 2023: This component has been deprecated in v17 and will be removed in v18! We recommend that you instead use VTOrc with the semi_sync durability policy. Introduction # MySQL group replication is a new replication mechanism that was released in 2016. Group replication involves establishing a group of nodes that are coordinated automatically via Group Communication System (GCS) protocols, an implementation of Paxos. For a transaction to commit, a majority of the group has to agree on the order of a given transaction in the global sequence of transactions.
Sep
11
2022
For anything but the most trivial software projects source control is highly recommended. Where multiple developers contribute to a project then it is essential to have proper source control so that changes to code can be properly managed/merged.
Sep
09
2022
Another day, another company announces it changed its license away from open source while claiming “We Believe In A Model Of Sustainable Open Source.”
I’m not sure about you, but this rings to me as similar to an alleged quote about the Vietnam War: “We had to destroy the village in order to save it.”
What Lightbend’s CEO and Founder, Jonas Boner, really means is that they have decided that they do not believe an open source license (Apache 2.0) suits their business goals best any longer, and a proprietary, source available license (BSL) will be a better fit.
As an entrepreneur and business founder myself, I understand business is hard. Often, your choices are limited, especially if you’ve taken other …
[Read more]
Sep
09
2022
More and more people are using UUID’s to identify records in their database.
As you already know, for MySQL’s storage engine (InnoDB) the primary key is very important ! (for performance, memory and disk space).
See the following links:
- https://lefred.be/content/mysql-invisible-column-part-ii/
- https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html (GIPK mode in MySQL 8.0.30 !)
Problems
There are 2 major problems having a UUID as Primary Key in InnoDB:
- generally they are random and cause clustered index to be rebalanced
- they are included in each secondary indexes (consuming disk and memory)
Let’s have a look at …
[Read more]
Sep
08
2022
Whilst not part of the LAMP stack per-se, you will need a MySQL client in order to be able to upload and make changes to your database schema. MySQL clients that could be used include: the traditional MySQL client; MySQL shell; MySQL Workbench as well as phpMyAdmin. At the stage the most efficient of these clients will be MySQL Shell.
Sep
08
2022
In my previous blog post, ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database, I wrote about the ProcFS UDF MySQL plugin, which allows you to get operating systems stats, through the MySQL database, without having shell access to the server and any local agent installation.
Some of you wondered whether there is a way to use this goodness in Percona Monitoring and Management (PMM), and this blog post will show you exactly how to do that.
Unfortunately, at this point, Percona Monitoring and Management does not support the ProcFS UDF MySQL plugin out of the box. It is in the backlog, along with many other cool things. However, …
[Read more]