Fotolog is seeking a MySQL DBA. You'll be working with me in a fast-paced, small-team-running-a-very-large-scale environment.

About Fotolog.com:
? 14th most trafficked site (Alexa)
? 3rd most active social network (ComScore)
? Parent company: Hi-Media (France)


Duties
? Work with Director of Database Infrastructure to maintain/improve and support a high traffic, fine-tuned, scalable and reliable database environment on a day-to-day basis.
? Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
? Optimize and tune contentions within the database environment
? Create logging environment(s) to log usage statistics about the environment
? Regularly monitor and periodically conduct random tests of restoration from backups generated within the environment
? Participate in large storage engine migrations
? …

Yup, Yahoo! has finally decided to show balls and reject Microsoft's bid.

Thinking just from search point of view, a Microsoft-Yahoo merger is less evil for the search economy (and by extension online economy) than a Yahoo-Google deal. Of course, this is based on my biased view.

Update: I wonder how long before YHOO drop back to their pre-Microsoft-bid levels.

Update 2: …

The official MySQL Drink. How to make it:
Continue reading "Salmiakki - the official MySQL Drink"

thnx Christophe

Few months back we noticed the incompatibility change related to MyISAM that was introduced in 4.1.23 and recent 5.0 and 5.1 MySQL versions which breaks when one wants to upgrade to 4.1.23 or latest 5.0 or 5.1 when the MyISAM or Merga table is created with 4.0 or earlier 4.1 version.

I reported a bug to MySQL team way back; and looks like they now pushed a patch to 5.1.

This happens even with Merge tables and looks like merge tables are overlooked in that bug report and I am not 100% sure if the patch fixes the merge table issue. This bug is triggered only when the MyISAM table is created with a key column and Merge is associated with …

Found this quote from Michael Tiemann on Matt Asay's blog:
"I would not be surprised to see another $1B deal of some sort in the next 12-18 months. The reason is simple economics...."
Will this come true? Very unlikely, especially within that time frame. Statements like this make MySQL's billion dollar acquisition look like a walk in the park. The reality is that MySQL is a leader in creating an innovative model that brings them pretty decent revenue. It has taken a lot of work from the leadership at MySQL to get it where it is.

So why is it 'simple economics'?
open source beats proprietary software as a development platform and as a value-delivery platform, and given how many millions of dollars companies are seeing wasted on proprietary software, it's only a matter of time before the majority …

You want to know what query is slowing the database or want to check what's going on with a query you
just run, well in mysql just need to type 'show processlist;', but in postgres you must enable two variables
to check this and other stats.

Edit your postgres.conf which should be on /var/lib/pgsql/data/postgresql.conf for *nix installations and add or change this:

stats_start_collector = true

This must be set to true for the statistics collector to be launched at all.

stats_command_string = true

This enables monitoring of the current command being executed by any server process. The statistics collector subprocess need not be running to enable this feature.


After restarting postgres the following query will show currently running queries

/etc/init.d/postgresql restart


…

Michael Tiemann's Cygnus Solutions held the open-source valuation record for nearly a decade at $674 million. A few weeks back, Sun broke that record by paying $1 billion for MySQL. So how long does Michael think MySQL will hold the record?

Not very long.

...I would not be surprised to see another $1B deal of some sort in the next 12-18 months. The reason is simple economics:

...

From Business Week:
http://www.businessweek.com/magazine/content/08_07/b4071000908736.htm

The quote that really brought my intention to the article was this:
Ballmer says: "Yahoo, the brand, will live."

What does this mean to me?

Microsoft is willing to dump $45 billion dollars into the market to take the second position. Technology? They do not care one bit about it. What Yahoo uses and develops is at odds with what Microsoft promotes.

Whether redirects to MS's front pages will last long term is an excellent question. I have some real doubts about that. It would also seem that Yahoo could take a number of directions to poison pill this.

Jabber Yahoo could move their IM to Jabber and open up the valves of the IM market. Effectively commoditizing the IM …

I have almost always found that the Hsieh alogrithm for hashing turns out to be the fast. So this morning while waiting for a compile I popped it into Memcached to see what the improvement would be:

With Hsieh:
Testing generate_pairs 2.396 [ ok ]
Testing generate_data 5.100 [ ok ]
Testing get_read 5.491 [ ok ]
Testing delete_generate 4.587 [ ok ]
Testing generate_buffer_data 1.361 [ ok ]
Testing delete_buffer 0.880 [ ok ]
Testing generate_data 4.984 [ ok ]
Testing mget_read 1.817 [ ok ]
Testing mget_read_result 1.743 [ ok ]
Testing mget_read_function 1.782 [ ok ]
Testing cleanup 0.046 [ ok ]
Testing generate_large_pairs 0.390 [ ok ]
Testing generate_data 39.899 [ ok ]
Testing generate_buffer_data 0.058 [ ok ]
Testing cleanup 0.001 [ ok ]

With default:
Testing generate_pairs 2.405 [ ok ]
Testing …