June 19, 2013

Post: Percona Toolkit 2.1.9 is ready

February 15, 2013 By Leave a Comment

…=”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…

Filed Under: Events and Announcements, Percona Software, Percona Toolkit Tagged With: , ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…; 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 tool…for each lock structure. For each of connections for MySQL there will be ether not started state if there is no active Innodb transaction for…

Filed Under: Insight for DBAs Tagged With:

Post: Maatkit Now Supports Memcached

July 24, 2009 By 11 Comments

… 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…

Filed Under: Insight for Developers Tagged With: , , , ,

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

March 4, 2013 By 7 Comments

…| 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…

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

Post: dbqp and Xtrabackup testing

November 16, 2011 By Leave a Comment

… 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…

Filed Under: Benchmarks

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

June 9, 2011 By 13 Comments

…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 …

Filed Under: MySQL

Post: Lost innodb tables, xfs and binary grep

November 9, 2010 By 12 Comments

… 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…

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

Post: xtrabackup-0.7 (RC)

May 21, 2009 By 4 Comments

… 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…

Filed Under: Percona Software Tagged With: ,

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

September 29, 2008 By 10 Comments

… 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…

Filed Under: Insight for DBAs Tagged With:

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

June 3, 2011 By 8 Comments

… 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…

Filed Under: MySQL
« Older Posts
Newer Posts »