June 18, 2013

Comment: 10 years of MySQL User Conferences

MySQL/Sun. Oh, yeah, I knew who he was: he was the guy I contacted to have my blog aggregated into planet.mysql.com. He wrote how he likes my blogging and that he happens to… *anyone* really. I had a couple conversations with Roland Bouman on my blog, but that’s it. Ah! Met with an Israeli…

Comment: SimCity outages, traffic control and Thread Pool for MySQL

MySQL Consultant from MySQL Inc to work at eBay on an extended basis in 2007. (as a side story I lived in NY on… conference on their first deployed MySQL system. See http://ebayinkblog.com/2008/04/15/ebay-wins-application-of-the-year-at-mysql-conference-expo/ for more information. Now, a bit more about the code itself is mentioned on an eBay blog at…

Post: The write cache: Swap insanity tome III

…rather complex configuration. Probably most readers of this blog know (or should know) about Linux swappiness setting… to interleave the allocation of memory for the MySQL process using the numactl utility, drop the …setting vm.dirty_ratio was set to 20 on a 48GB server, allowing nearly 10GB of “write…

Post: Percona Welcomes MySQL 5.6!

… many blog posts and articles written on this matter. Instead, I will tell you what is the current state of things with MySQL… Feather sessions, and hallway conversations. As always, please check our blog on a regular basis for Percona product release announcements and to… popular blog posts. We are also scheduling many webinars focused on MySQL 5.6, including one I will be giving on March 6 called “MySQL

Post: MySQL Limitations Part 4: One thread per connection

This is the third in a series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, 3… in this blog post by Mark, and two followup blog posts from Tim Cook (1, 2). Thanks for the great comments on the… have those things, if you’re running a data warehouse on MySQL, and in some cases for other uses too (note that…

Post: Percona Live MySQL Conference and Expo 2013 - News from the Committee - Part 1

… topic that is relevant to the MySQL community as a whole tutorials that are actually hands-on, or at least with comprehensive… and lots of practical MySQL experience Great products in the MySQL ecosystem I’ve been asked to keep blogging on the committee’s progress, so feel free to ask me questions about what’s going on, I’ll…

Post: MySQL Life Cycle. Your Feedback is needed.

… after release. MySQL 5.5 is out almost a year ago and I would still estimate more people running on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though… develops. I would appreciate your feedback on this matter either as comments to this blog posts or as direct email to my…

Post: Two Types of MySQL Users

… other meetings, they read blogs and write them, they may even hack on MySQL. So this fraction of MySQL Community looks a lot larger… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000… Server, they often do not attend MySQL Conference and may not even know Oracle owns MySQL these days. This group is often…

Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE

Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably … and assigns the new value to the column. Prior to MySQL 5.1.22 InnoDB used a method to access that… IGNORE behaviour using a special mutex table, as explained on Baron’s blog to get rid of the gaps problem. A “mutex…

Post: White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident

… working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper “Scaling MySQL Deployments Efficiently Using… saw bunch of benchmarks results published on our blog which proves it. Virident tachIOn will be on the list of our recommendations for customers looking to improve performance or building high-performance solution based on MySQL.