June 19, 2013

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

…: Fault tolerance: Can you recommend a three node cluster for production use? A: Yes, that’s the recommended configuration. The number… with percona XtraDB Cluster? i.e. can I run a production cluster in synchronous, and a disaster recovery location replicated asynchronously…? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is backed up…

Filed Under: MySQL, XtraDB Cluster

Post: How fast is FLUSH TABLES WITH READ LOCK?

April 24, 2010 By 30 Comments

… with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ… operation. Conclusion A backup system that is designed for real production usage must not assume that FLUSH TABLES WITH READ LOCK…, it is unavoidable. This includes backing up a mixture of MyISAM and InnoDB data. But many installations do not mix their…

Filed Under: Insight for Developers, MySQL Tagged With:

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

March 4, 2013 By 7 Comments

… CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value… MySQL version upgrade before rolling it into production! Percona has tools (pt-upgrade and Percona Playback…

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

Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)

November 6, 2009 By 26 Comments

… MyISAM. 2) Given that the indexes were built with a single bulk load, the MyISAM indexes are not fragmented. That makes the MyISAM… month at a time, then the MyISAM insertions would not do so well, and the MyISAM indexes would be fragmented, and would… best case, B-trees are pretty good. Whereas in in production, many databases are performing close to worst-case insertion workloads…

Filed Under: Benchmarks, MySQL Tagged With: ,

Comment: Unused indexes by single query

September 14, 2008 By 14 Comments

… indexes. In our book we have benchmark for InnoDB and MyISAM: To insert 1 million records in InnoDB with 1 index took 80 sec, with 2 indexes – 136 seconds. For MyISAM the difference is bigger: 72 sec vs 470 sec. And… for usage in production – it is surely each own decision. We use it in production, Google uses it in production, we ported this…

Filed Under: Percona Software Tagged With:

Post: How much overhead is caused by on disk temporary tables

August 16, 2007 By 26 Comments

…) unsigned NOT NULL, `c` char(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 mysql> select * from gt limit 5; +——-+——————————————+ |… we’ve observing (and which is indeed very good production practice, if your temporary tables are moderately sized). Unfortunately …

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !

December 18, 2012 By 3 Comments

… of the production servers. Like illustrated here: But in this case there was one major issue, the tables where MyISAM and this…. Preparing the slaves would then become a loop : for each production server restoring the dump on the node that will be… server. It worked like a charm and the migration of production to Percona XtraDB Cluster became very easy. Thank you MariaDB…

Filed Under: MySQL

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

…, I’ll give you more information. Both servers are real production servers, with powerful hardware and heavy query workloads. Both have… machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important to…-based tuning. Counter ratios suck for everything, not just for MyISAM tuning. I’ve had some heated arguments over these points…

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

Comment: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

…, since I don;t know anything about your application. Perhaps MyISAM is the right choice. You’ve has a review by… remember that your application is probably tuned to work with MyISAM. Just as your application would not work well with Oracle…. MyISAM‘s crashes are a show stopper for myself. 6. “…To be real honest, I don’t know why a production shop…

Filed Under: Insight for DBAs Tagged With: , ,

Comment: Using MyISAM in production

June 20, 2006 By 36 Comments

…. We are having a weird performance problem in production where we are only using MyISAM tables. Here is some background on our… version = 4.1.19 We have been running application in production for almost a year with no problems Our biggest transaction… SLEEP mode We are suspecting ,based on some thread on MyISAM engine forum, that it may be some sort of “garbage…

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