…-125552 INFO server_platform: x86_64 20120113-125552 INFO server_comment: (Source distribution wsrep_22.3.r3683) 20120113-125552 INFO Using…-dirty, not attempting to touch directories 20120113-132229 INFO Using mysql source tree: 20120113-132229 INFO basedir: /percona-xtradb-cluster 20120113-132229…
Comment: Open Development vs Making a Big Splash
May 22, 2009 By 28 Comments
…, in the comments): “Here’s one of the commits for the Maria instrumentation late last year: http://lists.mysql.com/commits/56225….co.uk/search?hl=en&safe=off&q=site%3Alists.mysql.com+mysql-6.0-perf&btnG=Search&meta=” So in fact…. Let’s look at when the tree was created – September 29 2008: http://lists.mysql.com/commits/54666 Since we have joined…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
…test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads. MySQL params are: innodb…net/~percona-dev/percona-xtradb/recovery-speed-hack/ tree. The patch by itself is quite small, …xtradb/recovery-speed-hack/revision/86 So your comments about patch is welcome! If it is stable…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… inserts are going in random locations in index tree which will require a lot of IO in … completely separate problem which can be fixed in MySQL 5.1 Data Clustering This again applies to … recent data scattered all across. Lookups Later in comments Brian mentions the point of benchmarks was rather …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… provides advanced functionality for MySQL. We have a team of dedicated MySQL developers working on the … time into these projects. Outside observers have commented that our development process doesn’t seem … maintaining the custom patches in our own tree and making our own builds, and there …
Comment: Countless storage engines
May 4, 2007 By 6 Comments
Vadim, My comments on this post. 1) PBXT: “Never update the row” as … their talk may be handling of long transactions (spilling bonsai tree to the disk may not be that efficient) and writing…) as I understand. P.S For Planet MySQL users who may think why Peter is Commenting Peter – original post was made by…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / … are interesting results I want to show graphics with comments READ_PK_POINT Query: SELECT name FROM $tableName … all scalability fixes exist in 5.1.16 tree. I think InnoDB team should solve this problem, …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql….) There are interesting results I want to show graphics with comments READ_PK_POINT Query: SELECT name FROM $tableName WHERE id… technic to retrieve rows (more details with Jim Starkey’s comments in Part 2). There MyISAM shows bad scalability with increasing…
Post: Percona builds with patches
July 24, 2008 By 16 Comments
…/ binary-amd64/ deb http://mysqlperformanceblog.com/mysql/debian/5.0/ source/ deb http://mysqlperformanceblog.com/mysql/debian/5.1/ binary-amd64/ deb…/mysql/RPM/. They are based on .spec file provided in MySQL source tree and should be compatible with SuSe, CentOS and RedHat. Your comments…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by …_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io… lock for each index tree. We may be able to disperse the lock using by the partitioning of MySQL. Added the following…
