June 18, 2013

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

… access to another “backup” server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome part of this process… `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B….TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure, here are the versions I was using on my test…

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

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

June 5, 2013 By

…/s eth1 DOWN:81 KB/s UP:368 KB/s eth1 DOWN:78 KB/s UP:363 KB/s This isn’t much traffic in my… guys and beyond the scope of this post, but in my trivial VM environment, I just need to make sure that the multicast address space routes to my Galera replication interface, eth1: [all nodes]# ip ro add dev…

Filed Under: Percona Software, Percona XtraDB Cluster Tagged With: , , ,

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

… all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have time to analyze it…-checker will not be necessary for MySQL 5.6? Let’s have a look at the code implementing this feature. The… keys, but not redundant ones. What is the difference? Let’s see an example. If we execute: mysql> ALTER TABLE test…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

… stable release in the 5.5 series. All of Percona’s software is open-source and free, all the details of…-3909). Bug fixed #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password…

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

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

… (e.g. SELECT cols FROM idx1p0,idx1p1,idx1p2 WHERE …), otherwise if it’s more convenient that the index looks as if it…

Filed Under: MySQL Tagged With: , , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

… the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL  has… us more flexibility by allowing users to extend the server’s functionality with their own code, and this is what the… reference, these are the lines I had to add to my config file for the plugin to work (plus one commented…

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

Comment: INSERT INTO ... SELECT Performance with Innodb tables.

May 22, 2013 By 22 Comments

…mathew: Wrong, it’s still the same in 5.5. Here is the related … use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle… label_to_device ld on (ld.device_id = d.id) where ld.trash = ‘f’ and cai.trash = ‘f’ and (cai.status…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… with default settings using only the InnoDB storage engine.  In my testing I discovered that innodb_old_blocks_time had an… at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A star… table. You can find the individual SSB query definitions in my previous blog post. Test environment These tests were done on…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Comment: Percona XtraBackup 2.1.2 for MySQL available for download

May 22, 2013 By 4 Comments

… could not start my second and third node. I must rollback on 2.0.7 version, and now it’s ok. Why…

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

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

May 21, 2013 By 8 Comments

… same time? To find an answer to these questions, let’s create a simple replication configuration with one master and two… try: configure only one of the servers with GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show… nice to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly…

Filed Under: MySQL Tagged With: , ,
« Older Posts
Newer Posts »