Dear Community, We are pleased to present the 20th build of MySQL server with Percona patches. Comparing to the previous release it… build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with…/$basearch/ gpgcheck=0 As usual you can download binaries and sources with the patches here http://www.percona.com/mysql/5.0.87-b20…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… these were fixed in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed. MySQL and Social Networks benchmarks… for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6.0 are different from MySQL 5.0…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99… particular those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There…
Page: Presentations
May 3, 2006 By
… MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0… planing on upgrading to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL Users Conference 2006, Santa Clara, CA This presentation was co-authered…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 24 Comments
Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted to post … later, plus it is quite handy in a way it presents information: SELECT CONCAT(table_schema, ‘.’, table_name), CONCAT(ROUND(table… whatever database you have active. It does not work with MySQL before 5.0 still of course 
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… Engines both looking at number of third party storage engine presented, main marketing message – Storage Engine partnership with IBM, “Clash of… test them and make binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems in some… subsystems. These are for MySQL 4.0 at this point but we hope to port some of them to MySQL 5.0+ Heikki also mentioned…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… it can for MyISAM. EXPLAIN may take long time In MySQL 5.0 with addition of greedy join the problem on looking at… some 100 rows/sec. No info about functions cost Since MySQL 5.0 you may use user functions in your query which may… output format is good but with growing MySQL Server complexity it is getting impossible to present all relevant information this way, so…
Post: XtraDB storage engine release 1.0.4-8
October 12, 2009 By 12 Comments
… glad to present you release 8 of XtraDB. The release includes following new features: The release is base on 1.0.4… for sponsoring and testing the port of XtraDB to 1.0.4 MySQL 5.1.39 as a base release Fixed bugs: Bugs… Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
Listening to Josh Berkus presentation on OSCON today I decided to take a closer look … big issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in 5.0.37 which I’d… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2
Post: Data Recovery Toolkit for InnoDB Version 0.1 Released
November 26, 2007 By 6 Comments
… pretty decent set of features: Supports both REDUNDANT (pre mysql 5.0) and COMPACT (mysql 5.0+) versions of tablespaces Works with single tablespaces and file… to another table and/or was partially destroyed Supports all MySQL data types except BLOBs, SETs and BITs (will be implemented… of the cases) Results are presented in CSV file format which could be used with MySQL‘s LOAD DATA function So, if…
