According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will continue the topic of BigData with a talk titled, “Conquering BigData with… for event attendees. If you‘re in the Portland area and work with MySQL, then this is an event you can‘t afford to miss… 
So register…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… 12GB of data in the largest table. You can find the individual SSB query definitions in … buffer pool is cold. Please don’t take away that you should be using MyISAM for …are limitations which MyISAM imposes that are difficult to work with. MyISAM does not maintain checksum consistency during …
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Hi Moazam, 1) no, you don’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you‘re planning to switch back from Percona Server 2) here is the…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… with your config is this: “limit ARC size to 4GB” ZFS needs a significant portion of ram to work with. I agree that limiting ARC to… and deduplication both need plenty of) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends… ZFS is worthwhile. (All ZFS systems should max ram slots with 16gb dual rank dimms, which are relatively cheap these days…
Comment: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
pacemaker has been a real pain in the butt to work with on 6.4.
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…to 1.18. You can also follow the official documentation here. The version of Pacemaker (always considered as Technology Preview by RedHat) provided with…Waiting…works again as expected and you should be ready for the next distro upgrade! INFO: If you…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…, not that much – I have personally only worked with one customer that’s using 5.6),…with 5.6 if you‘re not using GTID-based replication. If you are using GTID-based replication, it looks like you‘ll need to wait…why would you ever want to use MySQL on top of something like that? I can‘t imagine the…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… can be obtained from the slow or general log, but this involves a lot of data you don’t need too, and isn’t… be sent to the plugin, and you can control if it gets written on not with this list. I tested this with “connect,Quit” to log successful and failed connections. Yes, it had to be a capital Q in Quit for that to work, and…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with…, you can utilize the –export flag during the –apply-logs phase and then re-import those files to a running server. However, you need to have existing table structures in place. Fortunately, this can be done easily using mysqldump –no-data. Now, enough with the…
