June 19, 2013

Post: Friends of Percona Get 20% Off at the MySQL Conference!

present — if I miss any, say something in the comments: Diagnosing and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond …

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… is true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text… in mind that I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception…: mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR 1795 (HY000): InnoDB presently supports…

Post: TPC-H Run on MySQL 5.1 and 6.0

… by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737… a Summary: We can see MySQL capabilities to run complex analytics queries, in particular those presented in TPC-H benchmark are still…

Post: Announcing Percona Server 5.5.27-29.0

… Server 5.5.27-29.0 on October 11th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-29.0 is now… introduced the innodb_sys_stats_root_page debugging option (only present in debug builds), rendering the previously-existing innodb_sys_stats…

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

…-life case studies for these kinds of architectures. InnoDB Compression: Present and Future - (Nizameddin Ordulu, Justin Tolmer, Facebook) — The Facebook guys… archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, Pythian) — This seems like a great 5.6…

Post: 5.0.87-build20 Percona binaries

Dear Community, We are pleased to present the 20th build of MySQL server with Percona patches. Comparing to the previous release it has following new features: The build is based on MySQL-5… and sources with the patches here http://www.percona.com/mysql/5.0.87-b20/ There is Debian packages repository is also…

Post: Should we give a MySQL Query Cache a second chance ?

… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… we can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… Query Cache content and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform performance…

Post: Percona Live MySQL Conference & Expo Was A Great Event

… in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years ago,” while Marco… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The… the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides will be available soon. Thanks…

Post: Percona MySQL University coming to Toronto this Friday!

… in the MySQL space. There will be talks covering topics like MySQL 5.6, MySQL in the Cloud and High Availability for MySQL, as well as Percona XtraDB Cluster for MySQL. We have… starting with MySQL all the way to those of you who are seasoned MySQL Experts. In addition to the conference presentations, we are…

Page: Presentations

… 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… general MySQL application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks…