Success is about Imagination

Postgres seems pretty cool as open source databases go. I’m finding a much greater affinity for Postgres than say MySQL. On the other...

Covering indexes are where all the columns needed are in the index and, in theory, only the index needs to be accessed. This seemingly...

The longer the timeline we show in the graph, either the more points we show or the larger granularity we use. For example if I show 1...

Summary Goal in this post is to layout a methodology that can be implemented to scan the explain plans and identify opportunities to...

MySQL is simpler than the Oracle example  because MySQL only has Nested Loops and doesn’t have Hash Join. Here is the query, like on the...

Looking at ways to programmatically analyze explain plans to see if adding indexes would help. The analysis is straight forward for for...

Had and old export dump file I wanted to import into RDS. I first tried to use S3 as a hosting site for the .dmp file and...

How does one check if there are missing indexes in a database? Is there a programatic way to do it? Explain Plan Most blogs on the...

trying to connect to SQL Server from my Mac so install sqlcmd: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mss...

Goal was to create a empty table and poplulate it with optimizer table and index stats from a poplulated table to try and get the...

Good reference on subject: https://blog.orapub.com/20150210/what-is-light-green-oracle-database-cpu-wait-time.html Below I’m comparing...

UPDATE: All slots for this study have been filled. On the other and would love your feedback. Please send any ideas about what you’d like...

Honeycomb.io turns out to be a nice solution for collecting, retrieving and displaying multi-dimensional time series data, i.e. the kind...

Amazon RDS Performance Insights (PI) doesn’t have a single pane of glass dashboard for clusters, yet. Currently PI has a dashboard that...

“delayed commit ok initiated” –  is a thread state in Aurora MySQL which indicates the thread has started the async commit process but is...

Installing CLI on LINUX 1. install PIP https://docs.aws.amazon.com/cli/latest/userguide/awscli-install-linux.html#awscli-install-linux-pi...

Thanks to Jeremiah Wilton for the following info: This wait event indicates that there is a thread which is waiting on an InnoDB record...

If you think so, check out shell script “ioh.sh” from github at  https://github.com/khailey/ioh Introduction and Goals The goal of ioh.sh...

I always forget IP address range coverage rules and forget where to look. It’s the wiki! https://en.wikipedia.org/wiki/Classless_Inter-Do...

How do you determine if the Oracle SQL optimizer has created a sub-optimal execution plan? re-run statistics and see what happens? wait...