top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Jan 29, 20202 min read
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...
36 views0 comments
kyle Hailey
Jan 23, 20201 min read
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...
10 views0 comments
kyle Hailey
Jan 22, 20207 min read
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...
6 views0 comments
kyle Hailey
Apr 26, 201961 min read
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...
853 views0 comments
kyle Hailey
Apr 10, 20191 min read
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...
17 views0 comments
kyle Hailey
Apr 3, 20193 min read
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...
49 views0 comments
kyle Hailey
Mar 28, 20195 min read
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...
23 views0 comments
kyle Hailey
Jan 11, 20191 min read
“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...
446 views0 comments
kyle Hailey
Dec 11, 20183 min read
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...
669 views0 comments
kyle Hailey
Sep 18, 20182 min read
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...
10 views0 comments
kyle Hailey
Jan 25, 201813 min read
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...
9 views0 comments
kyle Hailey
Nov 3, 20171 min read
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...
5 views0 comments
kyle Hailey
Oct 18, 20172 min read
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...
19 views0 comments
kyle Hailey
Sep 29, 20171 min read
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...
4 views0 comments
kyle Hailey
Mar 17, 20176 min read
benchmarking your disks
While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine,...
5 views0 comments
kyle Hailey
Mar 9, 20173 min read
Postgres monitoring script pgmon.sh
photo by Thomas Hawk https://github.com/khailey/pgmon $ ./pgmon.sh Usage: pgmon.sh [username] [password] [host] <sid=postgres>...
156 views0 comments
kyle Hailey
Feb 27, 20171 min read
Example Jmeter workload for Postgres and Oracle
pgload.jmx is JMX file you can load into Jmeter and run a substantial load on a Postgres database. Should work just as well on Oracle if...
139 views0 comments
kyle Hailey
Feb 12, 20171 min read
9th Circuit Court Ruling 3-0
Little did I know this building that captured my visual attention and imagination so many times walking to work over the last 6 months...
1 view0 comments
kyle Hailey
Jan 6, 20171 min read
jmeter – Variable Name must not be null in JDBC Request
So Jmeter seems super cool. I’ve only used it a little bit but it does seem a bit touchy about somethings (like spaces in input fields)...
172 views0 comments
kyle Hailey
Jan 5, 20173 min read
jmeter – getting started
This blog post is just a start at documenting some of my experiences with jmeter. As far as load testing tools go, jmeter looks the most...
11 views0 comments
bottom of page