MyISAM Archives - Percona Database Performance Blog

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

Stephane Combaudon | April 28, 2015 | Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

Bill Karwin | October 23, 2014 | Posted In: Insight for Developers, MySQL, Technical Webinars

Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, […]

More then 1000 columns – get transactional with TokuDB

Przemysław Malkowski | September 25, 2014 | Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, TokuDB

Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for MyISAM. It is usually about full text search or […]

The MySQL ARCHIVE storage engine – Alternatives

Przemysław Malkowski | February 24, 2014 | Posted In: Benchmarks, Insight for DBAs, MySQL

In my previous post I pointed out that the existing ARCHIVE storage engine in MySQL may not be the one that will satisfy your needs when it comes to effectively storing large and/or old data. But are there any good alternatives? As the primary purpose of this engine is to store rarely accessed data in disk […]

Comparing MongoDB, MySQL, and TokuMX Data Layout

Zardosht.Kasheff | July 22, 2013 | Posted In: Tokutek, TokuView

A lot is said about the differences in the data between MySQL and MongoDB. Things such as “MongoDB is document based”, “MySQL is relational”, “InnoDB has a clustering key”, etc.. Some may wonder how TokuDB, our MySQL storage engine, and TokuMX, our MongoDB product, fit in with these data layouts. I could not find anything […]

MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency

Justin Swanhart | May 22, 2013 | Posted In: Benchmarks, MySQL

This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark. There was […]

InnoDB MySQL full text search: Part 2, the queries!

Ernie Souhrada | March 4, 2013 | Posted In: Insight for DBAs, Insight for Developers, MySQL

This is part 2 in a 3 part series on InnoDB MySQL full-text searches. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that […]

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

Ernie Souhrada | February 26, 2013 | Posted In: Insight for DBAs, Insight for Developers, MySQL

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many […]

FictionPress Selects TokuDB for Consistent Performance and Fast Disaster Recovery

Tokutek | January 3, 2012 | Posted In: Tokutek, TokuView

FictionPress Issues addressed: Support complex and efficient indexes at 100+ million rows. Predicable and consistent performance regardless of data size growth. Fast recovery. Ensuring Predictable Performance at Scale The Company: FictionPress operates both FictionPress.com and FanFiction.net and is home to over 6 million works of fiction, with millions of writers/readers participating from around the world […]

Moving from MyISAM to Innodb or XtraDB. Basics

Peter Zaitsev | November 22, 2010 | Posted In: Events and Announcements, MySQL

I do not know if it is because we’re hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar will cover the process in a lot more details though I would like to go over basics in […]

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

More then 1000 columns – get transactional with TokuDB

The MySQL ARCHIVE storage engine – Alternatives

Comparing MongoDB, MySQL, and TokuMX Data Layout

MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency

InnoDB MySQL full text search: Part 2, the queries!

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

FictionPress Selects TokuDB for Consistent Performance and Fast Disaster Recovery

Moving from MyISAM to Innodb or XtraDB. Basics

Upcoming Webinars

PERCONA

SERVICES

SOFTWARE

RESOURCES

CONTACT US

COMMUNITY

CONFERENCES

ABOUT