…Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL Community awards are presented by Monty and David in the conference …is refocused back on MySQL and the needs of the MySQL community covering other technologies, as it is relevant to MySQL users. MySQL, MariaDB, …
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
…, VP, MySQL Engineering for Oracle, will present an invited keynote on “Driving MySQL Innovation”. In addition, Oracle MySQL technologists will lead three breakout sessions on MySQL 5.6 at the Percona Live MySQL…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… announce the release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site… TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary was present… files were bigger than 4G on the source server. Bug fixed #1164979. Due to different implementation in MySQL 5.6 error messages…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will be on the following…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… files, that can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and… between taking a full backup and an incremental one were present in the full backup directory, and were not removed when…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics during the… for 5-minute snapshots of interesting MySQL topics. Cheer on the winners during the MySQL Community Awards presentations. Or just make the rounds of…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions… the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what fields where on what screen for… for a very basic formula that is mostly accurate, I present this: foreach field: 17+2*(strlen(field_name)+2) (bytes…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
… for MySQL Scalability” Webinar which will take place on May 1st at 10 a.m. PST. This will be an overview presentation, led by me and providing a high-level look at the components of MySQL scalability: application architecture, MySQL version and… Webinar! *** More info: MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… cache device. In this post and the next, I’ll present some of those results. Disclosure: The research and testing for… based on the documentation, it appears that they do not. I find the vCache implementation more useful than the one present in…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… at its finest — so generally the solution I presented to clients was a MySQL connection pool handling system for the application level… the time, running 10k concurrent connections and over 20k QPS on the master, which equated to serving >1B ad impressions per… and stability than life back in the days of MySQL 5.0.x. On that end, I’m in the process of…
