While I realize that part 2 to the Lucene stuff is still forthcoming… (err..sorry?!), there are some interesting things going on:

1. Giuseppe, John Loehrer and Jimmy Guerrero will host the webinar Designing Scalable Architectures with MySQL Proxy today. Jan and myself will also attend.

   So, if you are thinking about using the proxy or are simply interested in what people do with it, strongly consider attending this one.

2. There’s a quickpoll up on the MySQL website where we’d …

While I realize that part 2 to the Lucene stuff is still forthcoming… (err..sorry?!), there are some interesting things going on:

1. Giuseppe, John Loehrer and Jimmy Guerrero will host the webinar Designing Scalable Architectures with MySQL Proxy today. Jan and myself will also attend.

   So, if you are thinking about using the proxy or are simply interested in what people do with it, strongly consider attending this one.

2. There’s a quickpoll up on the MySQL website where we’d …

In my previous blog post I talk about GROUP BY and ORDER BY optimizations. A member asked a great question that I'd like to share with everyone.


But what if the query was:

SELECT c1, c2, c3, SUM(c4) FROM T WHERE c1 = ? GROUP BY c2 ORDER BY c3 DESC LIMIT 10;

That query would produce a temp table and a filesort.
explain  SELECT c1, c2, c3, SUM(c4) FROM column_test WHERE c1 = 1 GROUP BY c2 ORDER BY c3 DESC LIMIT 10\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: column_test
         type: ref
possible_keys: c1
          key: c1
      key_len: 5
          ref: const
         rows: 1
        Extra: Using where; Using index; Using temporary; Using …

KEY ACCOMPLISHMENTS LAST WEEK

• Constructed an experimental runtime data processing program.

KEY TASKS THAT STALLED LAST WEEK

• None

KEY CONCERNS

• None

TASKS IN THE UPCOMING WEEK

• Modify Skoll to use push-build tar balls for compilation and testing.
• Modify Skoll's data processing scripts for more detailed HTML results pages.

As you probably know MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events passing via relay logs on the Slave which also means there are two replication threads "IO Thread" and "SQL Thread" used in the process but idea remains the same.

For replication to work properly you need to have proper "snapshot" - consistent state of the database as it was on master and corresponding position in masters binary logs. There are multiple ways to get the "snapshot" - shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image etc but in all the cases you have to be sure the snapshot you're dealing with corresponds to correct binary log position.

There are two sources of information for binary log position SHOW MASTER STATUS - this …

I’ve been working with what I used to call “utility computing” tools for about 6-9 months. However, for about the past 2 months, I’ve been seeing the term “cloud computing” all over the place, and there is so much buzz surrounding it that it’s reaching that magical point best described using Alan Greenspan’s words: “Irrational Exuberance”.

When Alan Greenspan used those words to describe the attitudes of investors toward the markets, what he was basically saying was that there were people who didn’t really know what they were doing, putting more money than they ought, into things they knew relatively little about. Further, he was saying that the decisions people were making with regards to where to put their money were a) bad, or at least b) not based on sound reasoning, or the ‘facts on the ground’.

This, I think, is where we are at with “cloud computing”. The blog post that put me over the edge is …

Do you want to go to OSCON but can't afford the entrance fee? I can help. Being on the program committee, I receive a freebie ticket to hand out. Simply answer this question (provided by Brian): Where does name of the TINA storage engine come from, and which engine is it actually when used in MySQL?

Be sure to either login to Livejournal when you reply, or have some other way to identify yourself - an anonymous comment can't be contacted, and thus you wouldn't be able to win the prize...

Interesting interview with Marten Mickos in the Wall Street Journal today. I think he describes the overall environment really well, although I don't quite agree that the innovation spirit is all through MySQL. That depends on where the people come from and their own interests, as well as the drivers of their department.

Also, the number of developers is not really 12M. The 12M people could actually be a huge QA department, and used to be exactly that, but they aren't now. This because new code now goes into the Enterprise branch, and first gets tested by the few thousand Enterprise customers, before being let loose on the wider community (the 12M). I'm sure the Enterprise customers are really pleased about this (ask Mark Callaghan)... it's completely upside down. AKA utterly borked.
…

A few years back, MySQL (the company) has let its trademark application on the name Sakila expire. As you may (or may not) remember, around 2002 there was a grand naming competition for the new logo dolphin, and Sakila name won, over other interesting names like Finn, and corny blah like Flipper (I know this because I was the person wading through the spreadsheet with all the submissions, extracting a shortlist for Monty and David).
(By the way, MySQL docs team lead Stefan Hinz named his son Finn. I don't know if there's a connection ;-)

Anyway, a bit later but still a few years ago already, the name Sakila was registered by the Jose Cuervo company, of global tequila fame. You can easily see this at uspto.gov.
So, I'm just curious does anyone know of a Cuervo product that uses that name now, or is it a dormant trademark? Is there a relevance to the name sakila in Mexican Spanish? The name originates in Africa.... …