Also Baron Schwartz has written a good review of this book .
Q: Given that the book was written in 2005, before MySQL 5.1 and 5.5 were released, is it still relevant?
That book is designed to be RDBMS-neutral, and the concepts it covers apply to other products besides MySQL. The logical principles still hold true: using an index really means leveraging a pre-sorted data structure to reduce the work a query needs to do. The basic data structure of an index hasn't changed …
- Engine Yard Developer Blog: Making Migrations Faster and Safer
- High Scalability: Sponsored Post: Nokia, Oracle, Percona Live, AiCache, ElasticHosts, Logic Monitor, Attribution Modeling, New Relic, AppDynamics,
- RubyLearning Blog: Getting started with Heroku
- New Relic: Case study: For wooga, social games are serious business.
- Scout ~ The Blog: CouchDB in production
- James on Software: InnoDB kernel_mutex Contention and Memory Allocators
…like Peter Zaitsev & Vadim Tkachenko, plus other big names like Baron Schwartz, Harrison, and Ronald Bradford. I ran into people from firms like Yahoo, Google, Daniweb, Pythian, SkySQL & Palomino.
This years event next month features rockstar engineers from an incredible lineup of firms including Etsy, New Relic, Youtube, Paypal, Tumblr, SugarCRM, Square, and of course a few from Percona themselves. I promise you this, these talks won't be salesy …
- James on Software: InnoDB kernel_mutex Contention and Memory Allocators
- till's blog: Hosted MySQL: Amazon RDS (and backups)
- Engine Yard Developer Blog: 5 subtle ways you're using MySQL as a queue, and why it'll bite you
- New Relic: How do you move more than 6000 customers in 2 hours? (Hint: plan ahead)
- Pixellated Visions: Fixing MySQL and rubygem errors on a new rails 2.3.8 install
- Life at the Speed of Green: Stay Connected with the ensure_connected gem
…a single statement capturing all those changes written in the ' SQL' syntax. Baron Schwartz discusses the topic here . This feature enables Rails to merge the changes into a single statement automatically, thus increasing the speed of your migrations."
This is just a sampling of the new features available to you with Rails 3.1. Now everyone who has been building Rails 3.1 applications can start deploying them on Engine Yard today. For all additional documentation, …
- Riding Rails - home: Rails 3.1.0 has been released!
- giant robots smashing into other giant robots: Intro to Rails 3.1
- A Fresh Cup: Double Shot #703
- Ruby Inside: rbenv: A Simple, New Ruby Version Management Tool
- Global Nerdy: Upcoming Tech Events in Ottawa, Vancouver and Toronto
- Mislav's blog: will_paginate v3.0: Rails 3, Sinatra and more
This guest post is from our friends at Percona . They're hosting Percona Live London from October 24-25, 2011. Live is a two day summit with 100% technical sessions led by some of the most established speakers in the MySQL field.
In the London area and want to go? We're giving away a free pass this week. Keep an eye on the @ engineyard twitter feed for a chance to win.
I work for Percona, a MySQL consulting company. To augment my memory, …
- Labnotes: Rounded Corners 288 — /proc
- MySQL Performance Blog: Using MySQL as a Queue, and Free Percona Live Tickets
- MySQL Performance Blog: Using Flexviews - part two, change data capture
- Signal vs. Noise: Nuts & Bolts: Database Servers
- New Relic: How do you move more than 6000 customers in 2 hours? (Hint: plan ahead)
- Scout ~ The Blog: Monitoring MongoDB
Version 1.0.1 of the Percona Monitoring Plugins is released. This is a routine bug-fix release that addresses several minor issues .
The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
The Percona Toolkit team is happy to announce the release of Percona Toolkit versions 2.0.5 and 2.1.2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to the latest versions of the tools.
The complete list of changes is on Launchpad for 2.0.5 and 2.1.2 . Here are some highlights of the changes in version 2.1.2, which is the current development focus:
Percona will be at Southeast Linux Fest tomorrow and Saturday. We're supporting the event, and we hope to meet you there. If you've never been, this is a great regional show that's grown enormously in the last few years. Peter and I will both be speaking: Peter about optimizing MySQL configuration, and I will talk about inspecting MySQL's performance and scalability via TCP packet headers.
In addition, the entire Percona Toolkit and Online Tools team …
- Opscode Blog: Opscode at Southeast LinuxFest 2011
One of our customers asked me whether it's safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server with many tens of thousands of tables.
If you're not familiar with this feature, it creates some new INFORMATION SCHEMA tables that add counters for activity on users, hosts, tables, indexes, and more. This is very helpful information. It lets you run queries to see which tables get the most reads and writes, for example. Another …
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don't miss Vadim's webinar tomorrow!
- Topics: MySQL
- Engine Yard Developer Blog: Rails 3.1 Has Landed
- On the Path: Tuning MySQL
- Ruby Quicktips: Log in to your database console using Rails
- Ruby Inside: 13 New Ruby and Rails Jobs for July 2011
- Sphinx search engine news: Early spring news: 2.0.4 release and conference schedule
- Global Nerdy: And So It Begins (or Frederic's Officially on Board)
The recording of yesterday's webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here .
I got a lot of questions, and did not have enough time to answer all of them, so let me try to answer some of the remaining questions here.
Q: Isn't it possible to take all the locks required in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would cause blocking that would defeat the purpose of the tool.
- Yan Pritzker: iPad - first hands on reactions
- carpeaqua by Justin Williams: My Ultimate Developer and Power Users Tool List for Mac OS X (2011 Edition)
- RubyLearning Blog: Writing modular web applications with Rack