The Curious Engineer

Percona

2010–2013

1,327 posts

← 2006–2009 2014–2017 →

2013 410

December 2013

  1. Percona Monitoring Plugins 1.1.1 release (enterprise-grade MySQL monitoring and graphing)
  2. [ERROR] mysqld: Sort aborted: Server shutdown in progress
  3. 2 cases for MySQL server overload
  4. Renaming database schema in MySQL
  5. MySQL 5.7.3 milestone release fixes some of my pet peeves
  6. Percona Server 5.5.35-33.0 is now available
  7. Percona Server 5.1.73-14.11 is now available
  8. Percona Toolkit 2.2.6 is now available
  9. Percona Server 5.6.15-63.0 is now available
  10. Automatic replication relaying in Galera 3.x (available with PXC 5.6)
  11. Percona Monitoring Plugins 1.1, now with Zabbix support
  12. Percona XtraDB Cluster 5.6.15-25.2 first Release Candidate is now available
  13. Seconds_Behind_Master fluctuating wildly? Check for events caught in a loop
  14. One more InnoDB gap lock to avoid
  15. A sneak peek at the Percona Live MySQL Conference & Expo 2014
  16. December 17 Webinar: Use Your MySQL Knowledge to Become a MongoDB Guru
  17. Q&A: Geographical disaster recovery with Percona Replication Manager
  18. Linux performance tuning tips for MySQL
  19. Nominate Tokutek for the 7th Annual Crunchies Awards
  20. December 10 Webinar: Understanding Indexing
  21. Multi-Data Center MySQL with Continuent Tungsten: Dec. 11 webinar
  22. Percona XtraDB Cluster 5.5.34-25.9 is now available
  23. INFORMATION_SCHEMA: innodb_stats_on_metadata and slow queries
  24. Download insightful MySQL presentations from Percona Live London 2013
  25. Useful MySQL 5.6 features you get for free in PXC 5.6

November 2013

  1. MySQL Error: Too many connections
  2. Recap from MongoDB DC User Group Meetup on TokuMX and MongoDB
  3. Percona XtraBackup – A workaround to the failed assertion bug
  4. Geographical disaster recovery with PRM: Register for Dec. 4 Webinar
  5. Percona XtraBackup 2.1.6 is now available
  6. New wsrep_provider_options in Galera 3.x and Percona XtraDB Cluster 5.6
  7. Integrating pt-online-schema-change with a Scripted Deployment
  8. Percona XtraDB Cluster 5.6.14-25.1 Beta is now available
  9. How to add VIPs to Percona XtraDB Cluster or MHA with Pacemaker
  10. November 20 Webinar: 5 Pitfalls to Avoid with MongoDB
  11. What does the ‘Incorrect key file for table’ error mean?
  12. MySQL encryption performance, revisited
  13. Percona Live London 2013 and Percona Live MySQL Conference & Expo 2014
  14. MySQL & Sphinx: Register now for Nov. 20 Webinar
  15. Drupal and MySQL Performance: Register now for Nov. 13 webinar
  16. Incremental backups with log archiving for XtraDB
  17. How Percona tested Percona Server 5.6: A world premiere in advanced testing
  18. QA: Advanced Option Combinatorics (Pairwise Testing): Combinatorial mysqld Option Test Case Generation
  19. How to Extract All Running Queries (Including the Last Executed Statement) from a Core File?
  20. Put your MySQL Knowledge to Good Use with Tim Callaghan at Percona Live-London, November 12
  21. Using per-query variable statements in Percona Server
  22. Four Benefits of TokuMX Transactions for MongoDB Applications
  23. FOSDEM 2014 – MySQL & Friends Devroom
  24. Introducing Percona Cloud Tools for MySQL
  25. How to recover an orphaned .ibd file with MySQL 5.6
  26. Percona XtraDB Cluster 5.5.34-23.7.6 is now available
  27. Quick link to Percona Toolkit bugs

October 2013

  1. Introducing TokuMX Transactions for MongoDB Applications
  2. Percona XtraDB Cluster/ Galera with Percona Monitoring Plugins
  3. November 6 Webinar: 5 Pitfalls to Avoid with MySQL and Big Data
  4. InnoDB adaptive flushing in MySQL 5.6: checkpoint age and io capacity
  5. MySQL on Windows: A survival guide for Linux-based DBAs
  6. MySQL 5.6 New Replication Features: Webinar followup Q&A
  7. Percona Server 5.5.34-32.0 is now available
  8. Percona Server 5.1.72-14.10 is now available
  9. Percona Server 5.6.14 with TokuDB 7.1 Experimental build
  10. The Genius of MongoDB
  11. Percona Server 5.6.14-62.0 is now available
  12. Problems with Multiple XA Storage Engines in MySQL 5.6
  13. High Availability Options for MySQL – October 2013 Update
  14. New MySQL features, related technologies at Percona Live London
  15. The power of MySQL GROUP_CONCAT
  16. Designing one to many relations – MongoDB vs MySQL
  17. Percona Playback 0.7 is now available
  18. MySQL 5.6’s new replication features: Benefits, Limitations and Challenges
  19. MySQL Spatial Functions for Geo-Enabled Applications
  20. Announcing TokuMX v1.3
  21. InnoDB scalability issues due to tables without primary keys
  22. Percona Toolkit 2.2.5 is now available
  23. Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync
  24. Visit Tokutek at MongoDB Boston on October 25
  25. Interactive Debugging of Transaction Conflicts with TokuDB
  26. utf8 data on latin1 tables: converting to utf8 without downtime or double encoding
  27. Using keepalived for HA on top of Percona XtraDB Cluster
  28. Announcing TokuDB v7.1
  29. Innotop: A real-time, advanced investigation tool for MySQL
  30. Percona Server 5.6 Webinar: Enterprise-grade MySQL
  31. Introducing TokuMX Clustering Indexes for MongoDB
  32. Percona Monitoring Plugins 1.0.5 release for MySQL
  33. code.openark.org
  34. Handling long-running queries in MySQL with Percona XtraBackup
  35. SSL Performance Overhead in MySQL
  36. Stewart is speaking at OSDC 2013 in Auckland!
  37. Percona team to attend Buenos Aires MySQL conference Oct. 15-16
  38. My Percona Live UK 2013 Tutorial: MySQL DBA In A Nutshell! Hands On!
  39. A closer look at Percona Server 5.6
  40. Taking backups on Percona XtraDB Cluster (without stalls!)
  41. Percona Server 5.6.13-61.0 first GA release is now available
  42. Tuning MySQL 5.6 configuration – Webinar followup
  43. How can we bring query to the data?
  44. The benefits of a drop-in compatible MySQL alternative
  45. A TokuDB Stall Caused by Conflicting Transactions When Opening a Table
  46. Inexpensive SSDs for Database Workloads
  47. October 8 Webinar: Getting Started with MySQL
  48. MySQL 5.7 multi-source replication
  49. Oracle Speakers at Percona Live London 2013
  50. Join my Oct. 2 webinar: ‘Implementing MySQL and Hadoop for Big Data’

September 2013

  1. What’s your Percona story?
  2. Experimental GIT Mirrors of Percona XtraBackup, Percona Server plus Oracle MySQL trees
  3. How we built TokuMX
  4. Experimental Git mirror of Oracle MySQL trees
  5. September 26 Webinar: Getting Started with MongoDB
  6. How to reclaim space in InnoDB when innodb_file_per_table is ON
  7. TokuMX Hot Backup – Part 3
  8. MySQL 5.6 Configuration Optimization Webinar, Sept. 25
  9. Percona XtraDB Cluster: Setting up a simple cluster
  10. Percona Server 5.6.13-60.6 fourth Release Candidate is now available
  11. A TokuDB Stall Caused by a Big Transaction and How It was Fixed
  12. InnoDB Performance Optimization Basics – Updated
  13. Percona XtraBackup 2.1.5 is now available
  14. TokuDB Hot Backup – Part 2
  15. Let’s connect at MySQL Connect
  16. Percona XtraDB Cluster 5.5.33-23.7.6 is now available
  17. Lock Diagnostics and Index Usage Statistics in TokuMX v1.2.1
  18. Percona Live London 2013: an insider’s view of the schedule
  19. OSS4B – Presenting in Italy on MySQL and Percona XtraDB Cluster
  20. Switching between versions using yum
  21. 5 reasons why MySQL replication lag is flapping between 0 and XXXXX
  22. Enabling crash-safe slaves with MySQL 5.6
  23. MySQL webinar: ‘Introduction to open source column stores’
  24. TokuDB Hot Backup – Part 1
  25. Percona Server 5.6-RC3 with TokuDB 7.0.4 – experimental build
  26. How to move the InnoDB log sequence number (LSN) forward
  27. TokuMX vs. MongoDB : In-Memory Sysbench Performance
  28. How InnoDB promotes UNIQUE constraints
  29. September: A busy month for MySQL events
  30. Introduction to Percona XtraBackup 2.1 (MySQL webinar & more)
  31. Speak at Percona Live London: Call for papers deadline Sept. 8
  32. TokuDB vs InnoDB in timeseries INSERT benchmark
  33. Announcing TokuMX v1.2: Hot Backup
  34. Here’s my favorite secret MySQL 5.6 feature. What’s yours?
  35. Percona XtraBackup 2.0.8 is now available
  36. Running MySQL 5.6 on Amazon RDS: Webinar followup questions answered
  37. Percona Server 5.6.13-60.5 third Release Candidate is now available

August 2013

  1. Considering TokuDB as an engine for timeseries data
  2. Testing Intel, Samsung & SanDisk SATA SSD
  3. Percona Server 5.1.71-14.9 is now available!
  4. Percona Server 5.5.33-31.1 is now available
  5. MySQL Security Webinar: Follow-up Q&A
  6. Amazon RDS with MySQL 5.6 – Configuration Variables
  7. Why is the ibdata1 file continuously growing in MySQL?
  8. MySQL 5.6 security vs ease of use
  9. MySQL Security: Armoring Your Dolphin
  10. TokuMX tip: Create any field name you want
  11. Percona University at Washington, D.C. – Sept. 12
  12. Getting Percona PAM to work with Percona Server & its client apps
  13. Want to archive tables? Use Percona Toolkit’s pt-archiver
  14. Can you really be Bias free ?
  15. Percona XtraBackup 2.1.4 is now available
  16. The top 5 proactive measures to minimize MySQL downtime
  17. Big Data with MySQL and Hadoop at MySQL Connect 2013
  18. Building TokuMX and TokuDB for Production
  19. Percona Server 5.6 Webinar follow-up and Q&A
  20. John Cesario of Go Daddy on Percona MySQL Training
  21. Slides from Boston MongoDB User Group Meetup on 7/31/13
  22. Advanced MySQL Query Tuning: Webinar followup Q&A
  23. Percona celebrates its 7th anniversary by giving to open source ecosystem
  24. Schema Design in MongoDB vs Schema Design in MySQL

July 2013

  1. InnoDB Full-text Search in MySQL 5.6: Part 3, Performance
  2. Let’s talk about Percona Server 5.6: Enterprise Grade MySQL (webinar)
  3. Why it’s beneficial to attend MySQL conferences
  4. Your troubles are over, pt-heartbeat 2.1
  5. Checking B+tree leaf nodes list consistency in InnoDB
  6. Percona Monitoring Plugins 1.0.4 release: Now with Galera graphs
  7. Growth of Percona software releases
  8. TokuMX 1.0.3: Seamless Migrations from MongoDB
  9. Another reason why SQL_SLAVE_SKIP_COUNTER is bad in MySQL
  10. Comparing MongoDB, MySQL, and TokuMX Data Layout
  11. What kind of queries are bad for MySQL?
  12. Percona Toolkit 2.1.10 is now available
  13. MySQL Webinar: Advanced Query Tuning
  14. Percona Toolkit 2.2.4 is now available
  15. Recovering temporal types in MySQL 5.6: TIME, TIMESTAMP and DATETIME
  16. An Ubuntu PPA of daily builds of Percona XtraBackup
  17. Why Unique Indexes are Bad
  18. Crash-resistant replication: How to avoid MySQL replication errors
  19. innotop 1.9.1 released
  20. MySQL and Hadoop Integration
  21. MySQL Webinar: 5 proactive measures to help minimize MySQL downtime, July 17
  22. How TokuMX Gets Great Compression for MongoDB
  23. LVM read performance during snapshots
  24. Poll: What programming languages and platforms do you use?
  25. Schema changes – what’s new in MySQL 5.6?
  26. Percona XtraDB Cluster operations MySQL Webinar follow-up questions anwsered
  27. Percona Server 5.1.70-14.8 now available
  28. When it’s faster to use SQL in MySQL NDB Cluster over memcache API
  29. Percona Server 5.5.32-31.0 now available
  30. TokuMX Fractal Tree(R) indexes, what are they?
  31. tpcc-mysql: Simple usage steps and how to build graphs with gnuplot

June 2013

  1. Percona Toolkit 2.2.3 released; bug fixes include pt-online-schema-change
  2. 2 new features added to Percona XtraDB Cluster (PXC) since 5.5.31
  3. Percona Server 5.6.12-60.4 second Release Candidate now available
  4. Limited disk space? Compact backups with Percona Xtrabackup 2.1
  5. TokuMX is MongoDB on steroids
  6. Percona XtraDB Cluster 5.5.31-23.7.5 now available
  7. pt-online-schema-change and binlog_format
  8. Setting up MySQL SSL and Secure Connections
  9. Changing an async slave of a PXC cluster to a new Master
  10. Announcing TokuMX v1.0: Toku+Mongo = You Can Have It All
  11. What technologies are you running alongside MySQL?
  12. MySQL Webinar: Percona XtraDB Cluster Operations, June 26
  13. Woxxy’s dev blog
  14. Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
  15. Call for papers: Percona Live London
  16. Percona MySQL University @Portland next Monday!
  17. Announcing TokuDB v7 Enterprise Edition: Hot Backup and Support
  18. How people are using MySQL… from 1 user to 100 million (upcoming conference talk)
  19. Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
  20. Migrating between MySQL schemas with Percona Xtrabackup
  21. Choosing a MySQL HA Solution – Post-Webinar Q&A
  22. Private, custom Percona MySQL Training
  23. iiBench Benchmark: TokuMX vs. MongoDB
  24. Summertime Percona MySQL training update
  25. Implementing SchemaSpy in your MySQL environment
  26. Percona Server 5.6.11-60.3 first Release Candidate now available
  27. TokuMX: Fractal Trees with MongoDB
  28. MySQL Query Patterns, Optimized – Webinar questions followup

May 2013

  1. The small improvements of MySQL 5.6: Duplicate Index Detection
  2. Replication in MySQL 5.6: GTIDs benefits and limitations – Part 2
  3. How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
  4. Sysbench Benchmark for MongoDB – v0.1.0 Performance Update
  5. Choosing a MySQL HA Solution – MySQL Webinar: June 5
  6. Percona Server for MySQL 5.5.31-30.3 now available
  7. ZFS on Linux and MySQL
  8. Experiences with the McAfee MySQL Audit Plugin
  9. Percona XtraBackup 2.1.3 for MySQL available for download
  10. Percona MySQL University @Portland: June 17
  11. MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency
  12. Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1
  13. Webinar: SQL Query Patterns, Optimized
  14. Percona XtraBackup 2.1.2 for MySQL available for download
  15. Virident vCache vs. FlashCache: Part 2
  16. Virident vCache vs. FlashCache: Part 1
  17. Slides from my Percona Live "Benchmarking" presentation
  18. Announcing Percona XtraBackup 2.1.1 GA
  19. Is Synchronous Replication right for your app?
  20. Presenting at tomorrow’s Effective MySQL Meetup (New York City)
  21. Webinar: MySQL 5.6 Performance Schema
  22. Open Source, the MySQL market (and TokuDB in particular)
  23. How to Create a New (or Repair a Broken) GTID-Based Slave with Percona XtraBackup
  24. MySQL and Percona Server in LinkBench benchmark
  25. Percona XtraBackup 2.1.0 ‘release candidate’ for MySQL available for download
  26. Benchmarking Percona Server TokuDB vs InnoDB
  27. Percona XtraBackup 2.0.7 for MySQL available for download
  28. Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
  29. Percona XtraDB Cluster for MySQL and encrypted Galera replication
  30. Last Week’s Presentations Posted
  31. Galera Flow Control in Percona XtraDB Cluster for MySQL
  32. Follow these basics when migrating to Percona XtraDB Cluster for MySQL

April 2013

  1. Webinar: Best Practices for MySQL Scalability on May 1
  2. May 2nd Webinar: Introduction to TokuDB v7 Community & Enterprise Editions
  3. Percona Live MySQL Conference 2013 wrap-up
  4. Opening Week for TokuDB
  5. More on MySQL transaction descriptors optimization
  6. MySQL Paradise: YouTube Video
  7. Thanks to Community for Selecting Tokutek for Prestigious MySQL Award
  8. Finally. How to verify if all MySQL records were recovered
  9. MySQL Paradise – Percona Live Lightning Talk
  10. Open Source TokuDB Resources
  11. Percona Server 5.5.30 with TokuDB for MySQL
  12. Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
  13. Percona Monitoring Plugins 1.0.3 for MySQL now available
  14. Getting Interesting
  15. High-load problems? Investigate them with ‘pt-query-digest’
  16. Percona XtraBackup 2.1.0 for MySQL beta now available
  17. Announcing TokuDB v7: Open Source and More
  18. Open Source
  19. How to recover table structure from InnoDB dictionary
  20. MySQL alternative Percona Server 5.1.68 -14.6 now available
  21. The write cache: Swap insanity tome III
  22. Rotating MySQL Slow Logs Safely
  23. Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
  24. Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
  25. Is your MySQL buffer pool warm? Make it sweat!
  26. Testing the Micron P320h
  27. Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
  28. Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
  29. trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
  30. Moving to MySQL 5.6? We can help
  31. 10 years of MySQL User Conferences
  32. Percona Server for MySQL 5.5.30-30.2 now available
  33. Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
  34. Percona Playback 0.6 for MySQL now available
  35. April is the Coolest Month
  36. Understanding the maximum number of columns in a MySQL table
  37. Percona Toolkit for MySQL Webinar Followup Questions
  38. What I’m looking forward to at Percona Live (MySQL Users Conference)
  39. MongoDB Multi-Statement Transactions? Yes We Can!
  40. Learn About MySQL 5.6 at the Percona Live MySQL Conference
  41. Percona XtraBackup 2.1.0 for MySQL alpha now available
  42. MongoDB Transactions? Yes
  43. My Sessions at Percona Live MySQL Conference and Expo 2013

March 2013

  1. MySQL 5.6 – InnoDB Memcached Plugin as a caching layer
  2. Network at the Percona Live MySQL Conference and Expo
  3. TokuDB Fast Update Benchmark
  4. Why MySQL Performance at Low Concurrency is Important
  5. Repair MySQL 5.6 GTID replication by injecting empty transactions
  6. MySQL 5.6 Compatible Percona Toolkit 2.2 Released
  7. 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
  8. Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
  9. Testing the Virident FlashMAX II
  10. MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
  11. Wanted: Evaluators to Try MongoDB with Fractal Tree Indexing
  12. Percona MySQL University coming to Toronto this Friday!
  13. Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
  14. SimCity outages, traffic control and Thread Pool for MySQL
  15. Announcing Percona Server for MySQL 5.1.68 -14.5
  16. MySQL Workshops: Chicago & London this April
  17. Announcing Percona Server for MySQL 5.6.10-60.2
  18. Sysbench Benchmark for MongoDB
  19. MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
  20. MySQL Backup tools used by Percona Remote DBA for MySQL
  21. Oracle Technical Experts at the Percona Live MySQL Conference and Expo
  22. The Last Mile for Big Data – Strata Overview with Jeff Kelly of Wikibon (Part 2)
  23. MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
  24. MySQL performance: Impact of memory allocators (Part 2)
  25. Announcing Percona Server for MySQL version 5.1.67-14.4
  26. Announcing Percona Server for MySQL 5.5.30-30.1
  27. MySQL and MongoDB – Strata Discussion with Jeff Kelly of Wikibon (Part 1)
  28. Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
  29. Join me for ‘MySQL 5.6: Advantages in a Nutshell.’ Webinar. March 6 at 10 a.m. PST
  30. InnoDB MySQL full text search: Part 2, the queries!
  31. Investigating MySQL Replication Latency in Percona XtraDB Cluster

February 2013

  1. Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
  2. MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
  3. MongoDB + Fractal Tree Indexes = High Compression
  4. MySQL optimizer: ANALYZE TABLE and Waiting for table flush
  5. InnoDB Full-text Search in MySQL 5.6 (part 1)
  6. Announcing Percona Server for MySQL version 5.5.29-30.0
  7. Why do we care about MySQL Performance at High Concurrency?
  8. Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
  9. Percona Welcomes MySQL 5.6!
  10. How to use a smartphone for two-factor authentication with Percona Server for MySQL
  11. CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL
  12. MySQL 5.5 and MySQL 5.6 default variable values differences
  13. Solving RPM installation conflicts in CentOS 5 and CentOS 6
  14. Mystery Performance Variance with MySQL Restarts
  15. NoSQL is Great, But You Still Need Indexes
  16. Analyzing Slow Query Table in MySQL 5.6
  17. Percona MySQL University comes to Toronto on March 22
  18. Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
  19. Is MySQL 5.6 slower than MySQL 5.5?
  20. Using MySQL Sandbox with Percona Server
  21. Percona Toolkit 2.1.9 is ready
  22. Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities
  23. Replication checksums in MySQL 5.6
  24. Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo
  25. Announcing Percona XtraDB Cluster 5.5.29-23.7.2
  26. Fast Updates with TokuDB
  27. Percona Live MySQL Conference and Expo 2013: The talks I want to see
  28. Unexpected problem with triggers and mysqldump
  29. Adventures in archiving
  30. How to create/restore a slave using GTID replication in MySQL 5.6
  31. Deadline Near for BOFs and Lightning Talk Submissions for Percona Live MySQL Conference
  32. Webinar: Building a highly scaleable distributed row, document or column store with MySQL and Shard-Query
  33. Concurrency Improvements in TokuDB v6.6 (Part 2)
  34. Can’t Create a New Thread: Errno 11 Fixes
  35. Implications of Metadata Locking Changes in MySQL 5.5

January 2013

  1. Percona MySQL University: Looking for a venue in Toronto next month
  2. Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
  3. Announcing Percona XtraDB Cluster 5.5.29-23.7.1
  4. How to start a Percona XtraDB Cluster
  5. Feature preview: Compact backups in Percona XtraBackup
  6. How Can Percona MySQL Server Development Services Help ?
  7. Concurrency Improvements in TokuDB v6.6 (Part 1)
  8. MySQL 5.6: Improvements in the Nutshell
  9. Percona MySQL University in Montevideo and Buenos Aires
  10. Announcing Percona Server 5.1.67-14.3
  11. Announcing Percona Server 5.5.29-29.4
  12. Read/Write Splitting with PHP Webinar Questions Followup
  13. Announcing Percona XtraBackup 2.0.5
  14. Percona MySQL University, Raleigh just got better with AfterParty
  15. Thibault de Malliard, Researcher, Philip Awadalla Laboratory
  16. Thibault de Malliard, Researcher, University of Montreal
  17. New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
  18. Tracking 5.3 Billion Mutations: Using MySQL for Genomic Big Data
  19. Percona Toolkit 2.1.9 bug raffle
  20. Fun with the MySQL pager command
  21. Percona Server wins ‘Top Innovator in SQL Technologies’ award!
  22. Initial Keynote Speakers for the Percona Live MySQL Conference & the MySQL Community Awards
  23. Webinar on Read/Write Splitting with PHP
  24. Common MySQL traps webinar questions followup
  25. FOSDEM 2013: MySQL And Friends Community Dinner
  26. Sphinx search performance optimization: multi-threaded search
  27. Announcing Percona Server 5.1.66-14.2
  28. Sphinx search performance optimization: attribute-based filters
  29. The Results Are In!
  30. DotOrg Pavilion and MySQL Community Awards at Percona Live MySQL Conference and Expo 2013
  31. Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow.
  32. CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we’re doing in Percona Server 5.5.29)
  33. Webinar: Introduction to TokuDB v6.6
  34. Join us for our first Percona MySQL University event in Raleigh, N.C. Jan 29
  35. Profiling MySQL Memory Usage With Valgrind Massif
  36. Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
  37. How does MySQL Replication work?
  38. Announcing Percona Server 5.5.28-29.3
  39. Announcing TokuDB v6.6: Performance Improvements
  40. Webinar: Avoiding common traps when designing a MySQL application
  41. Vote for Percona Server in the 2013 DeveloperWeek Awards
  42. Is there room for more MySQL IO Optimization?
  43. Percona Toolkit by example – pt-stalk
  44. Marinating in 2013
  45. Serious build and testing automation
  46. Speaking at MySQL Meetups in Atlanta,GA and Charlotte,NC
  47. MySQL Training from Percona: January – March 2013

2012 370

December 2012

  1. MySQL Wish for 2013 – Better Memory Accounting
  2. Auditing Login attempts in MySQL
  3. Move over Marcia: Top Ten for 2012
  4. Announcing Percona XtraBackup 1.6.7
  5. Be productive with the MySQL command line
  6. Isern Palaus, Developer, Marketyou
  7. Javier Martínez, Developer, Marketyou
  8. Percona XtraDB Cluster: SElinux is not always the culprit !
  9. How to STOP SLAVE on Amazon RDS read replica
  10. Percona Toolkit Webinar followup Q&A
  11. Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
  12. Packing for the Holidays
  13. Percona and the MariaDB Foundation
  14. Migrating several single standalone MySQL server to one Percona XtraDB Cluster… MariaDB to the rescue !
  15. What Linux Distribution do you use to run MySQL ?
  16. The Optimization That (Often) Isn’t: Index Merge Intersection
  17. Thank You Percona Live London 2012 Attendees!
  18. Yule Blog
  19. Webinar: 10 Percona Toolkit tools every MySQL DBA should know about
  20. Announcing Percona Server 5.5.28-29.2
  21. Percona response to recent MySQL security bugs
  22. Fractal Tree Indexing Overview
  23. Quickly finding unused indexes (and estimating their size)
  24. Announcing Percona XtraBackup 2.0.4
  25. A closer look at Percona XtraDB Cluster for MySQL
  26. Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
  27. Percona Live London 2012: Percona XtraDB Cluster in a nutshell

November 2012

  1. What Operating System do you run MySQL on in Production
  2. Replication of the NOW() function (also, time travel)
  3. Webinar: Best Practices for a Successful TokuDB Evaluation
  4. Announcing Percona Playback 0.5
  5. Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
  6. What CPU Architecture do you prefer for running MySQL In production
  7. Full Table Scan vs Full Index Scan Performance
  8. Get Me Some Query Logs!
  9. Speaking at Percona Live London 2012: Percona XtraDB Cluster in a nutshell
  10. Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
  11. Using Percona Server in Production at Percona Live London
  12. Webinar: Looking for Painless MySQL High Availability ?
  13. Scalable Databases for Startups
  14. Concatenating MyISAM files
  15. Speaking at Percona Live London 2012: Choosing Hardware for MySQL
  16. Question of the week: Maximum number of tables per MySQL instance.
  17. Percona Toolkit version 2.1.6 released
  18. Announcing Percona XtraDB Cluster 5.5.28-23.7
  19. FOSDEM 2013: MySQL & Friends Devroom CfP is open !
  20. 532x Multikey Index Insertion Performance Increase for MongoDB with Fractal Tree Indexes
  21. Small Data
  22. What is the largest amount of data do you store in MySQL ?
  23. Debugging MySQL SSL problems
  24. Percona Live MySQL Conference and Expo 2013 – News from the Committee – Part 1
  25. Speaking at Internet Summit
  26. devops webinar – follow up Q&A
  27. Webinar: The Hazards of Multi-writing in a Dual-Master Setup
  28. Join us at ad:tech this week
  29. How Much memory do you use to run MySQL
  30. Knowing what pt-online-schema-change will do

October 2012

  1. Percona Live London 2012 talks you do not want to miss
  2. Webinar: MongoDB and Fractal Tree Indexes
  3. MySQL and predictive option handling – beware
  4. Percona XtraDB Cluster – installation and setup webinar follow up Q&A
  5. Edge-case behavior of INSERT…ODKU
  6. Announcing Percona Server 5.1.66-14.1
  7. Announcing Percona Server 5.5.28-29.1
  8. L2 cache for MySQL
  9. Replaying database load with Percona Playback
  10. Upcoming Webinar – "Deploy MySQL Like a devops SysAdmin"
  11. Minimizing Downtime from Lengthy AWS Outages
  12. Special Pass/Hotel Bundled Pricing for Percona Live London
  13. Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
  14. Presenting at tomorrow’s NoVA MySQL Meetup (DC Area)
  15. Recovering from a bad UPDATE statement
  16. Merit of Private Training
  17. My Talk Next Week at HighLoad++
  18. Presenting "MongoDB and Fractal Tree Indexes" at MongoDB Boston 2012
  19. Report on XLDB Tutorial on Data Structures and Algorithms
  20. Using pt-table-checksum with Percona XtraDB Cluster
  21. On SSDs – Lifespans, Health Measurement and RAID
  22. Released: Percona Toolkit 2.1.5
  23. Announcing Percona Server 5.5.27-29.0
  24. Call for Papers for the Percona Live MySQL Conference and Expo ends soon!
  25. First of New NSF Big Data Grants Go to Tokutek Founders
  26. ODBMS Interview: Scaling MySQL and MariaDB to TBs
  27. MySQL 5.6.7-RC in tpcc-mysql benchmark
  28. Review of MySQL 5.6 Defaults Changes
  29. Measuring the amount of writes in InnoDB redo logs
  30. Thank you for joining us at Percona Live, NYC 2012
  31. Tools and Techniques for Index Design Webinar Questions Followup
  32. Forbes: "Tokutek Makes Big Data Dance"
  33. Webinar: Introduction to TokuDB v6.5
  34. Percona Live New York Wrap-Up
  35. Announcing Percona XtraBackup 2.0.3
  36. Upcoming Webinar on Index Design

September 2012

  1. Percona team at MySQL Connect today
  2. MySQL Schema Agility on SSDs
  3. Three Ways that Fractal Tree Indexes Improve SSD for MySQL
  4. Logging Foreign Key errors
  5. Percona Toolkit version 2.1.4 released
  6. Timezone and pt-table-checksum
  7. Announcing TokuDB v6.5: Optimized for Flash
  8. Optimized for Flash
  9. Udi Nir, Vice President of Engineering, Swaylo
  10. Curt Monash, President of Monash Research and Editor of DBMS 2
  11. Percona Server tree with support of Fusion-io atomic writes and DirectFS
  12. Tokutek CEO Named Innovation All Star
  13. A (prototype) lower impact slow query log
  14. Fusion-io atomic writes and DirectFS
  15. Upcoming webinar on PRM
  16. What attendees are saying about Percona Live NYC ?
  17. Automation: A case for synchronous replication
  18. Logging Deadlock errors
  19. The Math of Automated Failover
  20. Strange Loop Talk on Indexing
  21. Announcing Percona Playback 0.4 (now with packages!)
  22. Announcing Percona Server 5.6.6-60.1 Alpha
  23. MySQL and SSD | Percona XtraDB Cluster talks
  24. Looking for MongoDB users to test Fractal Tree Indexing
  25. Upcoming Percona XtraDB Cluster – Installation and Setup webinar
  26. Percona XtraDB Cluster / Galera Tutorial at Percona Live NY 2012
  27. Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
  28. How to find MySQL queries worth optimizing ?
  29. How to lag a slave behind to avoid a disaster
  30. Introducing the "Version Check" Feature in Percona Toolkit
  31. Adaptive flushing in MySQL 5.6 – cont
  32. How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
  33. Intel SSD 910 in tpcc-mysql benchmark
  34. Announcing Percona XtraDB Cluster 5.5.27-23.6
  35. XLDB Tutorial on Data Structures and Algorithms
  36. Great Talks on Percona Live,NY!, Free Pass opportunity inside
  37. MongoDB Index Shootout: Covered Indexes vs. Clustered Fractal Tree Indexes
  38. Write contentions on the query cache
  39. Announcing Percona Server 5.5.27-28.1
  40. Distro Packages, Pre-built Binaries or Compile Your Own MySQL
  41. Testing Intel® SSD 910
  42. Adaptive flushing in MySQL 5.6
  43. Announcing Percona Server 5.1.65-14.0
  44. When is MIN(DATE) != MIN(DATE) ?

August 2012

  1. Visualization tools for pt-query-digest tables
  2. Month of August in Percona Community Forums
  3. Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
  4. 268x Query Performance Increase for MongoDB with Fractal Tree Indexes, SAY WHAT?
  5. Is Replication Slave ever going to catch up? When?!
  6. REPEATABLE-READ and READ-COMMITTED Transaction Isolation Levels
  7. Sell-an-Elephant-to-your-Boss-HOWTO
  8. Hidden columns of query_review_history table
  9. Full Text Search Webinar Questions Followup
  10. 10x Insertion Performance Increase for MongoDB with Fractal Tree Indexes
  11. Announcing Percona Server 5.5.27-28.0
  12. Submit your proposal for Percona Live London 2012 Now !
  13. Webinar: Introduction to TokuDB
  14. Recovery after DROP & CREATE
  15. Webinar for Full Text Search Throwdown
  16. Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
  17. Where to get a BZR tree of the latest MySQL releases
  18. MySQL Indexing Best Practices: Webinar Questions Followup
  19. Announcing Percona Server 5.6 Alpha
  20. Announcing Percona XtraBackup 2.0.2
  21. FROSCON and VLDB
  22. European and North American Training Schedule Announced
  23. Recovery deleted ibdata1
  24. MySQL Indexing: Best Practices Webinar
  25. Dagstuhl Seminar on Database Workload Management
  26. Filling the tmp partition with persistent connections
  27. Avoiding SST when adding new Percona XtraDB Cluster node
  28. Real World Compression

July 2012

  1. Innodb Table Locks
  2. Percona’s "Developer Training for MySQL" is now available via Live Virtual Training
  3. Percona Live NY 2012 Super Saver discounts end tomorrow. Book Now!
  4. SQL Injection Questions Followup
  5. Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
  6. New variable slave_max_allowed_packet for slave servers
  7. Thursday’s Emerging Business Technology Meetup in Boston
  8. Webinar: Understanding Indexing
  9. Announcing Percona Server 5.5.25a-27.1
  10. News Flash: SQL Injection Still a Problem
  11. Announcing TokuDB v6.1
  12. How We Spent a Tuesday Fixing a MySQL Replication Bug
  13. Indexing Big Data – NSF Workshop on Research Directions in the Principles of Parallel Computation
  14. Meet Percona Team at OSCON
  15. Percona Playback 0.3 development release
  16. My Talks at MySQL Connect and Percona Live NYC
  17. Impact of memory allocators on MySQL performance
  18. Balada Para Un Loco – A Review of the MySQL, NoSQL, and Cloud Conference
  19. How to Stop Playing "Hop and Seek": MySQL Cluster and TokuDB, Part 2
  20. Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS

June 2012

  1. Find unused indexes
  2. Percona Server 5.5.25-27.0 release delayed
  3. MySQL Upgrade Webinar Questions Followup
  4. Hot Table Optimization with MySQL
  5. ALTER TABLE: Creating Index by Sort and Buffer Pool Size
  6. Announcing Percona Live MySQL London
  7. Announcing Percona XtraBackup 2.0.1
  8. Volver – MySQL, NoSQL, and Cloud Conference Latin America
  9. Where Percona software goes before it’s released
  10. DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
  11. On Character Sets and Disappearing Tables
  12. How to Stop Playing "Hop and Seek": MySQL Cluster and TokuDB
  13. pt-online-schema-change and default values
  14. Find and remove duplicate indexes
  15. Percona XtraDB Cluster reference architecture with HaProxy
  16. Clarification on MySQL security vulnerability
  17. Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
  18. Upgrading MySQL: Best Practices webinar, June 27th
  19. Mi Buenos Aires Querido
  20. Using innodb_sys_tables and innodb_sys_indexes
  21. Release 1.0.1 of Percona Monitoring Plugins
  22. Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
  23. Addressing Hot Schema Changes in MySQL
  24. Percona Toolkit versions 2.0.5 and 2.1.2 released
  25. NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
  26. Fractal Tree Indexing and Filesystems – HotStorage 2012
  27. Percona replication manager (PRM) documentation available (beta)
  28. Announcement of Percona XtraDB Cluster 5.5.24
  29. Meet Percona at Southeast Linux Fest
  30. read_buffer_size can break your replication
  31. Migrating to XtraDB Cluster Webinar follow up questions
  32. Basement Nodes: Turning Big Writes into Small Reads
  33. Open Database Camp at SouthEast LinuxFest 2012
  34. thread_concurrency doesn’t do what you expect
  35. The Sound and the NoSQL Fury
  36. How expensive is USER_STATISTICS?
  37. Announcing Percona Server 5.5.24-26.0
  38. Review of the Tutorial on Algorithms for Memory Sensitive Computing at STOC

May 2012

  1. A case for MariaDB’s Hash Joins
  2. Data Compression in InnoDB for Text and Blob Fields
  3. Webinar: TokuDB v6 Replication Performance
  4. Percona at SELF
  5. Secure passwords being insecure
  6. Announcing Percona Server 5.1.63-13.4
  7. Challenges of Big Databases with MySQL – IOUG Presentation
  8. Webinar – Migrating to Percona XtraDB Cluster
  9. Binary log file size matters (sometimes)
  10. Percona Live MySQL Conference 2012 Prize Winners and Percona Live New York 2012
  11. btrfs – probably not ready yet
  12. Intel 520 SSD in MySQL sysbench oltp benchmark
  13. Tutorial Tomorrow, 5/19, at the 44th ACM Symposium on Theory of Computing (STOC)
  14. Training in London next week
  15. Benchmarking single-row insert performance on Amazon EC2
  16. SwRI Chooses TokuDB to Tackle Machine Data for an 800M+ Record Database
  17. Greg Dunn, Senior Research Engineer, SWRI
  18. Percona Server 5.5.23-25.3 released!
  19. Announcement of Percona XtraDB Cluster 5.5.23
  20. Tokutek Welcomes Gerry Narvaja!
  21. Testing Fusion-io ioDrive2 Duo
  22. Percona Live Slides and Video Available: The Right Read Optimization is Actually Write Optimization
  23. New distribution of random generator for sysbench – Zipf
  24. Zero-downtime schema changes webinar recording
  25. Webinar: MySQL and SSD
  26. Introducing Zend DBi as a MySQL Replacement on IBM i
  27. Testing Fusion-io ioDrive – now with driver 3.1
  28. Load management Techniques for MySQL
  29. Testing Virident FlashMAX 1400
  30. Testing Fusion-io ioDrive
  31. Zero-Downtime Schema Changes In MySQL
  32. Laine Campbell, Owner and CEO, PalominoDB
  33. Adrian Roston, CTO, Frequency
  34. Tokutek and PalominoDB Partner to Bring Scale, Performance to Database Deployments
  35. Testing Intel SSD 520

April 2012

  1. TokuDB v6.0: Download Available
  2. Percona Server 5.1.62-13.3 released!
  3. Percona Server 5.5.22-25.2 released!
  4. Testing STEC SSD MACH16 200GB SLC
  5. Testing Samsung SSD SATA 256GB 830 – not all SSD created equal
  6. Joining many tables in MySQL – optimizer_search_depth
  7. Benchmarks challenges of XtraDB Cluster
  8. My Talk on Tuesday at IOUG COLLABORATE 12
  9. PLMCE High Availability Deep Dive slides and Document
  10. Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany
  11. Percona MySQL Training Schedule for May, June, & July
  12. Percona MySQL Conference and Expo Week in Review
  13. Version 1.0 of Percona Monitoring Plugins Released
  14. Percona Live MySQL Conference & Expo Was A Great Event
  15. Testing Percona Replication Manager (prm) with Vagrant
  16. This Monday: Silicon Valley NewSQL Meetup
  17. TokuDB v6.0: Frequent Checkpoints with No Performance Hit
  18. Testing Percona XtraDB Cluster with Vagrant
  19. TokuDB v6.0: Even Better Compression
  20. Percona welcomes Drizzle 7.1
  21. Percona Announces New Relic Partnership
  22. TokuDB v6.0: Getting Rid of Slave Lag
  23. How We Got Here
  24. Announcing TokuDB v6.0: Less Slave Lag and More Compression
  25. High Availability Deep Dive tutorial at PLMCE
  26. Percona Toolkit 2.1 with New Online Schema Change Tool
  27. Join Optimizations in MySQL 5.6 and MariaDB 5.5
  28. Announcing Percona XtraBackup 2.0.0 GA
  29. Announcing Percona XtraBackup 1.6.6
  30. Announcement of Percona XtraDB Cluster 5.5.20 GA release
  31. Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
  32. OLTP and OLAP – Have Your Cake and Eat it Too!

March 2012

  1. Percona XtraBackup 1.9.2 released (Beta)
  2. Looking for Global Collisions
  3. InnoDB Gap Locks
  4. How to diagnose errors in the MySQL error log
  5. Community events around Percona Live MySQL Conference and Expo 2012
  6. How MySQL FLUSH TABLES WITH READ LOCK works w/ Innodb Tables
  7. Speaking at POSSCON
  8. Best kept MySQLDump Secret
  9. BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
  10. Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
  11. Announcing Percona Server 5.5.21-25.0
  12. Win Free MySQL Conference Tickets!
  13. Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"
  14. ext4 vs xfs on SSD
  15. Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
  16. Big Data and MySQL – a Discussion with SiliconANGLE on theCUBE
  17. Early Bird Pricing Ends Today for Percona Live MySQL Conference & Expo
  18. Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
  19. O’Reilly Strata 2012: The Year of the Data Scientist

February 2012

  1. Announcing Percona XtraBackup 1.9.1
  2. Evidenzia Upgrades to TokuDB v5.2 to Address Storage Growth and Scale Performance
  3. Introducing new type of benchmark
  4. Percona XtraDB Cluster Events
  5. Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
  6. Percona XtraDB Cluster 5.5.20 – Beta release
  7. Black-Box MySQL Performance Analysis with TCP Traffic
  8. Percona Server vs MySQL on Intel 320 SSD
  9. Some fun with R visualization
  10. Benchmarks of Intel 320 SSD 600GB
  11. How to Monitor MySQL with Percona’s Nagios Plugins
  12. DBD::mysql 4.014 breaks pt-table-checksum 2.0
  13. Database Algorithms sin Pantalones
  14. How to recover deleted rows from an InnoDB Tablespace
  15. How to convert MySQL’s SHOW PROFILES into a real profile
  16. MySQL Meetups in North Carolina this week
  17. Why don’t our new Nagios plugins use caching?
  18. MariaDB 5.3.4 benchmarks
  19. Can we improve MySQL variable handling ?
  20. The relationship between Innodb Log checkpointing and dirty Buffer pool pages
  21. Optimize Your SQL With Percona’s Online Query Advisor!
  22. Troubleshooting MySQL Upgrade Performance Regressions
  23. My talks on PL MySQL Conference (+free book inside)
  24. Announcing Percona XtraBackup 1.6.5
  25. Why not make a tool to improve existing configurations?
  26. Tokutek Selected as a Finalist for O’Reilly Strata Conference
  27. Announcing Drizzle Day, Fri 13th April 2012
  28. Dot-Org Pavilion at the Percona Live MySQL Conference
  29. Announcing Percona Toolkit Release 2.0.3
  30. New England’s Victory (for Big Data)
  31. Speaking at MySQL Meetup in Charlotte,NC
  32. STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
  33. MySQL Conference and Expo Talk on Benchmarking
  34. Verifying backup integrity with CHECK TABLES

January 2012

  1. Speaking at MySQL Meetup in Raleigh,NC
  2. MySQL Configuration Wizard Updated
  3. 1 Billion Insertions – The Wait is Over!
  4. How to Recover a Single InnoDB Table from a Full Backup
  5. Schedule for MySQL Conference 2012 is Published
  6. linux.conf.au 2012 roundup
  7. Preventing MySQL Emergencies Webinar
  8. Slides from Percona Live, Washington, DC are available
  9. Percona XtraDB Cluster Feature 2: Multi-Master replication
  10. Announcing TokuDB v5.2: Improved Multi-Client Scaling and Faster Queries
  11. Backing up binary log files with mysqlbinlog
  12. Benchmarks of new innodb_flush_neighbor_pages
  13. Percona XtraDB Cluster Feature 1: High Availability
  14. Announcing Percona Server 5.5.19-24.0
  15. Percona testing: Quick test clusters with kewpie!
  16. Create 3 nodes XtraDB Cluster in 3 minutes
  17. Making the impossible: 3 nodes intercontinental replication
  18. Fractal Tree Indexes and Mead – MySQL Meetup
  19. Learn about Percona XtraDB Cluster at Percona Live DC
  20. Announcement of Percona XtraDB Cluster (alpha release)
  21. Is your MySQL Application having Busy IO by Oracle Measures ?
  22. Time for Zero Administration effort at MySQL ?
  23. Configuring MySQL For High Number of Connections per Second
  24. Looking for RAID Controller without Battery Learning problems ?
  25. FictionPress Selects TokuDB for Consistent Performance and Fast Disaster Recovery
  26. Percona Toolkit 2.0.1 and 1.0.2 released
  27. Hijacking Innodb Foreign Keys

2011 330

December 2011

  1. How To Test Your Upgrades – pt-upgrade
  2. Actively monitoring replication connectivity with MySQL’s heartbeat
  3. Identifying the load with the help of pt-query-digest and Percona Server
  4. Call for nominations to the MySQL Council
  5. MySQL Training in Frankfurt, Germany
  6. Solving INFORMATION_SCHEMA slowness
  7. Online MySQL Configuration Wizard from Percona
  8. Optimizing InnoDB for creating 30,000 tables (and nothing else)
  9. Xing Li, CTO, FictionPress
  10. Percona Testing: Innodb crash / recovery tests available
  11. Percona Toolkit PDF manual now available
  12. Percona Server documentation in PDF is available
  13. Top Ten for 2011
  14. Percona XtraBackup 1.6.4
  15. Percona Server 5.5.18-23.0: Now with Group Commit!
  16. Percona Server 5.1.60-13.1
  17. Setting up XFS on Hardware RAID — the simple edition
  18. Statement based replication with Stored Functions, Triggers and Events
  19. Limelight Networks Chooses TokuDB for New Cloud Storage Service
  20. FOSDEM 2012 – MySQL and Friends devroom
  21. MySQL Training in Washington, DC
  22. Which Linux distribution for a MySQL database server? A specific point of view.
  23. Announcing Percona Live Washington DC MySQL Conference
  24. Fractal Tree Indexes – MySQL Meetup
  25. Announcing PAM authentication plugin for MySQL (early access release)
  26. kernel_mutex problem cont. Or triple your throughput
  27. kernel_mutex problem. Or double throughput with single variable
  28. Three ways that the poor man’s profiler can hurt MySQL

November 2011

  1. An update on Percona Live MySQL Conference & Expo 2012
  2. Beware the Innodb Table Monitor
  3. Innodb vs MySQL index counts
  4. Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
  5. Avoiding auto-increment holes on InnoDB with INSERT IGNORE
  6. Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
  7. Should MySQL update the default innodb_log_file_size?
  8. A Case for Write Optimizations in MySQL
  9. MySQL opening .frm even when table is in table definition cache
  10. Bug#12704861
  11. Percona Server 5.5.17-22.1 released
  12. TokuDB v5.2 Beta Program
  13. MySQL Life Cycle. Your Feedback is needed.
  14. Eventual Consistency in MySQL
  15. Stewart speaking at OSDC 2011
  16. Scaling MySQL with TokuDB Webinar – Video and Slides Now Available
  17. Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
  18. if I do say so myself. One of the biggest difficulties in fixing bugs comes from being able to recreate them reliably and easily. Between the randgen’s brutal ability to produce test data and queries and dbqp’s efficient test organization
  19. Fishing with dynamite, brought to you by the randgen and dbqp
  20. dbqp and Xtrabackup testing
  21. MLC SSD card lifetime and write amplification
  22. Side load may massively impact your MySQL Performance
  23. TokuDB v5.0.6 is Now Available
  24. Review of Virident FlashMAX MLC cards
  25. Slides from Percona Live,London are now available
  26. Improved InnoDB fast index creation
  27. "How Fractal Trees Work" at MIT today
  28. Emulating global transaction ID with pt-heartbeat
  29. Webinar: Scaling MySQL with TokuDB
  30. The Big Data Community at the MassTLC unConference

October 2011

  1. Percona Training: Dublin, San Diego, NYC, and WDC
  2. Looking for InnoDB/XtraDB hacker
  3. Challenges of Big Databases with MySQL – OOW11 Presentation
  4. Free Percona Live London Reception at Revolution Bar
  5. Find where your data is replicated, win a Percona Live ticket
  6. TokuDB Stats
  7. Percona Server 5.1.59-13.0
  8. Percona Server 5.5.16-22.0
  9. Public Clouds: Trust but Verify
  10. Benchmarking Galera replication overhead
  11. Why the MySQL EXPLAIN Output can be Wrong
  12. MySQL versions shootout
  13. Infinite Replication Loop
  14. Multiple MySQL instances on Fusion-io ioDrive
  15. Understanding Indexing – NY Effective MySQL Meetup
  16. When Do InnoDB Table Statistics Update?
  17. Write Optimization: Myths, Comparison, Clarifications, Part 2
  18. Percona Server 5.5.15 + Galera 21.1-beta2
  19. Percona Welcomes Patrick Crews
  20. Updated Percona Server and Percona XtraBackup documentation
  21. My Talk on Sunday at Oracle Open World

September 2011

  1. Speaking at HighLoad conference, Moscow, Russia, Training and Hiring
  2. This week’s TGIF Percona Live ticket giveaway
  3. Are You Forcing MySQL to Do Twice as Many JOINs as Necessary?
  4. Intel 320 SSD write performance – contd.
  5. From Under the Desk to the Cloud
  6. Percona XtraBackup 1.6.3
  7. NDB tutorial at Percona Live London + Free TIcket Give Away
  8. Write Optimization: Myths, Comparison, Clarifications
  9. John Nahlen, DBA, Bughouse DB
  10. Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
  11. White Paper: Flashcache and MySQL on Virident drive
  12. Disaster: MySQL 5.5 Flushing
  13. Percona Live MySQL Conference and Expo opens Call for Papers
  14. Using MySQL as a Queue, and Free Percona Live Tickets
  15. Compression Benchmarking: Size vs. Speed (I want both)
  16. SELECT UNION Results INTO OUTFILE
  17. MySQL data via a NoSQL solution, Free ticket to Percona Live London
  18. Online Advertiser Intent Media Selects TokuDB over InnoDB and NoSQL for Big Data Ad-Hoc Analysis
  19. Percona Toolkit 1.0.1 released
  20. Josh Hartman, CTO at Intent Media
  21. Chris Claydon, Managing Director at Profile Technology Ltd.
  22. Dynamic row format for MEMORY tables
  23. Understand InnoDB spin waits, win a Percona Live ticket
  24. Percona Server 5.5.15-21.0

August 2011

  1. Ask What Your Database Can Do for Your Country
  2. Explaining Indexes with a Library Metaphor
  3. Percona Training In Sydney
  4. Recovering Linux software RAID, RAID5 Array
  5. Getting MySQL Core file on Linux
  6. Return of the Query Cache, win a Percona Live ticket
  7. Database Insights from Archimedes to the Houston Rockets
  8. Percona Live MySQL Conference & Expo committee published
  9. Tutorial Insights for Percona Live, London
  10. Make your file system error resilient
  11. Win a free ticket to Percona Live London!
  12. May the Index be with you!
  13. Percona Server 5.1.58-12.9
  14. Percona Server 5.5.14-20.5
  15. It Actually is Easy Being Green
  16. Announcing Percona Live MySQL Conference and Expo 2012
  17. Percona Live London: CFP, Registration, Sponsorships Open
  18. Preprocessing Data
  19. MySQL performance on EC2/EBS versus RDS
  20. Percona turns 5 years old

July 2011

  1. Intel 320 SSD read performance
  2. Reasons for MySQL Replication Lag
  3. Cage Match: OldSQL, NoSQL and NewSQL
  4. Percona Server 5.1.57 with Galera 0.8.1
  5. How Innodb Contention may manifest itself
  6. What’s required to tune MySQL?
  7. Percona Xtrabackup 1.6.2 released!
  8. This Weekend in Japan
  9. Percona Live London!
  10. Dude, Where’s my Fractal Tree?
  11. Indexing: The Director’s Cut
  12. Percona Server 5.1 with Galera replication
  13. Tweeted by @Twirrim
  14. Tweeted by @denshikarasu
  15. Testing the Group Commit Fix
  16. Followup on performance metrics: slides, video
  17. How to Change innodb_log_file_size
  18. Don’t Thrash: How to Cache your Hash on Flash
  19. Speaking on MySQL Meetup in London, July 18
  20. Percona Server 5.5.13-20.4 Stable Release

June 2011

  1. Query Planner Gotchas
  2. Intel 320 SSD random write performance
  3. FusionIO 320GB MLC random write performance
  4. Mike Vizard, CTO Edge
  5. Stuart Miniman, Wikibon
  6. Understanding Indexing – SF MySQL Meetup
  7. Speeding Up TPCC Table Loads by 8x with TokuDB v5.0
  8. New for MongoDB! TokuMX
  9. Maximum Scalability
  10. Product to try: MySQL/MariaDB-Galera 0.8
  11. Aligning IO on a hard disk RAID – the Theory
  12. Aligning IO on a hard disk RAID – the Benchmarks
  13. How to replace a NDB node on EC2
  14. Percona Server 5.5.12-20.3 Stable Release
  15. Percona Server 5.1.57-12.8 Stable Release
  16. A recovery trivia or how to recover from a lost ibdata1 file
  17. We’ll Bring the Pie
  18. ACTIVE with Locks – Now thats a problem !
  19. Big Data Needs You

May 2011

  1. What’s a good buffer pool read/write ratio?
  2. Percona Live, NYC
  3. Just hours left until Percona Live sells out!
  4. Never Settle for a "B"
  5. Free Percona Live tickets and Percona Support contract!
  6. InnoDB compression woes
  7. Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
  8. Flexviews is a working scalable database transactional memory example
  9. The case for getting rid of duplicate "sets"
  10. SoMoLo Data
  11. Finding an optimal balance of I/O, CPU, and RAM for MySQL
  12. Using any general purpose computer as a special purpose SIMD computer
  13. Checking the subset sum set problem with set processing
  14. Percona welcomes Stewart Smith
  15. Win a free ticket to RailsConf!
  16. Distributed Set Processing with Shard-Query
  17. Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
  18. Connecting orphaned .ibd files
  19. Covering Indexes: How many indexes do you need?
  20. Shard-Query EC2 images available
  21. Innodb Caching (part 2)
  22. Introducing our Percona Live speakers
  23. Must read talk from MySQL Conference and Expo
  24. Upcoming webinar on Percona XtraBackup
  25. Visit Percona at RailsConf 2011 — with a 20% discount!
  26. Elephants on a Trapeze: Keeping Big Data Agile
  27. Want a discount to Percona Live?
  28. Shard-Query turbo charges Infobright community edition (ICE)
  29. The two even more fundamental performance metrics
  30. Percona Live gets bigger: two more speaker tracks!
  31. Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
  32. Percona Server and XtraBackup for MacOS – experimental binaries
  33. Performance Schema tables stats

April 2011

  1. Hours remain for Percona Live NYC Early Bird Discount
  2. Sysbench with support of multi-tables workload
  3. Scalr and MNPP
  4. Percona Server 5.5.11-20.2 Stable Release
  5. The four fundamental performance metrics
  6. Effective MySQL, a New York City Meetup
  7. Performance Schema overhead
  8. MySQL at Facebook, present and future
  9. Percona Server and XtraBackup Weekly News, April 25th
  10. Intel Nehalem vs AMD Opteron shootout in sysbench workload
  11. Percona Live NYC Schedule Posted
  12. InnoDB page sizes: plans and ideas
  13. Reality of Innodb Caching
  14. Drop table performance
  15. Coast to Coast – Review of Conferences
  16. MySQL Connection Timeouts
  17. Percona’s O’Reilly MySQL Conference Community Awards
  18. How to use tcpdump on "Very" Busy Hosts
  19. Percona Server and XtraBackup Weekly News, April 18th
  20. Percona Server 5.1.56-12.7
  21. Aspersa tools bit.ly download shortcuts
  22. Percona Announces Drizzle Support
  23. Percona XtraBackup 1.6
  24. Percona Server and XtraBackup Weekly News, April 11th
  25. TokuDB Tames Huge Logfile Processing Workload for Jawa
  26. Should we give a MySQL Query Cache a second chance ?
  27. Talk to the MySQL Council
  28. OldSQL Tricks or NewSQL Treats
  29. Innodb row size limitation
  30. Optimizing slow web pages with mk-query-digest
  31. Percona’s Sessions at the O’Reilly MySQL Conference and Expo
  32. Hot Column Addition and Deletion Part II: How it works
  33. Win free MySQL Conference Passes!
  34. More on MySQL Error Messages
  35. Tokutek to Speak at 2011 IOUG Collaborate 11 and O’Reilly MySQL Conference
  36. Hot Indexing Part I: New Feature
  37. MySQL caching methods and tips
  38. Flexviews – part 3 – improving query performance using materialized views
  39. Percona Server and XtraBackup weekly news, April 4th
  40. Percona Server 5.5.10 (Release Candidate)
  41. InnoDB Flushing: Theory and Solutions
  42. Tokutek’s Chief Scientist Discusses TokuDB v5.0, Part 2
  43. Performance or Stability ???

March 2011

  1. InnoDB Flushing: a lot of memory and slow disk
  2. Hot Column Addition and Deletion Part I – Performance
  3. Tokutek’s Chief Scientist Discusses TokuDB v5.0
  4. MySQL on Amazon RDS part 2: Determining Peak Throughput
  5. What’s up with HandlerSocket?
  6. Percona Server and XtraBackup available on Solaris
  7. Promote Percona Server and XtraBackup with Web Badges
  8. Maatkit’s mk-query-digest filters
  9. Percona Server and XtraBackup weekly news, March 28th
  10. Using Flexviews – part two, change data capture
  11. What’s the Big Idea?
  12. Customer, Analysts, Press on TokuDB v5.0
  13. Using Flexviews – part one, introduction to materialized views
  14. Announcing TokuDB v5.0: Making Big Data Agile
  15. Product Overview: TokuDB v5.0
  16. Two quick site updates: videos online; Kindle edition
  17. How Percona strives to remain neutral and independent
  18. Virtualization and IO Modes = Extra Complexity
  19. What Causes Downtime in MySQL?
  20. Choosing an appropriate benchmark length
  21. Percona Server and XtraBackup weekly news, March 19th
  22. Understanding Indexing – MySQL Meetup
  23. Where does HandlerSocket really save you time?
  24. Pretty-formatted index fragmentation with xtrabackup
  25. MySQL on Amazon RDS part 1: insert performance
  26. Upcoming Webinar on HandlerSocket
  27. Percona Server and XtraBackup weekly news, March 12th
  28. MySQL Partitioning: A Flow Chart
  29. Modeling MySQL Capacity by Measuring Resource Consumptions
  30. How to debug long-running transactions in MySQL
  31. Percona reaches 1000-customer milestone
  32. Percona Server 5.1.55-12.6
  33. Percona Server and XtraBackup weekly news, March 5th
  34. How Percona diagnoses MySQL server stalls
  35. Hip To Be Square
  36. What is innodb_support_xa?

February 2011

  1. Is VoltDB really as scalable as they claim?
  2. Percona Server Scales Vertically with Virident tachIOn Drives
  3. Percona welcomes Alexey Kopytov
  4. Percona Server and XtraBackup weekly news, February 26th
  5. Friends of Percona Get 20% Off at the MySQL Conference!
  6. Tokutek CEO talks to Wikibon about Big Data and MySQL
  7. Death match! EBS versus SSD price, performance, and QoS
  8. Percona Server and XtraBackup weekly news, February 19th
  9. The Data is Coming! The Data is Coming!
  10. How to syntax-check your my.cnf file
  11. Percona Server 5.5.8 Beta Release
  12. High availability for MySQL on Amazon EC2 – Part 6 – Publishing server location
  13. High availability for MySQL on Amazon EC2 â€" Part 5 – The instance monitoring script
  14. 3 Common Rails + MySQL Mistakes
  15. My-Shhhh!-QL
  16. Moving Subtrees in Closure Table Hierarchies
  17. Basic performance and diagnostic tools on Solaris
  18. Percona Server and XtraBackup weekly news, February 12th
  19. Battery Learning still problem many years after
  20. White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident
  21. White Paper: Preventing MySQL Emergencies
  22. Percona Server and XtraBackup weekly news, February 5th
  23. MySQL Meetup in Charlotte,NC second attempt
  24. Fixing MySQL with a comment in the config file
  25. Performance problem with Innodb and DROP TABLE
  26. How InnoDB handles REDO logging
  27. Tokutek Founder Named to IOUG MySQL Council
  28. Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
  29. Percona Live: Less than 25 tickets remain
  30. Logging MySQL queries from the client instead of the server
  31. TokuDB FAQ
  32. Sample Datasets for Benchmarking and Testing

January 2011

  1. MySQL & Friends Meetup @ FOSDEM
  2. What is exec_time in binary logs?
  3. Announcing Ignite Percona – San Francisco, Feb 16th.
  4. Partitioning, Free Lunches, & Indexing, Part 2
  5. Modeling InnoDB Scalability on Multi-Core Servers
  6. Percona Live: Venu Anuganti; early bird registration expires tomorrow
  7. Partitioning, Free Lunches, and Indexing
  8. Blog Redesign 2011
  9. Different flavors of InnoDB flushing
  10. Innodb undo segment size and transaction isolation
  11. Conflict Avoidance with auto_increment_increment and auto_increment_offset
  12. Percona Live Keynote Speaker: Mark Callaghan
  13. When does Innodb Start Transaction ?
  14. Bad weather strikes Meetup in Charlotte,NC
  15. Percona Server 5.1.54-12.5
  16. How to Identify Bad Queries in MySQL
  17. Percona Server Fast-Restart White Paper Posted
  18. Ultimate MySQL variable and status reference list
  19. Upcoming Webinar on HA solutions for MySQL
  20. High Rate insertion with MySQL and Innodb
  21. Announcing Percona Live: San Francisco February 16th
  22. Speaking on MySQL/PHP Meetup in Charlotte, NC
  23. Effect from innodb log block size 4096 bytes
  24. MySQL 5.5.8 – in search of stability

2010 217

December 2010

  1. Percona Welcomes Sasha Pachev
  2. Percona Server 5.1.53-12.4
  3. Spreading .ibd files across multiple disks; the optimization that isn’t
  4. How long is recovery from 8G innodb_log_file
  5. MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
  6. MySQL 5.5.8 and Percona Server: being adaptive
  7. Impact of the number of idle connections in MySQL (version 2)
  8. Impact of the number of idle connections in MySQL
  9. Percona Server 5.1.53-11.7
  10. Percona Server now both SQL and NOSQL
  11. Write performance on Virident tachIOn card
  12. Percona Server 5.1.52-12.3
  13. Percona XtraBackup 1.5-Beta
  14. MySQL Partitioning for Performance Optimization
  15. Announcing TokuDB for MariaDB
  16. How well does your table fits in innodb buffer pool ?
  17. Using MySQL OPTIMIZE tables for InnoDB? Stop!
  18. Using XtraBackup on NFS for MySQL backups
  19. Getting History of Table Sizes in MySQL
  20. Speaking at MySQL Meetup event in NYC, December 15
  21. Stripped MySQL builds, the optimization that isn’t
  22. Doing Re-run of Migrating MyISAM to Innodb Webinar

November 2010

  1. Data Corruption, DRBD and story of bug
  2. Speaking on San Francisco Meetup 14-Dec : What’s new in XtraDB/InnoDB-plugin 5.1+
  3. Percona Server 5.1.52-rel11.6
  4. Moving from MyISAM to Innodb or XtraDB. Basics
  5. Percona XtraBackup 1.4
  6. Is there benefit from having more memory ?
  7. Avoiding Fragmentation with Fractal Trees
  8. Percona white paper: Forecasting MySQL Scalability
  9. Percona is looking for a Support Engineer
  10. The perils of uniform hardware and RAID auto-learn cycles
  11. Shard-Query adds parallelism to queries
  12. Advanced index analysis with mk-index-usage
  13. Lost innodb tables, xfs and binary grep
  14. Implementing Parallel Replication in MySQL
  15. Webinar: MyISAM to InnoDB migration
  16. An argument for not using mysqldump
  17. Percona’s Commitments to MySQL Users
  18. HandlerSocket on SSD
  19. Baron Schwartz interviewed on WebPulp.tv

October 2010

  1. Percona Server 5.1.51-rel11.5
  2. MySQL Limitations Part 4: One Thread per Connection
  3. Sharing an auto_increment value across multiple MySQL tables (revisited)
  4. MySQL Limitations Part 3: Subqueries
  5. Impact of the sort buffer size in MySQL
  6. MySQL Limitations Part 2: The Binary Log
  7. High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script
  8. Percona Server with XtraDB Case Study, Behind the Scenes
  9. New Forum Categories: Help Wanted, For Hire
  10. MySQL Limitations Part 1: Single-Threaded Replication
  11. Replication of MEMORY (HEAP) Tables
  12. Percona Server 5.1.50-rel12.1
  13. Percona White Paper: Architecting SaaS Applications with XtraDB
  14. The story of one MySQL Upgrade
  15. Percona at WebConf Riga 2010
  16. Percona Launches New Support Option for MySQL
  17. Talks in Moscow, Minsk, Samara
  18. Sharing an auto_increment value across multiple MySQL tables

September 2010

  1. Percona Server scalability on multi-cores server
  2. Diagnosing and fixing MySQL Performance Problems in Russian in Moscow, Russia
  3. Percona Server 5.1.50-rel11.4
  4. More on dangers of the caches
  5. Scenarios where TokuDB’s Loader is Used
  6. Percona Server 5.1.49-rel12.0
  7. Cache Miss Storm
  8. Percona Server 5.1.49-rel11.3
  9. First Sphinx Conference is Announced
  10. UDF -vs- MySQL Stored Function
  11. How long Innodb Shutdown may take
  12. Loading Tables with TokuDB 4.0
  13. Introducing tcprstat, a TCP response time tool

August 2010

  1. Loading Air Traffic Control Data with TokuDB 4.1.1
  2. InnoDB memory allocation, ulimit, and OpenSUSE
  3. Announcing TokuDB v4.1.1
  4. High availability for MySQL on Amazon EC2 â€" Part 4 – The instance restart script
  5. Percona talks at OpenSQL Camp this weekend
  6. Announcing Training for Operations Teams
  7. Testing MySQL column stores
  8. Announcing TokuDB v4.1
  9. On "Replace Into", "Insert Ignore", Triggers, and Row Based Replication
  10. Why message queues and offline processing are so important
  11. TokuDB speeds up "replace" and "insert ignore" operations by relaxing the affected rows constraint
  12. Why you can’t rely on a replica for disaster recovery

July 2010

  1. Storing MySQL Binary logs on NFS Volume
  2. MariaDB and the MySQL Sandbox
  3. Caching could be the last thing you want to do
  4. On "Replace Into", "Insert Ignore", and Secondary Keys
  5. Estimating Replication Capacity
  6. SSD: Free space and write performance
  7. Analyzing the distribution of InnoDB log file writes
  8. Data mart or data warehouse?
  9. On Benchmarks on SSD
  10. SLC vs MLC
  11. Why "insert … on duplicate key update" May Be Slow, by Incurring Disk Seeks
  12. Scaling: Consider both Size and Load
  13. Percona at OSCON 2010
  14. Intro to OLAP
  15. High availability for MySQL on Amazon EC2 â€" Part 3 â€" Configuring the HA resources
  16. Query Response time histogram – new feature in Percona Server
  17. Making "Insert Ignore" Fast, by Avoiding Disk Seeks
  18. mk-query-digest, query comments and the query cache
  19. How is join_buffer_size allocated?
  20. Announcing TokuDB v4.0
  21. Recover BLOB fields

June 2010

  1. Recall of Percona Server 5.1.47-11.0
  2. Making "Replace Into" Fast, by Avoiding Disk Seeks
  3. High availability for MySQL on Amazon EC2 – Part 2 – Setting up the initial instances
  4. Making Updates Fast, by Avoiding Disk Seeks
  5. Percona Server 5.1.47-rel11.0
  6. Disk seeks are evil, so let’s avoid them, pt. 4
  7. High availability for MySQL on Amazon EC2 – Part 1 – Intro
  8. What does Handler_read_rnd mean?
  9. EXPLAIN EXTENDED shows what MySQL optimizer does to your query
  10. Virident tachIOn: New player on Flash PCI-E cards market
  11. Purge Thread Spiral of Death
  12. Reasons for run-away main Innodb Tablespace
  13. Table locks in SHOW INNODB STATUS
  14. Making Deletions Fast, by Avoiding Disk Seeks
  15. Performance Optimization and Six Sigma
  16. FlashCache: tpcc workload with FusionIO card as cache
  17. PBXT in tpcc-like benchmark
  18. Security fixes for MySQL 4.0 and 4.1
  19. Disk seeks are evil, so let’s avoid them, pt. 3 (Deletions)
  20. Color code your performance numbers

May 2010

  1. On Good Instrumentation
  2. Percona Welcomes Justin Swanhart
  3. FlashCache: tpcc workload
  4. Disk seeks are evil, so let’s avoid them, pt. 2
  5. Tuning InnoDB Concurrency Tickets
  6. Percona Server security fix releases
  7. Extending Index for Innodb tables can hurt performance in a surprising way
  8. Disk Seeks are Evil, so Let’s Avoid Them, Part 1
  9. Beyond great cache hit ratio
  10. A workaround for the performance problems of TEMPTABLE views
  11. Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
  12. Is your server’s performance about to degrade?
  13. FlashCache: more benchmarks
  14. OpenSQL Camp Boston 2010
  15. Improved spam blocking solution for our blog
  16. Joining on range? Wrong!
  17. mysql_upgrade and Innodb Tables
  18. OpenSQL (2009 Portland) talk on an Open Storage Engine API
  19. Two Types of MySQL Users
  20. FlashCache: first experiments
  21. The Doom of Multiple Storage Engines
  22. Percona Server 5.0.90-build21
  23. Debugging MySQL Problems with Row-Based Replication
  24. How much memory Innodb Dictionary can take ?
  25. Checking for a live database connection considered harmful
  26. What is a Performance Model for SSDs?
  27. Goal-Driven Performance Optimization white-paper available
  28. MongoDB Approach to Availability
  29. MongoDB Approach to database synchronization

April 2010

  1. Fractal Tree Video from OpenSQL Camp (Portland in 2009)
  2. Seeking volunteers for Percona documentation
  3. Presentations Announcement: 2010 O’Reilly MySQL Conference & Expo
  4. "How Fractal Trees Work" talk at MySQL 2010
  5. Level 2 Flash cache is there
  6. XtraDB / InnoDB internals in drawing
  7. How fast is FLUSH TABLES WITH READ LOCK?
  8. MySQL 5.5.4 in tpcc-like workload
  9. TokuDB Indexes are NOT in-memory (and not hash tables either)
  10. Is there a performance difference between JOIN and WHERE?
  11. Forgot the Titles for Tokutek’s MySQL UC Talks
  12. Slides from my Sphinx talk at RIT++ 2010
  13. Tokutek MySQL UC Talks
  14. Percona Server version 10
  15. xtrabackup-1.2
  16. How to know if you’re updating Slave you should not ?
  17. Rebuilding MySQL with same options
  18. Customer Success Story: KAYAK uses ad hoc indexing
  19. Announcing New Training Venues for May-August
  20. Should I buy a Fast SSD or more memory?
  21. See us at the O’Reilly MySQL Conference & Expo
  22. fadvise – may be not what you expect

March 2010

  1. Can we get faster expression handling in MySQL
  2. How well do your tables fit in buffer pool
  3. Announcing TokuDB v3.1
  4. RAID throughput on FusionIO
  5. xtrabackup-1.1
  6. fsyncs on software raid on FusionIO
  7. InnoDB TABLE/INDEX stats
  8. Is your MySQL Server Loaded ?
  9. Percona-XtraDB-9.1: released and new coming features
  10. Percona sessions at the MySQL conference
  11. Percona-XtraDB version 9.1
  12. The 451 Group reports on TokuDB v3.0 for MySQL
  13. How many fsync / sec FusionIO can handle
  14. 80x insertion speedup for Profile Technology’s Facebook application
  15. Maximal write througput in MySQL

February 2010

  1. MySQL 5.5-m2 scalability
  2. Why you should ignore MySQL’s key cache hit ratio
  3. Index lock and adaptive search – next two biggest InnoDB problems
  4. Announcing General Availability of TokuDB v3.0 with ACID Support
  5. Missleading Innodb message on recovery
  6. READ-COMMITED vs REPETABLE-READ in tpcc-like load
  7. Blob Storage in Innodb
  8. Introducing percona-patches for 5.1
  9. Introducing tpce-like workload for MySQL

January 2010

  1. New OLAP Wikistat benchmark: Introduction and call for feedbacks
  2. Percona is hiring a Shift Support Captain
  3. Community Events February-March
  4. When Should You Store SQL Serialized Data in the Database?
  5. XtraDB feature: save / restore buffer pool
  6. Why Swapping is bad for MySQL Performance ?
  7. Fast storage: 8 SSD Intel X-25M 80GB benchmarks
  8. How expensive is MySQL Replication for the Master
  9. 2010 Percona Training Schedule
  10. XtraDB storage engine release 1.0.6-9
  11. Recovery Times – Part Deux
  12. InnoDB, InnoDB-plugin vs XtraDB on fast storage
  13. FusionIO 320GB MLC benchmarks
  14. Active Cache for MySQL
  15. Getting around optimizer limitations with an IN() list
  16. Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
  17. High Insertion Rates into a TokuDB Table with Durable Transactions

← 2006–2009 2014–2017 →