… a star schema. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets… testing and found that InnoDB does more IO than MyISAM when the database is cold, but uses less CPU time when the database is… #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs better when a larger number of…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… package naming issue that could lead to unresolved package dependencies when installing Percona Server 5.1. … due to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to …. Bug fixed #1003776. XtraDB changed page tracking used to hold the log system mutex for the…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…to?). I get up to speed a lot faster and can contribute to the Development process a lot more effectively when…NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id… and an easy way to use the search feature of your browser to zero in on a …
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the buffer pool. Note that this can be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of… redo-logs to the dirty tablespace and voila, you have a consistent binary backup at a point in time. When running Percona… < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex –apply…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…to admit that this was probably the most interesting question asked; my initial reaction was, honestly, why would you ever want to use…to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… sure to stripe the LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5… for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables… I got were when using compression. I still have to explain this, maybe it is related to better raid controller write cache use. Even the…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to… as you may know, we can use the second index not only for… is the output of our tool when run on the same table, correctly identifying …
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using the … Fixed: Percona XtraBackup 2.1.2 would hang when performing State Snapshot Transfer. Bug fixed #1182698. …backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use…slowdown for write operations when using the InnoDB version. But…using InnoDB under the hood (redo logs, etc). Based on the above numbers, here are the relative differences: InnoDB…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… of queries to playback. Read-only playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will need Percona Server in order to use innodb…-thread-pool that will allow connection reuse. This is necessary when running a large stream of queries. Benchmarks We benchmarked with…
