http://netvouz.com/henrik/tag/database?feed=rss henrik's bookmarks tagged "database" on Netvouz http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic_MySQL_Configuration An introduction to MySQL Computers > MySQL henrik Sat, 05 Mar 2011 08:37:11 GMT http://blog.cymen.org/2009/06/13/mysql-and-round-robin-database-rrd/ While looking for a MySQL RRD storage engine, I came across Round-Robin Database Storage Engine (RRD) (pdf) which describes how to setup a MySQL table to act as a RRD. The PDF appears to have been created in February of 2007 but the benchmark result at the end of 600 inserts/second says this was achieved on a 1350 MHz AMD CPU which suggests the article may be older. I replicated the configuration and tested it on my laptop (5400 RPM disk, 2.4 GHz Intel T7700 CPU). With the MyISAM database, a brieft test of about 50k inserts resulted in ~7000 inserts/second. But the 25m max rows means the trigger functionality (the part that makes the table behave like an RRD) wasn’t really tested. Development henrik Mon, 11 Jul 2011 20:17:52 GMT http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html You want to have a database schema where you can tag a bookmark (or a blog post or whatever) with as many tags as you want. Later then, you want to run queries to constrain the bookmarks to a union or intersection of tags. You also want to exclude (say: minus) some tags from the search result. Development henrik Sat, 11 Jun 2005 16:15:32 GMT http://www.javaperformancetuning.com/tips/jdbc.shtml#REF23 Java performance tuning tips relevent for tuning JDBC usage. Development > Java henrik Sun, 18 Dec 2005 07:22:03 GMT http://www.fromdual.ch/round-robin-database-storage-engine In a round-robin database (RRD) usually time-series data like network bandwidth, temperatures, CPU load etc. is stored. The data is stored in the way that system storage footprint remains constant over time. This avoids resource expensive purge jobs and reduces complexity. RRD MySQL does NOT yet provide this kind of storage engine. Although some people were thinking about and some prototypes exists. Nevertheless in this paper it is shown how you can build your own RRD tables: Round-Robin Database Storage Engine (RRD) Development henrik Mon, 11 Jul 2011 20:19:00 GMT http://www.javaworld.com/javaworld/jw-01-2008/jw-01-jpa1.html Development > Java henrik Tue, 03 Jun 2008 06:48:02 GMT http://wiitdb.com/ Download cover artwork for Nintendo Wii games Computers > Spelkonsoler henrik Wed, 17 Feb 2010 13:41:59 GMT