…use the tools. The tools are all part of the Aspersa toolkit. There are three primary tools for troubleshooting intermittent… sample of data to analyze. There are 7 samples, and it chooses the most recent by… many things that can cause a stall in MySQL, and they usually begin microscopically and get …
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 2 Comments
…. The tool that we’re going to use to achieve this objetive is Percona Data Recovery Tool for InnoDB. This is the tool that…. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1, columns 7, indexes… link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…a security group for them. A third instance, the client, will be discussed in part 7. Since …the command line api tools, on Ubuntu, install “ec2-api-tools“. The use of these tools simplifies the …-add-group hamysql -d ‘nodes for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools…skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 
Remove …the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… the diskstats tool, the columns are the number of seconds in the sample, the device name, and the following statistics for reads… of pretty high utilization. (Note: A read concurrency of 2.7 for a 6-device array, plus a few writes that have… do we get for that? Let’s look at some second-by-second output of the diskstats tool during a 30-second…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… your life easy. However, there is one such tool, pt-query-digest (from Percona Toolkit) which provides… logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we…SELECT wp_postmeta # 15 0xA01053DA94ED829E 0.0567 0.7% 213 0.0003 1.00 0.00 SELECT…
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…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 9 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…
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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 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 …
