19 April 2014

The Ruby Reflector

Topic

Baron Schwartz

  Source Favicon
Email

…post titled " How to estimate query completion time in MySQL " by Baron Schwartz. He describes it very well.

NOTE: This won't need innodb_file_per_table = ON but we can use this option only when there are no other parallel transactions running.

So normally in any case, it will become really difficult to find the ALTER TABLE progress unless MySQL itself will provide some feature like MariaDB is providing progress in "SHOW PROCESSLIST" https://mariadb.com/kb/en/show-processlist/ …

mysqlperformanceblog.com Read
  Source Favicon
On Scout ~ The Blog 7 months ago.
Email

MySQL MMM in the wild often results in hard-to-recover problems. Here's Baron Schwartz, MySQL God at Percona, on MMM's flaws :

In short, MMM causes more downtime than it prevents. It's a Low-Availability tool, not a High-Availability tool. It only takes one really good serious system-wide mess to take you down for a couple of days, working 24×7 trying to scrape your data off the walls and put it back into the server. MMM brings new meaning to the term …

scoutapp.com Read
  Source Favicon
Email
  Source Favicon
By Bill Karwin of MySQL Performance Blog over 1 year ago.
Email

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 …

mysqlperformanceblog.com Read
  Source Favicon
Email

…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, …

engineyard.com Read
  Source Favicon
By Baron Schwartz of Engine Yard Developer Blog over 2 years ago.
Email

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, …

engineyard.com Read
  Source Favicon
By Peter Zaitsev of MySQL Performance Blog over 1 year ago.
Email

…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 …

mysqlperformanceblog.com Read
  Source Favicon
By Baron Schwartz of MySQL Performance Blog almost 2 years ago.
Email

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.

mysqlperformanceblog.com Read
  Source Favicon
By Baron Schwartz of MySQL Performance Blog almost 2 years ago.
Email

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:

mysqlperformanceblog.com Read
  Source Favicon
By Baron Schwartz of MySQL Performance Blog almost 2 years ago.
Email

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 …

mysqlperformanceblog.com Read