"[REPLACE] either inserts, or deletes and inserts."

from "REPLACE Syntax"

My question is why it is done like this? Why not simply UPDATE the row? Wouldn't it be a lot less taxing?

I’m interested to know what people consider will behold MySQL in 2007?

The announcement of “You” as Time person of the year can only considered a huge boost to the opportunities in 2007. So, in 2007 here are my 7 (in no significant order).

1. 2007 will be the year of the storage engine. We will see 5 offerings for transactional storage engines, 20+ available and practical engines for management of some form of data.
2. 2007 will see MySQL 5.1 GA (finally).
3. 2007 will see MySQL release it’s own Falcon Storage Engine (GA not until Q4 ).
4. The MySQL Winter of Code will enable the contributions of the community to change feature development. I foresee a Bounty system from an external party or parties for MySQL Features emerging.
5. MySQL will make major press inroads to the RDBMS Big 3 of Oracle, SQL Server and IBM DB2.
6. Despite efforts of MySQL AB, major installations of …

WL#2936 has been updated - the spec has been bought into line with the code and the code has been updated to be in sync with main 5.1.
Time to start to look into the bugs I have waiting for me... And to propose my sprint tasks for January '07.

Another great tool is lsof which provides a list of open files. Unfortunately, once again, it does not come pre-installed on Solaris. What that means is you must install it. The good thing is, it is worth the five minutes that go into its installation.

Before we go into how to install lsof, let's discuss a bit about how lsof works. Lsof works by reading kernel's proc structure information to obtain information about open UNIX dialect files. Lsof relates this information to the user structure. It then reads the open file structures that are normally stored in the user structure. From the 00PORTING file distributed with lsof:

Lsof stores information from the proc and user structures in an
internal, local proc structure table.  It then processes the open
file structures by reading the file system nodes that lie behind
them, extracting and storing relevant data in internal local file
structures that …

I'm still plowing through Richardson's biography of William James, and came across a comment on Hegel that really struck me. Hegel, in a gross oversimplification, believed that history is a series of conflicts, directed by the Geist (spirit) inentrixably toward freedom - thesis, antithesis, synthesis. All conflicts lead toward a positive end of global freedom. As Hegel wrote, "The history of the world [Zeitgeist] is none other than the progress of the consciousness of freedom."

Very nice. What's not to like?

Much, if you're William James. The problem with seeing all conflict as mere disagreements that lead us ever onward toward freedom is that, unfortunately, …

Part 5 of "Managing MySQL on Solaris 10" series will be published later

In Solaris, a process can be in any of the following states during the course of its execution.

O Running
S Sleeping
R Runnable (in dispatch queue)
Z Zombie
T Terminated
C* CPU

Using uptime to get quick summary statistics

-bash-3.00$ uptime
 2:18pm  up 119 day(s), 12:38,  56 users,  load average: 1.00, 0.84, 0.81

[root@db:/] uptime
 2:19pm  up 194 day(s),  1:59,  16 users,  load average: 16.64, 11.16, 13.32

When the competition for processor and other resources gets intense, the processes start getting increasingly delayed. We can see that on the db server, at the time of run queue being sampled, there were between 13 to 16 processes waiting to run (ready for CPU).

What processes are …

Yes, after few hours our 2 contries will become members of the European Union. I would like to send a European greeting to Lucian and Andrei and to all bulgarian and romanian bloggers.

Bine ati venit Europa !
????? ????? ?????? !

Bulgaria
Bulgaria established diplomatic relations with the EU in 1988. In 1993, the European Association Agreements signed and it entered into force in 1995.

In December 1995 Bulgaria submitted its application for EU membership in December 1995. The Commission presented its first Regular Report on Bulgaria’s progress towards accession in November 1998. The second report, released in 1999, recommended that formal negotiations are opened.

Accession negotiations between Bulgaria and the EU started on 15 February 2000. Sofia …

I was walking down Mountain View's Castro Street this afternoon, and noticed that meebo is advertising for developers and system admins. Interestingly, they seem to match the design pattern used by pretty much every web 2.0 company I have seen around here (except MySpace): linux, MySQL, and Ajax. So, there you go.

Tags for this post: mysql web 2.0
Related posts: Managing MySQL the Slack Way: How Google Deploys New MySQL Servers; I won a radio shark and headphones!; …

Fotolog is the top 28th site in the world, according to Alexa rankings today, and, ofcourse, it uses MySQL :)

The last couple of weeks have been fantastic, I’ve learned and discovered so many new things that I haven’t been able to write about any of them. So, I’m going to combine many things into a single post!

Item: I have a new job. After working at the fabulous MySQL for most of 2005 and 2006, I’ve given up my post as Director of Development to take on a new challenge at Canonical Ltd. Canonical is associated with Ubuntu Linux, the Bazaar distributed revision control system, and the launchpad.net collection of services for products in the open source universe. Working for Brian and more recently …