… and MySQL 5.6 optimizer improvements, and both of them look very good indeed. Peter will present the results in an “optimizer… different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as a…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… lot of other good stuff. Robin also showed some optimized improvements for subqueries in MySQL 6.0 which are pretty cool… later in the conference Anders and David barely mentioned it. Performance Tuning Presentations – I’ve visited two of these, one by Anders…. Partner Presentations Couple of sponsors had a time to talk. Dolphin Interconnect was perhaps most interesting for guys dealing with High Performance…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… is it for the company that you work on implementing performance improvement -vs- that other thing? In other cases, you have to… see what is more beneficial to the company – get the performance improvements implemented now or leave things as they are and just…. Once you’re clear on that, it’s time to present the solution, why you think it makes sense and how…
Comment: MySQL 5.5-m2 scalability
March 1, 2010 By 17 Comments
… here – http://www.pythian.com/news/3494/video-giuseppe-maxia-presents-mysql-54/ – I’m looking at the slides and it… mentioned it yourself: http://www.mysqlperformanceblog.com/2009/07/14/performance-improvements-in-percona-5-0-83-and-xtradb/ You specifically made… outdated information…. Still, it would be good to see performance against the Percona performance build and against Xtradb. In fact, it would…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts but in reality it means…. Also be worried about replication with different storage engines. Then performance improvements are worth the risk.
Post: Bug fix of InnoDB scalability problem
November 14, 2006 By 13 Comments
… wrote about this problem before and also investigated in my presentation. Finally bug fix was pushed into 5.0-bk tree… with my own patch I was able to reach better performance. Also as you see there is a thread starvation – last…. So I’d want InnoDB team continue to work on performance improvement. Anyway I think it’s good news.
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… buffering and reduce swap pressure, in most cases this setting improves performance. Though be careful if you do not have battery backed… tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…can build the functionality you need and get the performance you need. Because I’ve built two such … …. primary key(day, ad, is_blue) ); What can we improve here? Especially assuming that there are indexes other …Camp to talk to Alex Esterkin and see him present on it, and based on that exposure, I …
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session …Tomer, Software Engineer, will present “InnoDB Compression: Present and Future”. They will discuss Facebook’s compression improvements and the internal …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… result from MySQL,though at least we get to see performance of individual queries. We also packaged the toolset we used… MySQL capabilities to run complex analytics queries, in particular those presented in TPC-H benchmark are still subpar even with changes… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I…
