… in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10… the default configuration, second is with expand_fast_index_creation=1 which builds table with primary key only when creating a… faster. P.S The tests were done with Percona Server 5.5.24-26.0
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
…_allowed_packet This new variable will be available in 5.1.64, 5.5.26, and 5.6.6 and can establish a different limit on…_allowed_packet. Training In September I’m going to deliver MySQL Training (Sep 3-6) in Madrid. This is the first… get more information. En Septiembre voy a impartir Formación de MySQL en Madrid (Sep 3-6). Está será la primera vez…
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion… I was thinking this small patch will be merged to MySQL 5.5 promptly, yet it has not happen to date. Here is… | alter table sbtest add key(c) 1MB 34 sec 8MB 26 sec 100MB 21 sec 128MB 17 sec REBUILD 37 sec…
Comment: Percona-XtraDB version 9.1
March 15, 2010 By 16 Comments
Peter, There is MySQL-shared-compat in our repo. it provides .12.so – .16.so: MySQL-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.1.40, 5.0.87, 4.1.22 and 4.0.26
Comment: MySQL random freezes could be the query cache
March 20, 2009 By 23 Comments
… year ago with the 5.1.26 release. Depending on the mysql-load the issues happened every 20 minutes. After debugging mysql and we also…, according to the developers this issue had been fixed in 5.1.29. But nevertheless we did not re-enable the query…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… —TRANSACTION 12303, ACTIVE 26 sec mysql tables in use 2, locked 0 MySQL thread id 53038, …, ACTIVE 3 sec fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap…MySQL 5.0 and older MySQL versions). MySQL level locks are entirely different story. Explicitly locking tables on MySQL…
Comment: How does MySQL Replication really work?
January 10, 2013 By 9 Comments
… more than one event to fetch. Note that since MySQL 5.1.64 and 5.5.26 there’s a new variable slave_max_allowed_packet…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance … Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs … more statistics and finer-grained samples, say, every 5 seconds instead of every minute, and some samples…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so … Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock is persistent Update Time : Fri Aug 26 22:11:26 2011 State : active, FAILED, Not Started Active Devices : 4 Working Devices : 5 Failed Devices : 0 Spare Devices : 1 Layout…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…_FORMAT | +————+ | Compact | +————+ ~/recovery-tool# ./page_parser -5 -f data/salaries.ibd Opening …26 | PRIMARY | | 27 | emp_no | +———-+———+ B) InnoDB Table Monitor The index information can also be taken directly from MySQL….pl –host 127.0.0.1 –port 5520 –user root –…
