kyle Hailey
Covering Indexes in Postgres
Covering indexes are where all the columns needed are in the index and, in theory, only the index needs to be accessed. This seemingly...
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
- May 22, 2020
- 2 min
Granularity impact on visualization
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...
2 views0 comments
kyle Hailey
- Mar 30, 2020
- 14 min
Where to add Index on Postgres
Summary Goal in this post is to layout a methodology that can be implemented to scan the explain plans and identify opportunities to...
11 views0 comments
kyle Hailey
- Mar 24, 2020
- 5 min
Indexes on Joins for MySQL
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...
2 views0 comments
kyle Hailey
- Mar 23, 2020
- 11 min
Indexes for Joins on Oracle
Looking at ways to programmatically analyze explain plans to see if adding indexes would help. The analysis is straight forward for for...
12 views0 comments
kyle Hailey
- Mar 2, 2020
- 4 min
Oracle Imp (import) to RDS
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...
2 views0 comments
kyle Hailey
- Jan 29, 2020
- 2 min
Index Advisor ? PostgreSQL, Oracle and SQL Server : yes , MySQL : no
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...
11 views0 comments
kyle Hailey
- Jan 23, 2020
- 1 min
SQLcmd on my Mac: Seg fault
trying to connect to SQL Server from my Mac so install sqlcmd: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mss...
2 views0 comments
kyle Hailey
- Jan 22, 2020
- 7 min
MySQL – manually updating table and index optimizer statistics
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...
0 views0 comments
kyle Hailey
- Apr 26, 2019
- 61 min
Oracle: compare DB Time and CPU time to ASH
Good reference on subject: https://blog.orapub.com/20150210/what-is-light-green-oracle-database-cpu-wait-time.html Below I’m comparing...
74 views0 comments
kyle Hailey
- Apr 10, 2019
- 1 min
Want to change the future Amazon RDS performance monitoring?
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...
4 views0 comments
kyle Hailey
- Apr 3, 2019
- 3 min
Honeycomb.io for DB Load and Active Sessions
Honeycomb.io turns out to be a nice solution for collecting, retrieving and displaying multi-dimensional time series data, i.e. the kind...
9 views0 comments
kyle Hailey
- Mar 28, 2019
- 5 min
Amazon RDS cluster dashboard with Performance Insights
Amazon RDS Performance Insights (PI) doesn’t have a single pane of glass dashboard for clusters, yet. Currently PI has a dashboard that...
5 views0 comments
kyle Hailey
- Jan 11, 2019
- 1 min
“delayed commit ok initiated” – Aurora MySQL
“delayed commit ok initiated” – is a thread state in Aurora MySQL which indicates the thread has started the async commit process but is...
98 views0 comments
kyle Hailey
- Dec 11, 2018
- 3 min
CLI for Amazon RDS Performance Insights
Installing CLI on LINUX 1. install PIP https://docs.aws.amazon.com/cli/latest/userguide/awscli-install-linux.html#awscli-install-linux-pi...
49 views0 comments
kyle Hailey
- Sep 18, 2018
- 2 min
Aurora MySQL synch/mutex/innodb/aurora_lock_thread_slot_futex wait
Thanks to Jeremiah Wilton for the following info: This wait event indicates that there is a thread which is waiting on an InnoDB record...
0 views0 comments
kyle Hailey
- Jan 25, 2018
- 13 min
Is NFS on ZFS slowing you down?
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...
5 views0 comments
kyle Hailey
- Nov 3, 2017
- 1 min
IP CIDR rules and address ranges
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...
1 view0 comments
kyle Hailey
- Oct 18, 2017
- 2 min
Best method for tuning sub-optimal execution plans
How do you determine if the Oracle SQL optimizer has created a sub-optimal execution plan? re-run statistics and see what happens? wait...
8 views0 comments
kyle Hailey
- Sep 29, 2017
- 1 min
Oaktable World 2017 @ Oracle Open World
http://www.oaktable.net/blog/oak-table-world-2017-oracle-open-world The Oak Table members will be discussing their latest technical...
0 views0 comments
bottom of page