…our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt…means you can place less trust in the place where you store your backups. Our databases hold a variety of…for an adversary gaining access to all of your data is via a backup. By using Percona XtraBackup …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…where a persistent cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL…store operations, 1,000,000 fetch operations): Standard Memcache: Storing…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; …| +———-+——+———————+———-+——+——-+———+ SYS_COLUMNS Table SYS_COLUMNS stores fields …MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… time-based flushing allows the backing store to be written to at a more…where the dirty ratio is only 10%, such as might be the case where a deployment has a massive data…-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…where InnoDB stored the first 768 bytes of variable length columns (BLOB, VARCHAR, TEXT) in the index record, and the remainder stored in overflow pages. COMPACT became the default after MySQL 5.0…. to create them new and migrate data, or affect existing tables with an ALTER…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
… working on a case where we needed to modify a lot of data before pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored… as it shows how much overhead you have by using mysql stored routines interface. So anyway, I asked my colleague Sasha to…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…over multiple MySQL storage engines at various data scales. What is a data warehouse? … two methodologies approach the problem of storing data in very different ways. The …where they maintain a large historical data warehouse, but they also build data marts for OLAP analysis from the warehouse data…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…where memory could be allocated but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored…where your MySQL Support contract can be handy. Conclusion Understanding where MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… Especially when using a CMS where DB structure is prepdefined A: MySQL Server will not automatically define …good to convert it in binary form and store as VARBINARY(16) for performance reasons. In …. This works because by scanning data in index order MySQL gets data in already sorted order and looks…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… completed” otherwise. Verify installation The binary log stores it progress in a metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G… Duplicates: 0 Warnings: 0 And delete data in a second transaction: mysql> delete from test.demo where c1=1; Query OK, 1 row…
