… of your schema for any significant errors or items requiring review. Columns – a listing of all columns in the schema, really…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… useful for backups (most apply also for btrfs). Let’s review them. Snapshots ZFS does snapshot, like LVM but… since it…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… workload, so we would have lots of diagnostics information to review even if we couldn’t be logged in to the server at the time the problem happened. As I began reviewing available captures, I was able to correlate most load peaks… them, you know it can be a daunting task to review them in servers with thousands of connections. Enter pt-query…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… to produce the most optimal results, I moved on to reviewing FlashCache performance versus that of vCache, and I also included…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… about Galera at this level of detail. I have not reviewed or tested semi-sync in official MySQL so I am…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
I was reviewing the Percona Live sponsors list the other day and pondering …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… size. Now to see this point of intersection, let’s review different workload (which actually is closer to what I need…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… of information about the table structure – InnoDB dictionary. Let’s review tables from the dictionary and see what it can give…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… slow query log and store historical values for review trend analysis into query_review_history table. According to its official documentation you… add and have the following useful columns populated in query_review_history table: * `user_max` varchar(64) DEFAULT NULL – User who…-digest –review h=localhost,D=percona,t=query_review,p=pass,u=percona \ –review-history h=localhost,D=percona,t=query_review_history,p…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… a 35-40% advantage of using Virident FlashMAX. DISCLOSURE: This review was done as part of our consulting practice for which we compensated by Virident. However, this review was written independently of Virident, and reflects our opinion of…
