#mysql

A little war story about debugging an Adjacency List. Deleting trees with cascade deletion. Visualizing the trees with graphviz.
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...