Planet MariaDB Server
Configuring MySQL Query Metrics
Editors and technical reviewers suggested that I cover how to configure MySQL query metrics in chapter 1 of Efficient MySQL Performance, but I deferred because it was out of scope…
Accessing Complex Structures in MariaDB Server Code in bpftrace Probes – First Steps
I had already written many blog posts about bpftrace. All my public talks devoted to bpftrace included a slide about “problems”, and one of them usually sounded like this:…access to…
Accessing Complex Structures in MariaDB Server Code in bpftrace Probes – First Steps
I had already written many blog posts about bpftrace. All my public talks devoted to bpftrace included a slide about “problems”, and one of them usually sounded like this:…access to…
What is a database connection pool?
An explanation of database connection pools and how to use them in Java applications.
How to execute SQL queries from Java (and prevent SQL injections)
Instructions on executing SQL queries in Java and preventing SQL injections.
How to open and close JDBC connections
Guide on opening and closing JDBC connections in Java.
New YouTube channel on programming (mostly Java)
New YouTube channel focused on programming, especially Java.
Pedal to the metal or what else can speedup your CPU-bound application?
TL;DR Moving code and data sections to huge pages increases application performance without any source code modification. We are able to get +10%. It’s possible to quickly estimate the effect…
Adaptive Thread Pool: Improving MySQL Scalability With AI
In our previous blog post we discussed the purpose of a thread pool, various approaches to implementing a thread pool, along with a simulation model describing thread pool implementations in…
Efficient MySQL Performance
After 17 years with MySQL, I wrote a book: Efficient MySQL Performance. I’ll make a bold claim: a MySQL book like this has never been written—not even close. The preface…
How to replace `docker` with `podman` for PMM development
What is Podman? Podman is a daemonless container engine for developing, managing, and running OCI (Open Container Initiative) Containers on your Linux System. Containers can either be run as root…
Spinning in the Cloud: How to Fix MySQL 8.0 Log Commit for Containers
If you are running MySQL as a Kubernetes pod or a Docker container, there is a chance you are using CPU quota to limit its resource usage. Which is also…
MariaDB threadpool and NUMA scalability
MariaDB/MySQL default uses one thread per connection. This approach is generally good if the connection is active for a longer time. If the connections are short-lived then the cost of…
MariaDB threadpool and NUMA scalability
MariaDB/MySQL default uses one thread per connection. This approach is generally good if the connection is active for a longer time. If the connections are short-lived then the cost of…
Percona Supports Community Events – Organize Yours With Us!
One of the things we love doing in Percona is participating in community events and inspiring people to stay connected in the changing world. We have experience in organizing community…