… consistent pattern. This new behavior was introduced in 5.6.7 with the closing of this bug (although this was initially… duplicate index. Does it mean that tools like pt-duplicate-key-checker will not be necessary for MySQL 5.6? Let’s have… for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…7-x see this report. So if you want to upgrade, you cannot apply any rolling upgrade process. So like for…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…_tool or clustat (…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…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: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… but powerful way to profile MySQL memory usage; the Massif tool from Valgrind. An excerpt from …could also just leave the server running for some time (for example, if you have experienced memory …(in /lib64/libpthread-2.5.so) | | | ->10.10% (7,135,744B) 0x3ECEAD325B: clone (in /lib64/libc-…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 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: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…for use with tools like Mondrian and also for…for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL… | 12 | Sending data | 33.764396 | 7.523023 | 40.173893 | 13.027019 | …
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 8) 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 55 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…
