June 19, 2013

Post: 10 years of MySQL User Conferences

April 11, 2013 By 6 Comments

… in form of Quarterly Service Packs [QSP] 2010 The deal between Oracle and Sun is now closed after overcoming a number of bottlenecks… Percona Server and is now a full-scale MySQL alternative and not just replacement for the Innodb Plugin. MySQL 5.5 is… Enterprise edition as plugins. Early preview of plans for MySQL 5.6 more in the form of a code drop than promises what…

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Live Tagged With: , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

… are inflight in the form of deadlock errors.  (This is actually a form of Eventual Consistency where the …a standalone Innodb instance Let’s break it down a bit.  Our unit of locking in Innodb is … deadlock error. This is not implemented for full BEGIN … COMMIT multi-statement transactions since it…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; …Forms | 7.821961879730225 | | 7127 | Nebraska Tax Forms | 6.882259845733643 | | 7123 | Free Forms | 6.748578071594238 | | 7126 | Montana Tax Forms | 6.4749345779418945 | | 7119 | Maine Tax Forms…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

… pool. Though full table scan is only one of replacement policy optimizations possible. Q8: How do you assess current state of Innodb scalability with… constraint: it is sufficient if the referenced columns form a consecutive set of leftmost columns of any index. Can you describe a real…

Filed Under: Insight for Developers Tagged With: ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… webinar this week to give an overview of several Full Text Search solutions and compare their performance. … testing the InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my RAM,…DataImportHandler to import the result of any SQL query, and if you can form a SELECT query that…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…of innodb_data_reads (values over 100 second intervals) | Innodb_data_reads | 54561 | | Innodb_data_reads | 38277 | | Innodb_data_reads | 25895 | | Innodb_data_reads | 31363 | | Innodb…be accessed next – in case of full table scan, index scans …controller may be doing some form of read-ahead on its, …

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Monty unviels Maria and starts Blogging

January 29, 2008 By 4 Comments

…’re hearing great news from Michael “Monty” Widenius – one of the Fathers of MySQL. Monty finally found a time to create his… to see Monty speaking publicly again in the free form rather than in form of sanitized interviews and press releases we’ve seen… – further version to include full transactional storage engine with MVCC and row level locks functionally close to Innodb or Falcon. Though many…

Filed Under: Events and Announcements Tagged With: ,

Post: Video: The InnoDB Storage Engine for MySQL

March 18, 2011 By Leave a Comment

… home of percona material in video form.) Last month I gave a presentation at the PHP UK Conference on the InnoDB storage engine… from PHP UK Conference on Vimeo. It relates to InnoDB built-in and InnoDB plugin.  I left out Percona Server and… at our full day course on InnoDB/XtraDB, the talk “Introduction to the InnoDB Storage Engine for MySQL” (Morgan Tocker) at Collaborate, “Innodb and…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: xtrabackup-0.3, binaries and stream backup

March 13, 2009 By 11 Comments

…InnoDB also ? A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB…tape, or compressed without needs to store full copy of database on local disks. Very often…feature which is not available for InnoDB users in any form so far – it is …

Filed Under: Percona Software Tagged With: ,

Post: Learning about MySQL Table Fragmentation

May 1, 2008 By 20 Comments

… non_idx_col=0″ I use this particular form of query because it will do full table scan – running count(*) without where clause… hard drives in RAID10. Another indication of bad fragmentation was average IO size seen in SHOW INNODB STATUS output. It was around… are single page (16K reads). In case of non fragmented table you would see Innodb sequential read-ahead kick in which does…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts