Currently there are several MySQL versions released by SUN. Latest version marked as stable is MySQL 5.1. This version is in build service for some time already and you may noticed that it is on it's way to Factory (no yet there, but working on it). Other newer releases are 5.4 and 6.0. 5.4 is currently in beta stage and date of stable release should be announced later this year. 6.0 is in alpha stage and it might take quite some time till it will be released as stable.

So what? Well, recently I mentioned splitting server: database repository and creating UNSTABLE branch. One reason to do this was to provide a place where experimental version of MySQL can live. And so I packaged 5.4 and it is now available in server: database: …

Where are you going to invest your time and money. You may invest in your kids, your work, your hobbies, and more. As you make these decisions, your passion is one consideration, but another is the return on your investment. Of course, you want your investments to be successful. The best way to ensure success is to bet on winners. In other words, you want to invest your time and money on things you are confident will be successful. This holds true in your personal and your professional life.

When Alexandre Dumas (on a side note, my wife refers to me regularly as a Dumas) said that "Nothing succeeds like success" he was encapsulating this same decision process and the conclusion that people want to bet on winners, and that by so doing, they are perpetuating that winning.

So what does this have to do with open source software (OSS)? I received a note from Roland Bouman about a prior post, where he said: "I got seriously involved in …

OQ Engineer Walter Heck working from Samara, Costa Rica

Life as a Location Independent Professional can be hard at times, and very good at others!

In 2010, the geography of the Internet is set to expand significantly, as ICANN will liberalise the market for domain name extensions. Gandi have commissioned a report from The FutureLab to see how consumers and businesses view this change.
More about the liberalisation process

Is this a squatting opportunity or a branding opportunity?

2/3 of businesses don't realise domain extensions are being liberalised next year. But those businesses that do know about this (like Deloitte) are excited about the opportunities in the areas of global branding. However corporates are also concerned that brand protection mechanisms need to be in place at the new registries, a view that has been raised by Microsoft.
…

Where are you going to invest your time and money. You may invest in your kids, your work, your hobbies, and more. As you make these decisions, your passion is one consideration, but another is the return on your investment. Of course, you want your investments to be successful. The best way to ensure success is to bet on winners. In other words, you want to invest your time and money on things you are confident will be successful. This holds true in your personal and your professional life.

When Alexandre Dumas (on a side note, my wife refers to me regularly as a Dumas) said that "Nothing succeeds like success" he was encapsulating this same decision process and the conclusion that people want to bet on winners, and that by so doing, they are perpetuating that winning.

So what does this have to do with open source software (OSS)? I received a note from Roland Bouman about a prior post, where he said: "I got seriously involved in …

This page is all about MySQL and occasionally PostgreSQL. Contributors work at Facebook, but the focus is on the RDBMS. You can fan the page, get an RSS feed of the notes or get updates at planetmysql.

And visit http://www.facebook.com/MySQLAtFacebook

My old friend and collaborator Theo Schlossnagle at OmniTI posted his slides from his Scalable Internet Architectures talk at VelocityConf 2009.

The slides are brilliant even without seeing Theo talk and I highly recommend the time it takes to flip through them, for anyone who is interested in systems performance. If anyone took an mp3 of this talk I’m dying to hear it, please let me know.

For those of you unfamiliar with OmniTI, Theo is the CEO of this rather remarkable company specializing in Internet-scale architecture consulting. They generalize on Internet-scale architecture, not on one specific dimension the way Pythian specializes on the database tier. This allows them to see Internet-scale workloads from a unique systemic, multidisciplinary point of view; from the user experience all the way up the stack, through …

Just a quick note to say I'll be giving a 1 hour webinar on performance tuning practices for MySQL at 1pm EST, 10am PDT today. Here is a link to sign up for it:

http://www.mysql.com/news-and-events/web-seminars/display-373.html

Hope to see you on the webinar

Most commonly used MySQL specific SQL Commands - Now I don't have to google for them every time I forget the syntax.


GRANT


The GRANT statement enables system administrators to create MySQL user accounts and to grant rights to accounts. To use GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. The REVOKE statement is related and enables administrators to remove account privileges. To determine what privileges an account has, use SHOW GRANTS.

GRANT

priv_type [(column_list)]

[, priv_type [(column_list)]] ...

ON [object_type] …

I'm pleased to announce a release of a new storage engine "Vertical Partitioning storage engine".
http://launchpad.net/vpformysql
You can use relation tables of one to one like one table by using Vertical Partitioning storage engine.
It is near by a view of joined relation tables of one to one but different point is following.
- It can insert.
- It can do partition pruning.(Not use partitions that are no necessity)


Vertical Partitioning storage engine can use following purposes.
(Vertical Partitioning table is called "parent table", integrated tables are called "child table")


1.A MySQL's InnoDB table that has the big record size is very slow if a select statement needs table scanning with a lot of records.
  Vertical Partitioning is good for resolving this performance problem.
…