One of the things that often come up while thinking about query optimization is the order of execution. When the database get’s the query – how...
Continue reading...Blog
Stuck in on-disk limbo: “Searching for Rows to Update”
I must describe, as this was a production server at a company I was working for at the time. All relevant screenshots that would identify it...
Continue reading...I suck at this blogging.
Trying to get back into a habit is pretty hard. Here we go!
Continue reading...Covid-19 and opportunity for learning
With the current situation being what it is, I see more people panicking about what they might not have in the next coming weeks, rather than...
Continue reading...Optimizer, what are you doing?
Note: I am currently working on setting up a generic example of this behavior – so please forgive the lack of detail. I recently started a...
Continue reading...New Years Day 2020: Evolution
I’m a big fan of traditional superstitions. On the days prior to Jan 1, I spend all of my time cleaning the house. I set up...
Continue reading...What is your Old-World Skill?
As technologist we create things out of air. . . Okay – I know it’s all bits and boolean logic built on top of semi-conductors, but...
Continue reading...Organizing Thoughts
One of the biggest problems with being employed at a single company for a long period of time is there is only the experience provided by the problems at hand.
Continue reading...Getting Started: Hardware.
The foundation for any change in variables is the hardware, the OS, and the file system.
Continue reading...You can put lipstick on a .cnf
The point of organizing the my.cnf file in this way is to make use of patterns. The hostname and IP serve as the pattern for all other identifying variables in the configuration file.
Continue reading...