kyle HaileyMar 24, 202212 minMySQL -> what to do with NESTING_EVENT_IDHow does one use NESTING_EVENT_ID? Below I’ve selected from events_waits_history_long for a single thread, but none of the ...
kyle HaileyMar 23, 20226 minMySQL waits and CPUQuestion: 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...
kyle HaileyJul 13, 20211 minPostgres 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...
kyle HaileyJun 19, 20202 minCovering Indexes in PostgresCovering indexes are where all the columns needed are in the index and, in theory, only the index needs to be accessed. This seemingly...