…can benefit from multiple drives because of the different reason. If you’re using RAID10 – most commonly used RAID level for write intensive database…database which is stored on single disk. Assuming it is not fragmented it will take N tracks on…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…can‘t you will get great perfomance if not, you might become upset and become one of thouse bloggers. Note – any database…be done by data partitioning (ie old and rarely accessed data stored… multiple drives…On other hand join of few large tables, which is completely disk bound can be very slow. One…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…stored, and a search almost as efficient as a binary search can be…database “self tuning” or prefer to expose tuning options to be…can gain significantly with multiple IO threads on systems with large amount of hard drives…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… there is only one IO can be happening per file…drives you can‘t really get advantage of them unless you can get multiple…stored in controller cache and flushed to the disk in background – in this case there is little difference if we use one… database log writes but has much larger positive impact on…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…database Multi Versioning because only one old version per snapshot is needed while in databases you often would have multiple old versions of row stored…can be single SATA hard drive (and so you may be able to allow full database size for undo space without thinking). If such hard drive…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… expression, even non-distributable ones, can be broken into distributable …drive it home, SQL is relational algebra, and this algebra only operates on…table is used to store the results from …databases do 99.9% of the work, due to the multiple levels of result set reduction. Finally, Shard-Query can…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… IBM, “Clash of Database Egos” – Storage Engine developers showcase as one of keynotes….currently you may need to both store Compressed and Uncompressed versions of… as it currently does which can be multiple orders of magnitude faster for … were optimized on systems with 1-2 SATA drives so they are…
