Bits and pieces of John Dalton from all over your internet. - tagged with database http://johndalton.info/feed en-us http://blogs.law.harvard.edu/tech/rss Sweetcron john@johndalton.info How to debug InnoDB lock waits http://johndalton.info/items/view/9652/how-to-debug-innodb-lock-waits

This article shows you how to use a little-known InnoDB feature to find out what is holding the lock for which an InnoDB transaction is waiting. I then show you how to use an undocumented feature to make this even easier with innotop.

]]> Mon, 23 Jan 2012 16:15:00 -0600 http://johndalton.info/items/view/9652/how-to-debug-innodb-lock-waits How well does your table fit in innodb buffer pool? http://johndalton.info/items/view/8443/how-well-does-your-table-fit-in-innodb-buffer-pool ]]> Sun, 18 Sep 2011 06:32:00 -0500 http://johndalton.info/items/view/8443/how-well-does-your-table-fit-in-innodb-buffer-pool How well does your table fit in innodb buffer pool? http://johndalton.info/items/view/8343/how-well-does-your-table-fit-in-innodb-buffer-pool ]]> Fri, 16 Sep 2011 00:29:00 -0500 http://johndalton.info/items/view/8343/how-well-does-your-table-fit-in-innodb-buffer-pool Sample datasets for benchmarking and testing http://johndalton.info/items/view/8444/sample-datasets-for-benchmarking-and-testing ]]> Tue, 13 Sep 2011 09:55:00 -0500 http://johndalton.info/items/view/8444/sample-datasets-for-benchmarking-and-testing Sample datasets for benchmarking and testing http://johndalton.info/items/view/8258/sample-datasets-for-benchmarking-and-testing

This post contains links to a few different real-world datasets that can be used for populating databases for testing. The comments are good too, and include links to several more datasets.

]]> Sun, 11 Sep 2011 23:17:00 -0500 http://johndalton.info/items/view/8258/sample-datasets-for-benchmarking-and-testing Sharding techniques http://johndalton.info/items/view/7161/sharding-techniques

Overview of sharding techniques.

]]> Thu, 09 Jun 2011 20:17:00 -0500 http://johndalton.info/items/view/7161/sharding-techniques MySQLTuner http://johndalton.info/items/view/154/mysqltuner

Cool script, and coolest domain name/installation method in the world.

]]> Mon, 23 Mar 2009 21:20:00 -0500 http://johndalton.info/items/view/154/mysqltuner 32408df3sf