(Vlad Mihalcea) Last week, one of my blog readers asked me of a way to reuse the @Id mapping so that it won’t have to be declared on each an every entity.
Tag: Open Source
MySQL Queries No Waiting
(Dave Stokes) Last time we looked at SKIP LOCKED where rows locked by another process were skipped. NOWAIT informs the server to return immediately IF the desired rows can not be locked.
In-memory insert benchmark for InnoDB on a small server: MySQL 5.0 to 8.0
(Mark Callaghan) This post explains performance for the insert benchmark with InnoDB from MySQL versions 5.0 to 8.0. The goal is to understand how performance has changed across releases. This uses an in-memory workload with an i3 NUC and i5 NUC. The i5 NUC is newer and faster. The next post covers
HAProxy Connections vs MySQL Connections – What You Should Know
(Ashraf Sharif) Having a load balancer or reverse proxy in front of your MySQL or MariaDB server does add a little bit of complexity to your database setup, which might lead to some, things behaving differently. Theoretically, a load balancer which sits in front of MySQL servers (for example an HAPr
SKIP LOCKED
(Dave Stokes) SKIP LOCKED is a new feature in MySQL 8 that many will find valuable. If allows you to not wait about for locked records and work on what is available — the unlocked records.
How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL
(Vlad Mihalcea) Last week, Burkhard Graves asked me to answer the following StackOverflow question:
Reserved Words
(Peter Gulutzan) In the 1990s C.J.Date said: “The rule by which it is determined within the standard that one key word needs to be reserved while another need not be is not clear to this writer.”
Top Performance Metrics to Monitor on MySQL (Connections & Buffer Pool Usage)
(Shree Nair) As a DBA, your top priority is to keep your databases and dependent applications running smoothly at all times. To this end, your best weapon is judicious monitoring of key performance metrics.
MySQL 8.0.3: Binary logging and Replication chains are now enabled by default
(Narendra Chauhan) MySQL 8.0.3 release candidate is out with amazing new replication features, along with changes in couple of replication default options. Thanks to our users for their constant feedback and valuable inputs, MySQL is changing defaults whenever possible to remove configuration overhe
MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0
(Peter Zaitsev) In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0.