… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… hot run, as hash indexes are faster than a b-tree index. Also accessing pages from the buffer pool should be… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… first MySQL user conference independently organized by MySQL AB. It was called the “MySQL Users Conference” and took place at the Double Tree hotel… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated…
Comment: Is your MySQL Server Loaded ?
April 15, 2013 By 6 Comments
Also look at this bug report I made recently: http://bugs.mysql.com/bug.php?id=68963, as I have had issue with not seeing the wood for the trees so to speak because of a high number of running slaves on the server.
Post: Where to get a BZR tree of the latest MySQL releases
August 16, 2012 By 1 Comment
… to be exact mirrors of the lp:mysql-server trees, except where the lp:mysql-server trees lag behind or differ in some indeterminate… tree differs as MySQL 5.1.65 has been released but the last tagged release in the lp:mysql-server/5.1 tree is MySQL… with the Oracle lp:mysql-server/X tree if/when that becomes available. The 5.6 tree also differs, as MySQL 5.6.6…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server Development Services… and prevention. Percona we can help you maintain your own tree or take the project over completely. Your features can remain…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… when using a CMS where DB structure is prepdefined A: MySQL Server will not automatically define any indexes for you. Hopefully… some cases for better index usage. Q: Is the b+ tree innodb index a single or double linked list at the…
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 18 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…
