Understanding MySQL LTS and Innovation Releases
Choosing a MySQL version is no longer a simple matter of installing the latest release. MySQL now offers two distinct paths: the stability and predictable maintenance of Long-Term Support (LTS), or rapid access to new capabilities through Innovation releases. This article explains how the two tracks differ, how their version numbers evolve, and how to…
Installing MySQL 26.7 on Red Hat Enterprise Linux 9
This hands-on installation installs MySQL Community Server from the RPM bundle, configures a custom data directory, preserves SELinux protection, initializes the server, and explains how to set the initial administrative password.
Upgrading from Oracle 19c OCP to 26ai OCP Requires Only 1Z0-183, and It Is Not Difficult
Under Oracle’s certification upgrade policy, professionals who hold the Oracle Database 19c OCP certification can earn the Oracle AI Database 26ai OCP certification by passing a single upgrade exam: 1Z0-183: Oracle AI Database Administration Professional I took this exam in March this year and found it reasonably straightforward. I scored 80 and got my 26th certification from…
Why Move More Work Into the Database When the Database CPU Is Already Saturated?
The database CPU is already running at 100% utilization. You might expect adding more work to the database to make the system slower. Yet, as this example shows, the system can become faster. Let’s look at a demonstration. 1. SQL Driven by Java: When Database CPU Becomes the Bottleneck Let’s begin with the host CPU…
“Assessing Overall I/O Latency with Little’s Law” from My Book: Oracle Database PerformanceTuning with AWR, ASH, and ADDM
To give readers a taste of my book, Oracle Database Performance Tuning with AWR, ASH, and ADDM, I as sharing the section “Assessing Overall I/O Latency with Little’s Law” below. Little’s Law is a fundamental relationship in queueing theory: 
Table of Contents–Preview My Book: Oracle Database Performance Tuning with AWR, ASH, and ADDM
I am delighted to share that my new Oracle book, Oracle Database Performance Tuning with AWR, ASH and ADDM, will be published by Apress. For readers interested in the book, I will share a series of previews here. This second post covers the section “Table of Contents“ Table of Contents Front Matter About the Author…
How This Book Is Structured–Preview My Book: Oracle Database Performance Tuning with AWR, ASH, and ADDM
I am delighted to share that my new Oracle book, Oracle Database Performance Tuning with AWR, ASH and ADDM, will be published by Apress.For readers interested in the book, I will share a series of previews here. This second post covers the section “How This Book Is Structured.” How This Book Is Structured This book…
Why I Write This Book–Preview My Book: Oracle Database Performance Tuning with AWR, ASH and ADDM
I am delighted to share that my new Oracle book, Oracle Database Performance Tuning with AWR, ASH and ADDM, will be published by Apress. For readers interested in the book, I will share a series of previews here. This first post covers the section “Why I Write This Book.” Why I Write This Book An…
The “Poor Man’s” Oracle 26ai RAC on Proxmox
In production, building an Oracle RAC meant investing in an expensive Fibre Channel or iSCSI SAN (Storage Area Network) with dedicated physical hardware—costing thousands of dollars. For years, the “poor man’s” RAC was to use VMware with the multi-writer flag, Since VMware vSphere/ESXi is no longer truly free (the free version has limited features now),…
Scraped Through the Oracle Exadata X9M Implementation Specialist Exam (1Z0-902)
This week, I tackled the Oracle Exadata Database Machine X9M Implementation Essentials (1Z0-902) exam. With the passing score set at 64%, I emerged with a 65%. Some might call it a close shave; I console myself by calling it a perfectly calibrated effort for one of the most demanding certifications in the Oracle ecosystem. The…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
