June 19, 2013

Post: Percona Toolkit 2.1.9 is ready

…=”alignright” width=”300″] Percona Toolkit for MySQL[/caption] About a month ago, we held a bug raffle for Percona Toolkit 2.1.9… with pt-heartbeat 2.1.7 and older, but it also has important bug fixes for other tools. * Fixed bug 1103221: pt-heartbeat…/) fixed a bug: “Added warnings for duplicate key errors when using INSERT IGNORE”. However, standard MySQL does not warn in this case…

Post: SHOW INNODB STATUS walk through

…; asc – ;; 2: len 7; hex 80009c40050084; …for most diagnostic cases – It is left by Innodb developers so SHOW INNODB STATUS can also be used as debugging toolfor each lock structure. For each of connections for MySQL there will be ether not started state if there is no active Innodb transaction for

Post: Maatkit Now Supports Memcached

… Retrieved Have a Low Cache Hit Ratio (i.e. query MySQL too much) Suffer a fate too horrible to contemplate. Percona… first and only tool of its kind. The output is very similar to that which would be displayed for MySQL queries. Commands are… most expensive ones. Here’s the top one: # Query 1: 7.06 QPS, 0.04x concurrency, ID 0x7AFBE9433477C7BC at byte 5983429…

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

…| 7112 | Download Idaho Tax Forms for Individual or Business Needs | 0…. | score | +——+——————–+——————–+ | 7132 | New York Tax Forms | 7.821961879730225 | | 7127 | Nebraska Tax Forms | …MySQL version upgrade before rolling it into production! Percona has tools

Post: dbqp and Xtrabackup testing

… to the tool, we need equivalent testing capabilities.  However, it seems a constant in the MySQL world that available QA tools often leave something to be desired.  The randgen is a literal wonder-tool for database testing… has a 7.1 beta out).  We definitely need to see some Xtrabackup test cases for Drizzle’s version of the tool (mwa…

Post: Aligning IO on a hard disk RAID – the Benchmarks

…was XFS. Barriers and physical disk cache was disabled. The tool I used was sysbench 0.4.10 that came …different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for a … in_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 …

Post: Lost innodb tables, xfs and binary grep

… facts about the system and how data was lost: MySQL had a dedicated partition on XFS file system …was at least one row with the following sequence: 7, 3, 7, 8. Matching by any of the numbers …would not work for many reasons. This is where I found bgrep which was exactly the tool for the task. In…

Post: xtrabackup-0.7 (RC)

… xtrabackup tool and we consider it stable enough to put label RC on it. Changelist includes: – use O_DIRECT by default for… builds for FreeBSD 7 64bit platform You can download current binaries (64bit) RPM for RHEL4 and RHEL5 (compatible with CentOS also), DEB for Debian/Ubuntu, tar.gz for Mac OS / Intel and .tar.gz for FreeBSD 7: http://www.percona.com/mysql/xtrabackup/0.7/. By…

Post: Why audit logging with triggers in MySQL is bad for replication

… the table. Here is where tools like mysqlsla and Maatkit’s …- Check out http://hackmysql.com/mysqlsla_filters for how to filter by statement. …row *************************** Foo_History_Id: 1 Name: maxlength Value: 7 Field_Id: 3 *************************** 2. row *************************** Foo…

Post: A recovery trivia or how to recover from a lost ibdata1 file

… the past, I used this tool a few times and, although it is awesome to dig for data, it is time consuming…=`hexdump -C $t | head -3 | tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) values (‘$tname…, recovered all except one table. For that one, I had to use the Innodb recovery tools but even then, I had a…