Posts Categorized: Pythian

My Failure, Success and Great Experience at Oracle OpenWorld 2011

A bit more than a week passed since most of us who been part of the OpenWorld are back from San Francisco. It is about time to start sharing stories on how it went for each of us. I must admit that it happened to be a very stressful OpenWorld for me personally. I am recovering from it slowly. On the positive side I met so many great people, discovered how supportive people are and how great is to be a part of the Pythian Team! Let’s talk about how my 2 presentations went at Oracle OpenWorld 2011.

Important Caveats When Using pt-online-schema-change

Using pt-online-schema-change is a great way to change a table without downtime or switching over to a secondary database first. While using it on production systems, we found some interesting issues to consider. 1) There were foreign_keys referencing the table we were altering. There are two options to handle this. They are specified with “–update-foreign-keys-method…

The Magic of kSar for one-time system graphs

I forget from whom I first learned about kSar, but I am in debt to that person once again.  I first learned about it about a year ago, and it has been extremely useful whenever I am trying to debug system where I do not have access to trending graphs.  kSar is an open source…

PalominoDB at PerconaLive

PalominoDB is very excited about our participation in the upcoming PerconaLiveconference in London.  We’ll have two of our European staff presenting.  On Monday, Jonathan Levin will be doing a tutorial on Advanced MySQL Scaling Strategies for Developers, and on Tuesday Rene Cannao will be presenting on MySQL Backup and Recovery Tools and Techniques.  Rene and Jonathan…

Indexing text columns with GIST or GIN to optimize LIKE, ILIKE using pg_trgm in Postgres 9.1 (Part 1)

“The pg_trgm module provides functions and operators for determining the similarity of ASCII alphanumeric text based on trigram matching, as well as index operator classes that support fast searching for similar strings.” This is the introduction to the official documentation of the extension at [1]. Note, that I used the EXTENSION terminology instead of CONTRIB,…

Why are your indexes larger than your actual data?

I sometimes encounter this phenomenon when a database has tables in which the indexes are larger—sometimes much larger—than the actual data stored in the table. Often, the table becomes unwieldy, which generates a number of questions: Should I partition? Should I shard? Should I use a different database entirely?   The problem is especially common…

Log Buffer #241, A Carnival of the Vanities for DBAs

World has opened up in San Fransisco with the database bangs. MySQL and Oracle databases have scintillated the hearts of developers, DBAs, technology aficionados, and the mere spectators. That and plethora of news has also poured in from SQLServer melas. This Log Buffer Edition is proud to shed spotlight on all these happenings in this Log Buffer #241.

Back to School: Elementary Physics for DBAs

A few days ago I was asked to estimate how much space needed to be added to the ASM diskgroup to handle the database growth for one year without additional need of adding disks. To do this I needed to calculate acceleration and assuming the acceleration stays the same I would be able to calculate the “distance” or (how much the DB would grow in one year). I used the following formulas…

Page 80 of 227« First...102030...7879808182...90100110...Last »