Monthly Archives: September 2007

Robots 0

I think this should be Spinn3r’s logo: FYI. I found this on pizdaus.com with no permalink or attribution.

Where Does MySQL Lie about Seconds_Behind_Master? 0

In the last month I’ve found two bugs that can cause MySQL to lie about Seconds_Behind_Master (at least on 4.1.22). Let’s recap: Maximum Packet Size on Slaves If max_allowed_packet is large on the master but smaller on the slave the slave won’t be able to read the data from the master. What happens is that [...]

Ron Paul Raises $852k in Five Days 1

So far Ron Paul has raised $852k in five days. They’re targeting 1M. If you think you can help donate here. In a little more than five days, you raised over $852,000 online for the Ron Paul presidential campaign. Our original goal was $500,000, but you blazed past that amount in just a couple of [...]

Using O_DIRECT on Linux and INNODB to Fix Swap Insanity 4

When we migrated to 64bit Debian Etch about two months ago we noticed that some of our database boxes were paging even though they had plenty of memory to perform the tasks at hand. The boxes had 8G and we told INNODB to allocate 7G to the buffer pool. The problem is that after using [...]

Kosmos – Google Filesystem Clone in C++ 0

Today’s Open Source hero award goes to Kosmix for OSSing their GFS implementation: Applications that process large volumes of data (such as, search engines, grid computing applications, data mining applications, etc.) require a backend infrastructure for storing data. Such infrastructure is required to support applications whose workload could be characterized as: Primarily write-once/read-many workloads Few [...]

Ahmadinejad Meets with Jewish Rabbis? 1

I didn’t see this anywhere in the MSM today. Did you? Iranian president Mahmoud Ahmadinejad Monday afternoon met with a group of Jewish rabbis who gave him a silver grail as a sign of friendship. The president is currently in New York to address the United Nations General Assembly.The rabbis carried a placard which read, [...]

Fun with Spammers 4

When you have a large website it seems vendors/spammers are constantly doing a whois on your email and sending you spam to hock their wares. Today I received this fun little email: You are losing business to your competitors because your web site is not showing up high enough on the major search engines. We [...]

Default MySQL Slave Network Timeouts Considered Harmful 1

Remember the other day when I blogged about MySQL being broken with binary replication? I was wrong. It might actually be functional (I still haven’t tested) but the problem was more difficult to diagnose than I originally thought. Here’s what was happening. The default slave_net_timeout value is 3600 seconds. The network was being congested due [...]

Moron in Chief uses Hooked on Phonics 0

This has to be a joke. Apparently, Bush uses a teleprompter with phonetic spelling: When Mr Bush addressed the UN General Assembly today, the White House inadvertently showed exactly how – with a phonetic pronunciation guide on the teleprompter to get him past troublesome names of countries and world leaders. The White House was left [...]

Is MySQL Binary Data Replication Broken? 3

What’s the deal with replicating binary data in MySQL? Is anyone out there doing this successfully? We ran into an evil problem last night with 4.1.22. Apparently, if you replicate binary data (in this case a gzip stream) it will break replication. The data inserts correctly on the master but fails to insert correctly on [...]