Originally published in our old blog on January 2009I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a simple query “SELECT FROM table1 WHERE col_n = x”. Since this was a fairly common query that was executed very frequently he had appro
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it […]
As Halloween descends upon us, mysterious emails start reaching our inbox. These plaintive missives are but the screams of the damned, encoded and sent over SMTP. For example, someone known to us only as DBA Guy sent an email with this...Show More Summary
For my entire childhood and most of my adult life, I have been hunting various hardwood stands and cedar swamps across the great state of Michigan. Very rarely, if ever, can I see more than 50 yards in any direction, and all of my hunting is done from ground blinds or treestands. Show More Summary
The Percona Live Europe Open Source Database Conference 2016 in Amsterdam got off to a great start on Monday with a day of tutorials. One of the ones most anticipated was Become a MySQL DBA Part 1 and Part 2, given by Severalnines’ Johan Andersson (CTO) and Krzysztof Ksi??ek (Senior Support Engineer). This hands-on tutorial is […]
Don Buchwald & Associates is bolstering its growing team, adding three new agents in its L.A. office, and a fourth in New York, and promoting two. In Los Angeles, Donyea Rochlin joins as an agent in DBA’s Literary department representing writers and directors in both television and film. Show More Summary
A diverse group of partners came together this afternoon at Endres Berryridge Farm in Waunakee, Wisconsin for the official launch of the Dairy Strong Sustainability Alliance (DSSA), a collaborative sustainability campaign featuring representatives...Show More Summary
Percona is pleased to announce the availability of Percona Toolkit 2.2.19. Released August 16, 2016. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL server and system tasks that DBAs find too difficult or complex for to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release […]
Edan from Death by Audio will be on our Sirius XMU show talking about DbA, and what he's doing now (and he picks all the music). Continue reading…
Good Food Concepts LLC (dba Ranch Foods Direct) of Colorado Springs, CO, is recalling approximately 2,606 pounds of non-intact beef products that may be contaminated with E. coli O157:H7, the U.S. Department of Agriculture’s Food Safety and Inspection Service (FSIS) announced Tuesday. Show More Summary
Specialized databases, cloud, and DevOps expand, not eliminate, role of the DBA.
Deluxe edition of DBA comp Start Your Own Fucking Show Space to feature bonus LP of Segall’s first NYC set.
Company: PM Publicidad dba PM 3 Location: Atlanta, Georgia Industry: Advertising - Creative Career Level: Mid Level Career (5+ yrs experience) Job Status: Full Time Salary Range: $76,000 - $78,000
Yesterday I attended MongoDB World here in Manhattan. There was a huge turnout and excellent sessions but the most exciting part of the day for me was the announcement of MongoDB Atlas. Atlas is MongoDB as a service (part of the DBaaS, data base as a service, category). Show More Summary
When Brooklyn music venue Death By Audio announced its impending closure in fall 2014, a number of higher profile acts who’d performed at DBA were invited back to play the space’s final shows. Those have now been collected into a new 3xLP live compilation Start Your Own Fucking Show Space. Show More Summary
(Paso Robles, CA) – Firestone Walker just announced a special brewery only release of a double barrel aged offering known as … The post Firestone Walker Releases Rye Double DBA This Weekend appeared first on thefullpint.com.
In mid-April, 30 people gathered at DBA, a bar in the East Village, to wish Preston Warhol a happy 6th birthday. It was an afternoon “Sunday Funday,” as Jes Feuer, Preston’s mom, remembers it. The official theme, “Shady Birthday,” mandated one thing: “Sunglasses required, presents aren’t.”Throughout the afternoon, Preston, a ... More »
Structuring multiple ventures under one roof is a common business strategy, especially for large corporations. Small businesses can utilize the same structures (and gain the same benefits). Here's how. The post Multiple Companies Under...Show More Summary
This article is part of DBA, a series on Mashable about running a business that features insights from leaders in entrepreneurship, venture capital and management. Over the last several years, we've seen a landslide of companies prioritizing...Show More Summary
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]