#database

A little war story about debugging an Adjacency List. Deleting trees with cascade deletion. Visualizing the trees with graphviz.
Using IN is convenient, but can easily slow down your queries. Here's how to get around it!
TL;DR Make sure you increase innodb_buffer_pool_size from the stock value!
I've now run into trouble when using "localhost" as my database server address with a couple of unrelated database servers, namely MySQL and Microsoft SQL Server. At this point, it seems like a good rule of thumb to always use...
One of our clients has a MySQL server that sees moderate load. The MySQL server process often spikes one of the server's two CPUs. Without a lot of prior experience in tuning MySQL, I set out to figure out what was causing this...