…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 MariaDB is providing progress in "SHOW " https://mariadb.com/kb/en/show-processlist/ …itself will provide some feature like
…MMM's flaws :in the wild often results in hard-to-recover problems. Here's Baron Schwartz, MySQL at , on
In short, MMM causes more downtime than it prevents. It's a Low-Availability tool, not atool. 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 …
by Baron Schwartz,and
by Evi Nemeth, Garth Snyder, Trent R. Hein and Ben Whaley
, , Scalability
Web Operations: Keeping the On Time
by Michael T. Nygard
Also Baron Schwartz has written a good review of this book .
Q: Given that the book was written in 2005, before5.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 …
…a single statement capturing all those changes written in the ' topic here . This feature enables to merge the changes into a single statement automatically, thus increasing the speed of your migrations."' syntax. Baron Schwartz discusses the
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 ontoday. For all additional documentation, …
This guest post is from our friends at Percona . They're hosting Percona from October 24-25, London . Live is a two day summit with 100% technical sessions led by some of the most established speakers in the field.
In the @ twitter feed for a chance to win.area and want to go? We're giving away a free pass this week. Keep an eye on the
I work for, a MySQL consulting company. To augment my memory, …
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 …
Theare high-quality components to add 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 and , 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.
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 configuration, and I will talk about inspecting MySQL's performance and scalability via packet headers.will be at
In addition, the entire Percona Toolkit and Online Tools team …