kyle Hailey
psql: Guardrails between PROD and TEST
This took way longer than I wanted But I've got access to Prod and to Dev I haven't gotten automated changes and change logging in yet...
top of page
Kyle Hailey: Imagination Creation
kyle Hailey
- Mar 9
- 2 min
Stability.ai & Future of AI imaging
Stability.ai bought clipdrop Stability AI Makes its First Acquisition in a Generative AI Startup, Init ML Somehow, ClipDrop is supposed...
1 view0 comments
kyle Hailey
- Feb 2
- 1 min
Visual SQL Tuning
http://datavirtualizer.com/2015/06/ https://blog.latitude.so/ai-sql/ https://github.com/varunshenoy/GraphGPT https://platform.openai.com/...
13 views0 comments
kyle Hailey
- Sep 20, 2022
- 2 min
New works by John Williams Waterhouse “discovered”
Is there an artist you liked, but would love to have seen more works by? I always liked John William Waterhouse and wished there were...
3 views0 comments
kyle Hailey
- Jun 30, 2022
- 2 min
DataDog – the marriage of ASH, Query Stats and UI
I’m so happy to be working at Datadog ( and we are hiring so ping me if interested. Looking for Python developers who are interested in...
6 views0 comments
kyle Hailey
- Jun 29, 2022
- 4 min
Are some MySQL wait events actually CPU time ?
Sure, wait event times in any database will include some CPU time, though ideally it should be minimal. Waits should be instrumented as...
7 views0 comments
kyle Hailey
- Jun 22, 2022
- 1 min
JDBC Request: Cannot load JDBC driver class’com.mysql.jdbc.Driver’ solution
Just quick post to document a troublesome error when running Jmeter on Mysql JDBC Request: Cannot load JDBC driver...
0 views0 comments
kyle Hailey
- Apr 15, 2022
- 3 min
Setting up Always ON (SQL Server)
There is a great little docker setup that starts Always On (SQL Servers instance replication not to be confused with their article i.e....
3 views0 comments
kyle Hailey
- Apr 13, 2022
- 4 min
introducing network latency on Docker (SQL Server Always On testing)
I am testing out Always On replication on SQL Server with a cool docker setup that includes primary and secondary https://github.com/rafa...
3 views0 comments
kyle Hailey
- Mar 25, 2022
- 11 min
MySQL : events_waits_current – who is waiting and who is on CPU
Anyone familiar with Oracle performance tuning knows about ASH , aka active session history. ASH saves a history of every session that is...
1 view0 comments
kyle Hailey
- Mar 24, 2022
- 12 min
MySQL -> what to do with NESTING_EVENT_ID
How does one use NESTING_EVENT_ID? Below I’ve selected from events_waits_history_long for a single thread, but none of the ...
0 views0 comments
kyle Hailey
- Mar 23, 2022
- 6 min
MySQL waits and CPU
Question: how do I know that one user is waiting for a lock and another user is burning CPU on MySQL? i.e. how can I create active...
4 views0 comments
kyle Hailey
- Jul 13, 2021
- 1 min
Postgres performance gone south but nothing changed !
Postgres seems pretty cool as open source databases go. I’m finding a much greater affinity for Postgres than say MySQL. On the other...
0 views0 comments
kyle Hailey
- Jun 19, 2020
- 2 min
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...
1 view0 comments
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...
0 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...
0 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...
0 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...
1 view0 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...
0 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...
1 view0 comments
bottom of page