June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… if you don’t need to?).  I get up to speed a lot faster and can contribute to the Development process….  In my case here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0…

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

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

… server can easily handle the write load of all the MySQL instances.  The original idea was to configure them with raid…, you could even be more zealous.  Pretty interesting to speed up point in time recovery when you dataset is 700GB.  If you… together, ZFS on Linux is a very interesting solution for MySQL backup servers.  All backup solutions have an impact on performance…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Percona XtraBackup 2.0.7 for MySQL available for download

May 6, 2013 By 1 Comment

… support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option… being taken which speeds up the backup process. Bug fixed #1130145. Percona XtraBackup didn’t initialize per-thread data in the log…

Filed Under: MySQL Tagged With: , , ,

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

… perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read… QPI bandwidth, and the third one features even higher QPI speed (and thus, faster inter-process/node communication). Results: First of… was explained in the original post, but seems to cause much confusion. Even though the read-only transactions optimization in MySQL 5.6…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

May 7, 2013 By Leave a Comment

… support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option… backup is being taken which speeds up the backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages…

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

Comment: MySQL Partitioning - can save you or kill you

April 30, 2013 By 45 Comments

… _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please… that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed. When PARTITIONed, first it has… is, in my experience, the main use case for PARTITIONing. I go into more details (and code) here: http://mysql.rjweb.org…

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

Comment: Virident vCache vs. FlashCache: Part 1

May 17, 2013 By 3 Comments

… controller such that now it becomes the bottleneck. Also, keep in mind that while SSDs are a lot faster than regular… Micron PCIe card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the… my database to run in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , ,

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

March 4, 2013 By 7 Comments

… Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part 1… treated as stopwords in MyISAM. With 5.5: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘corporation commission forms’ IN NATURAL LANGUAGE MODE… did. In the third and final installment of this series, we will take a look at performance. How does the speed of…

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

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

February 26, 2013 By 1 Comment

… full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense that… files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql 213909504…. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index by declaring…

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

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

March 12, 2012 By 12 Comments

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in… new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…

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