We are in 2019. Who uses triggers you may wonder? That's a valid question. But if you plan to do a database migration you may find them handy. Let's say that part of the migration you create new separate schema which you plan to use it for the new version. Or you could break one… Continue reading Triggers and deadlocks – MySQL
Category: Database
Deadlocks 101 – MySQL
Ahh deadlocks. Few words have the same impact as this in the software world. Doesn't matter if you're a DBA or developer you will get impatient. Some deadlocks take days for fixing, they are hard to reproduce, some of them reproduce only on prod machines. It's not unusual to do blind fixes, you just don't… Continue reading Deadlocks 101 – MySQL
B-Tree index structure
At some point we all worked with a relational database. We all had problems with query performance and we fixed them usually by first looking at indexes. We looked at the columns, at the foreign key for the presence of an index. We noticed there some kind of B-tree structure. Now I'm gonna explain how… Continue reading B-Tree index structure
Learn. Write. Repeat. 