Home |  FAQ |  Submit your blog feed |  Feedback |  Aggregate feed RSS 2.0 English Deutsch Español Français
Showing entries 1 to 10 of 6763 Next 10 Older Entries
Upcoming MySQL Camps in India
Building on the momentum created by OSS Camp-Mumbai, and having received very positive response from the OSS community -- a second Indian OSS Camp has been scheduled for September 8-9, 2007 in Delhi.
Employee GPL3 Released

The Free Software Foundation today announced the finalized version of the long awaited GPL3 open software license.  This was pretty long in the making, more than 16 years since the prior release, but the process, led in large part by Eben Moglen, was deliberate with input from a broad range of users, vendors, developers and lawyers.  Pretty much anyone who wanted to comment on the GPL was able to.  MySQL participated in the process, both through David Axmark's early discussions and feedback as well as Kaj Arno's chairing of a subcommittee.  I'm also glad that the FSF took the extra time to address

  [Read More]
Top 5 Wishes for MySQL

About a week ago Marten send me email pointing to his article published on Jays Blog (Come on Marten, it is time for you to get your own blog). I should have replied much earlier but only found time to do that now. So here is my list

1. Be Pluggable

Unlike many OpenSource projects MySQL was single chunk of code and for years the only way you could officially extend it was using UDFs which was very limited. Compare this with other OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes - now there are plugable storage engines (something even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before you could do any

  [Read More]
Open Source ETL tools.

The other day I was looking for a open source, feature-rich, high performance ETL tool to use in an enterprise environment. I was disappointed nothing really seemed to match my requirements. Have I overlooked something or is this really a niche where there aren’t any viable projects? After looking in the usual places like sourceforge.net and doing a bunch of Google searches. I could not find any products that fit the bill. Here are (some of) my criteria:

  • Fast. The candidate tool has to be able to move huge amounts of information between the source and target databases quickly.
  • Flexible error handling. Data errors occur all the time, and when errors are encountered, we should be able to stop processing or log the error to a file or push the record into a violations table for subsequent processing. There are probably other popular strategies for handling errors, such as changing the
  [Read More]
Employee MySQL Congratulates FSF on GPLv3

We congratulate the Free Software Foundation on the release of GPLv3 and offer our thanks to the many individuals in the open source community who participated in the process of drafting the license.

It’s good to see overall improvements in GPLv3 over GPLv2, when it comes to compatibility with other Free/Open Source Software licenses, to the compatibility with other legislations than the US legal system, and to strengthened incompatibility with Software Patents. I am also happy if the work of the Committee B ends up contributing to a better adoption of GPLv3. I am in awe as to the patience and skillful diplomacy with which Eben Moglen could tame the group consisting of everything from techies from comparatively small companies (like Trolltech and ourselves) to the seniormost lawyers from the biggest Fortune 500

  [Read More]
Employee Query cache is slow to the point of being unusable - what is being done about that.
We spent a lot of time this month trying to fix Bug#21074 "Large query_cache freezes mysql server sporadically under heavy load".

In a nutshell, invalidation of a table can be dead slow (seconds) when there are tens of thousands of cached queries associated with this table, and, moreover, invalidation
freezes the entire server when it happens.
It's so funny, this thing happens under two singleton mutexes (one instance of the mutex exist in the entire server) both of which are required for every single query that the server gets.

Invalidation is indeed somewhat slow, but making it a bit faster will only shift the threshold when the query cache becomes unusable from tens of thousands of cached results, to, say, hundreds of thousands. So we thought it'll only change the depth of the hole in which people will discover they've shoot themselves in the foot.
Besides, any change






  [Read More]
About 'semi-unicode' And 'quasi Moon Stone'
It is now about 1 month ago SQLyog 6.0 was released for the public. This is the second almost total 'overhaul' of the program code in about 9 months (first was the Open Source release back in the autumn of 2006). The first 6.0 release was quickly followed by a series of 'service releases’, of which the newly released 6.04 is the latest.

A complete 'overhaul' or 'rework' of a complex code base will always have some issues. We know from our download statistics that only about 20% of user download betas and RC's - and some of those probably only download to do a 'quick check-up' and will continue to use the stable version for production use. So only once a new major version is released, the bulk of users will start using it. And what was missed in internal testing will show up.

Something did show up of course. Except for some minor issues, the



  [Read More]
Employee My top 5 MySQL wishes
There has been a trend in the blogs for top5 MySQL wishes.
Many people, including Ronald Bradford, Alan Kasindorf, Jim Winstead, Jonathon Coombes, Jeremy Cole, Jay Pipes, Antony Curtis, Stewart Smith coined in.

Here're my 5:

1. Remove excessive fuss. OK, we know what needs to be done, just give us time to get things in




  [Read More]
Four more open source startups to watch

Matthew Aslett is highlighting four open source startups to watch: Aptar, GravityZoo, Loopfuse, and Untangle. I've talked about Loopfuse and Untangle before, but Aptar and GravityZoo are news to me.

That's one of the great things about the commercial open source ecosystem right now. People can complain that there aren't enough (public) examples of success yet, but one of the great examples of general commercial open source success is that there are so many new companies getting funded and/or getting traction. This is a vibrant, growing ecosystem.

Growing in breadth, but also growing in depth. My employer, Alfresco, reported strong

  [Read More]
Employee More on queue... Possible Solution...
My blog is blocked to those who have a livejournal account. I set it
up this way years ago because I hate dealing with comment bots that
generate SPAM. This means I get a lot of back channel comments on my
posts (aka email, IM, IRC) that you never actually see on the
site... I don't normally post them but this one from email was pretty
interesting:


The challenging design issues about queuing are about locking and
indexing, not about the API. The API to look at queues and message
should be SQL (so you can use SQL to access the message properties,
the message history, and the payload or do auditing and tracking),
but the API to modify the queue must be something else to preserve
the integrity of the queue.

Oracle Streams AQ does not support data manipulation language (DML)
operations on a queue table















  [Read More]
Showing entries 1 to 10 of 6763 Next 10 Older Entries

SQL injection explained