… not easy going from Linux to illumos ZFS by giving up 10% total ram for metadata caching, but it is just the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… are interested in listening to the presentation, it’s currently up and available for viewing over at percona.com. My apologies… kernel has to do in reordering TCP packets can actually result in performance that’s worse than a single NIC.] The… binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down to the…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… you and your team. Summer is the time to brush up on those critical skills needed to ensure all systems are… Begins Monday, August 19, 2013 , 9am – 5pm We have a 10% discount code for use when ordering, register early and save even more as the 10% discount can be applied to the early registration price. Just…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… old data if you don’t need to?). I get up to speed a lot faster and can contribute to the… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc…-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… temporary table to store an interim result set, and then use that to ultimately produce the result you want, that’s another… to be first, then look up matching rows in `title` by a secondary index. But the result was that it created a… it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where you were…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June 5, at 10 a…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to have metadata checksums. d) What compression algo… latest entrant to filesystem is Tux3 which is showing impressive results in performance.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine… some discussion in the comments and I promised to follow up with more SSB tests at a later date. I also… this benchmark does not cover. I will make a follow-up post about concurrency in another blog post in this series…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… WHERE a.parent=” . $parent); echo “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row['label'] . “”; display_menu($row… “”; } display_menu(0, 1); ?> Posted by bikash ranajan nayak at 10:30 AM
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… FREE one-day educational events, we are pleased to feature 10 technical talks by members of Team Percona as well as…
