kyle Hailey
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...
top of page
Success is about Imagination
Ignite Your Passion
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...
13 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...
6 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...
1 view0 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...
136 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...
5 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...
11 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...
8 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...
144 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...
114 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...
2 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
kyle Hailey
- Mar 17, 2017
- 6 min
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,...
2 views0 comments
kyle Hailey
- Mar 9, 2017
- 3 min
Postgres monitoring script pgmon.sh
photo by Thomas Hawk https://github.com/khailey/pgmon $ ./pgmon.sh Usage: pgmon.sh [username] [password] [host] <sid=postgres>...
21 views0 comments
kyle Hailey
- Feb 27, 2017
- 1 min
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...
21 views0 comments
kyle Hailey
- Feb 12, 2017
- 1 min
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, 2017
- 1 min
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)...
4 views0 comments
bottom of page