… on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0. Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL 5.0 is still…
Post: Speaking on San Francisco Meetup 14-Dec : What's new in XtraDB/InnoDB-plugin 5.1+
November 29, 2010 By Leave a Comment
Post: Webinar: MyISAM to InnoDB migration
November 8, 2010 By 4 Comments
… about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time. Update: the… default storage engine from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect that a lot of users will be… be sure to sign up soon. Again, the date is Dec 1, 2010 at 9:00 AM PST.
Comment: State of the art: Galera - synchronous replication for InnoDB
December 28, 2009 By 13 Comments
… production is 0.7 and it is for MySQL 5.1.39. It’s been released Dec. 1st and we provide support for it…). 0.7.1 is coming out soon and will be for MySQL 5.1.41. In general, each MySQL/Galera release targets particular MySQL version (since it is a patch). In future we will continue to follow official MySQL GA…
Comment: State of the art: Galera - synchronous replication for InnoDB
December 22, 2009 By 13 Comments
… production is 0.7 and it is for MySQL 5.1.39. It’s been released Dec. 1st and we provide support for it…/codership-mysql). 0.7.1 is coming out soon and will be for MySQL 5.1.41. In general, each MySQL/Galera release targets particular MySQL version (since it is a patch). In future we will continue to follow official MySQL GA…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… with MySQL you might need to deal with RAID recovery every so …Layout : left-symmetric Chunk Size : 64K Device Role : Active device 5 Array State : AAA.AA (‘A’ == active, ‘.’ == missing) Note the … ReadyNAS1:/# fsck /dev/c/c fsck 1.41.14 (22-Dec-2010) e2fsck 1.41.14 (22-Dec-2010) /dev/c/c: clean, 25…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…/sda1 and you will get something like this: dumpe2fs 1.41.14 (22-Dec-2010) Filesystem volume name: Last mounted on: /mnt… defaults to 5% of total blocks, which is probably not needed for partition you store MySQL data on, as chances are MySQL server… so often check MySQL tables for corruption. To change those options you can run tune2fs -m0 -i0 -c -1 /dev/sda1 changing…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise … Current date: Thu Dec 29 07:09:32 2011 # Hostname: somehost.net # Files: slow-query.log.1 # Overall: 20…. SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 …
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
… both problems 5.0.32-bk (snapshot from 26 Dec 2006) – with 15815 bug fix 5.1.12 with fix of thread trashing 5.1.14 with all fixes 5.0.30 just… compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were used: libexec/mysqld…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… File Per Table) -rw-rw—- 1 mysql mysql 8578 Dec 16 20:33 test_innodb.frm -rw-rw—- 1 mysql mysql 98304 Dec 16 20:33 test_innodb… only see 16K of data+32K of index, so another 5 pages are invisible. This tells me you can’t use… significantly (to 9MB): -rw-rw—- 1 mysql mysql 8578 Dec 16 20:58 test_innodb.frm -rw-rw—- 1 mysql mysql 9437184 Dec 16 21:06 test_innodb…
