…-based replication by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 20, 2013 By 10 Comments
@Jervin can you take a look at that thread – any idea of what’s going on? is there any more debug i can do? thanks
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… throughout the graph. We see the exact same pattern when looking at transaction latency; the baseline numbers are roughly identical for…-based flushing still outperforms FlashCache by over 2x, on average. Looking just at sysbench reads, vCache with time-based flushing consistently… at a given level and then attempts to flush as quickly as possible to bring the dirty pages back within acceptable…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… the current time stamp in front of each line. I quickly found that the issues happened during the backups but also… a 48GB server, allowing nearly 10GB of “write cache”. A quick survey of the servers I have access to showed that… to your verification list the point of making sure you look at the Linux settings for the dirty pages. You can…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… itself is the 700GB model. So let’s take a look at the data. With the sysbench fileIO test in asynchronous…, buffer pool size, etc.) but overall the card is extremely quick and handily outperforms the other cards that it was tested… with assorted buffer pool sizes: And in this graph we look at the card’s performance on sysbench OLTP: It is…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… with SAP was hot at this event and MaxDB database looked like it had a solid future. MySQL Cluster and MySQL…-GA 5.0.4 version at the time of event. 2006 was the last year that I was attending the conference… this show. Marten reports revenues of almost $50 million in 2006, preparing for an IPO, and MySQL 6.0 was to…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community… few drinks during the Community Networking Reception). I am personally looking forward to another lengthy discussion with Dimitri Kravtchuk on how…
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
Thanks for the quick fixes!
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…, so as time permits I will try to take a look at that. I suspect that the overall performance is going…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
…’re very welcome, Zoe! Actually the slides are there, too. Look above the orange bar that says “Watch Recorded Webinar” and…
