… is simply because you are writing 4 times fewer B-tree values. The primary key and each secondary key each incur…-increment key, I would expect Inno to fill the B-tree pretty efficiently. With a 55GB buffer pool, we would expect… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… is using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce contention problems caused…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… closure table hierarchy to store regions in a database using MySQL and I’m wondering how can I create a unordered…. With the tree traversal, it is easy to do so because you’re “walking the path”. I’m using MySQL, PHP or…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… what is it aimed at. Index Condition Pushdown Traditional B-Tree index lookups have some limitations in cases such as range…
Post: Should we proclaim MySQL Community Edition Dead ?
July 1, 2008 By 34 Comments
… released in November 2007 – over 7 months ago. MySQL 5.0.51a and MySQL 5.0.51b security fixes were released but… have adapted my ways not to go to dev.mysql.com for MySQL downloads any more but go to mirror.provenscaling.com… community extensions which can’t ever get included in official MySQL tree and use that version instead. It is worth to mention…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… dramatic memory-to-disk threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation…-20110829081642-z0w992a0mrc62s6w (so you can find it in the bzr tree if you’re so interested). The first paragraph of the…, the new BLOB pages could have overwritten clustered index B-tree leaf pages that were freed during the update. If recovery…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
… Table. In Closure Table, we store every path in a tree, not only direct parent-child references, but also grandparent-grandchild… NOT IN (SELECT descendant FROM TreePaths WHERE ancestor = ‘D’); But MySQL complains: “You can’t specify target table ‘TreePaths’ for update… the same table in a single query in MySQL. But we can use MySQL‘s multi-table DELETE syntax, to find any…
Post: MySQL sources from development tree
January 9, 2007 By 1 Comment
… you get it, you can clone latest tree: bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0 New client supports “changes….0 mysql-5.0.30 Latest Falcon release is available on bk://mysql.bkbits.net/mysql-5.2-falcon Full list of available tree you can see here http://mysql.bkbits.com/
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… side variables one can create. Parse Tree The query is internally presented using parse tree inside MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL optimizations such as equity propagation and range expansion can cause Parse Tree to blow up in size…
