June 19, 2013

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of… Jaakola). Parallel applying would fail in case mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed…

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

Post: Dynamic row format for MEMORY tables

September 6, 2011 By 5 Comments

…. In 2008 Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add… in the documentation. What of course interests us is the MEMORY engine performance with this feature added. For that we run a…). VmPeak: 10069048 kB Here we can see that the performance and memory usage is about the same for both row formats. (Speaking…

Filed Under: MySQL, Percona Software

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

…performance impact of extending index is when you increase its length dramatically, for example adding long varchar…memory anymore. How does this affect performance? A: Typically you do not need all your indexes to be in memory…` IN (5)” regarding indexes and performance? A: Recent MySQL versions are …

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

… performance and inner workings of one of the nicest features of the newer MySQL …person_role_id` int(11) DEFAULT NULL, `note` varchar(250), `nr_order` int(11) DEFAULT NULL,…memory). Also, I was testing, as I said before, index condition pushdown. Let’s have a look at the EXPLAIN output: mysql…

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

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL…

Filed Under: MySQL

Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?

January 24, 2008 By 30 Comments

… to present a small benchmark which shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In… to results – this is rather small table which fits in memory in all cases (and dictionary table does too). Second – the… As you can see, ENUM and VARCHAR show close performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE…

Filed Under: Benchmarks Tagged With: , , , , , , ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…MySQL 5.6 server, rebooted and verified again.  Same issue.  This was very different from MySQL 5.5.30, which performs…varchar(25), C_Address varchar(25), C_City varchar(10), C_Nation varchar(15), C_Region varchar(12), C_Phone varchar(15), C_MktSegment varchar…

Filed Under: MySQL Tagged With: , , , , ,

Post: Cache Performance Comparison

August 9, 2006 By 74 Comments

… use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than APC shared memory cache – closest… table test.test for MySQL Cache to work CREATE TABLE `test` ( `k` varchar(60) NOT NULL default ”, `val` varchar(255) default NULL, PRIMARY…

Filed Under: Insight for Developers Tagged With:

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

March 4, 2013 By 7 Comments

…be exactly identical to the same query when performed against InnoDB data, OR that the results returned…, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no …`INNODB_FT_DEFAULT_STOPWORD` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=MEMORY DEFAULT CHARSET=utf8 The docs tell…

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

Post: Percona Server 5.5.15-21.0

August 31, 2011 By 10 Comments

… Improved MEMORY Storage Engine As of MySQL 5.5.15, a Fixed Row Format (FRF) is still being used in the MEMORY storage… VARCHAR, VARBINARY, TEXT and BLOB fields in MEMORY tables. This implementation is based on the Dynamic Row Format (DFR) introduced by the mysql… to decrease memory footprint of those columns and making possible BLOB and TEXT fields and real VARCHAR and VARBINARY. For performance reasons, a…

Filed Under: MySQL, Percona Software
« Older Posts