You searched for big insert myisam - MySQL Performance Blog

Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By Vadim Tkachenko 32 Comments

After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements [...]

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: Benchmarking, InnoDB, Percona Server, TokuDB

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By Jervin Real 10 Comments

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these [...]

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: galera, Jervin Real, Percona XtraDB Cluster, pxc, replicating

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

February 26, 2013 By Ernie Souhrada 1 Comment

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 [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: Ernie Souhrada, FTS, FullText Search, InnoDB, MyISAM, MySQL 5.6

MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By Vadim Tkachenko 21 Comments

MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I can’t say that my experience was totally flawless, I bumped into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at the end, is not [...]

Filed Under: Benchmarks, MySQL

MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By Peter Zaitsev 4 Comments

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway. Q: One developer on our team wants to replace longish (25-30) indexed varchars with [...]

Filed Under: Insight for DBAs, MySQL

Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By Aurimas Mikalauskas 13 Comments

In the first part of this article I have showed how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+0 with 64k stripe element. I haven’t been running any benchmarks [...]

Filed Under: MySQL

The case for getting rid of duplicate “sets”

May 17, 2011 By Justin Swanhart 2 Comments

The most useful feature of the relational database is that it allows us to easily process data in sets, which can be much faster than processing it serially. When the relational database was first implemented, write-ahead-logging and other technologies did not exist. This made it difficult to implement the database in a way that matched [...]

Filed Under: MySQL

Checking the subset sum set problem with set processing

May 16, 2011 By Justin Swanhart Leave a Comment

Hi, Here is an easy way to run the subset sum check from SQL, which you can then distribute with Shard-Query:

CREATE TABLE `the list` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `val` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM;
SELECT val as `val`, COUNT(DISTINCT (id)) as `cd`
FROM  test.data as d  WHERE val in (-2,-3,-10,15,15,16)
GROUP BY val;
+-----+----------+----------+
| val | cd       | CNT      |
+-----+----------+----------+
| -10 |        1 |        1 |
|  -3 |        1 |        1 |
|  -2 |        1 |        1 |
|  15 | 35417088 | 35417088 |
+-----+----------+----------+
5 rows in set (40.20 sec)

CREATE TABLE `the list` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`val` bigint(20) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

KEY `id` (`id`)

) ENGINE=MyISAM;

SELECT val as `val`, COUNT(DISTINCT (id)) as `cd`

FROM test.data as d WHERE val in (-2,-3,-10,15,15,16)

GROUP BY val;

+-----+----------+----------+

| val | cd | CNT |

+-----+----------+----------+

| -10 | 1 | 1 |

| -3 | 1 | 1 |

| -2 | 1 | 1 |

| 15 | 35417088 | 35417088 |

+-----+----------+----------+

5 rows in set (40.20 sec)

Notice there is no 16 in the list. We did not pass the check. There are enough 15s though. The distinct value count for each item in the output set, must at least [...]

Filed Under: MySQL

Ultimate MySQL variable and status reference list

January 8, 2011 By Baron Schwartz 4 Comments

I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an option and [...]

Filed Under: Insight for DBAs, MySQL

Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By Vadim Tkachenko 50 Comments

Accidentally me and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron’s example I also run the same load against MonetDB. Reading comments to Baron’s post I tied to load the same data to LucidDB, but I was not successful in this. I tried to analyze a bigger dataset and I took public [...]

Filed Under: Benchmarks, MySQL Tagged With: Infobright, MonetDB, OLAP, reporing

Benchmarking Percona Server TokuDB vs InnoDB

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

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

MySQL 5.6.7-RC in tpcc-mysql benchmark

MySQL Indexing Best Practices: Webinar Questions Followup

Aligning IO on a hard disk RAID – the Benchmarks

The case for getting rid of duplicate “sets”

Checking the subset sum set problem with set processing

Ultimate MySQL variable and status reference list

Analyzing air traffic performance with InfoBright and MonetDB

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA