May 23, 2012

Post: Slow Query Log analyzes tools

slowest queries it is important to find queries which cause largest load on the server, which is with certain level of accuracy queries which take most time to execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of

Post: Distributed Set Processing with Shard-Query

in parallel. Distributed set processing is database agnostic. Keep in mind, at each level of partitioning only a list ofMySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from the slowest