June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

… 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…

Post: ZFS on Linux and MySQL

… 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…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… 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…

Post: More on MySQL transaction descriptors optimization

… 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…

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

… 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…

Comment: MySQL Partitioning - can save you or kill you

… _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…

Comment: Virident vCache vs. FlashCache: Part 1

… 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…

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

… 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…

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

… 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…

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

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…