…for one client; the slow log contains 6300 seconds’ worth of queries, and the two main queries for…optimize for one access method to the data at some significant cost in complexity and maintenance (which might be worth it) but not for… pages is no extra work for the database. In this model, you …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… look at Disk Based databases all data accesses are treated as IOs – it… first thing to consider – single client work load does not necessary…most commonly used RAID level for write intensive database systems, you will … seek time optimizations come from the striping – consider 100GB database which is …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…for “real-time” analysis. Our customers often want their systems to provide the freshest data to their own clients… If you can’t get access to the time of day…files, and build support in the database for one or two capabilities you …to use it for things that it’s not 100% optimal for. But …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…for the demos, if you want to reload on your favorite storage engine or database About the cluster For…40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( …for queries which access a significant amount of data. One big reason for…, get a good plan optimizer-prune-level=0 …
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… client program? I have run into a handful of scenarios where this was desirable. For example, sometimes there is no access to the database server. I’ve seen this when access was forbidden by management… nothing to do with the task you’re trying to optimize or analyze. You might also be interested in gathering data…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
… database deals with on disk data it often uses different set of algorithms which are optimized…again stops working as soon as page accesses cause disk IO. Escalated Locking/Latching …does for concurrent (multi CPU, multi client) processing. Database Locks/Latches are typically designed to be held for…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…Better response times: This is very important for database performance and I appreciate that Virident has… However at this point, I have no access to Fusion-io ioDrive2, which is …Client: HP ProLiant DL380 G6, sysbench v5 Of course, our Percona Server was optimized for Flash cards, with variations for…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…No PZ: Another possible area of optimization. I frequently see batch jobs… when it notices an ascending access pattern that passes an extent boundary… clients and insert values 50 or so at a time. HT: For most… applications to other database brands. Maybe in some denormalized database (for example, if …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… That kind of access is so common in files. The wear leveling is used for flash memories. I…just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old…run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may last way too long for your 150…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…ad-hoc (can access any columns) and it seems tailor-made for a column-oriented database. I decided … matter for this test. The “Knowledge Grid” architecture seems ideal for the types of queries the client runs…It’s a complete server with a different optimizer, etc. This point was hammered home during …
