The Independent Oracle Users Group (IOUG) has released its second major research study focusing on open source adoption trends, "Open Source in the Enterprise: New Software Disrupts the Technology Stack." Conducted for the IOUG by Unisphere Research and sponsored by MySQL AB, the study builds on a similar report issued in mid-2006 covering open source adoption trends in the enterprise stack. The findings point to ongoing interest in open source software solutions for operating systems, databases and middleware with most organizations reporting that they intend to increase their use of open source in general over the coming year. However, open source applications remain less widely adopted.

The full report is available from the IOUG here.

We held our one day MySQL User Conference in the UK this week to a good crowd of nearly 200 people.  We've also got our events lined up Munich tomorrow and in Paris next week. Overall feedback has been very positive and we've maxed out registrations in Paris.  However, there's still some space available in Munich.

• MySQL: European Customer Conferences

Continuing in the tradition, which I hope has been as helpful to you as it has been to me, I’m opening the floor for suggestions on chapter 9 of the upcoming High Performance MySQL, Second Edition. Unlike the other chapters for which I’ve listed outlines, this one isn’t substantially written yet. It’s in detailed outline form at this point (a tactic that has worked very well for us so far – I’ll write about that someday).

I recently upgraded an install of PHP Free Chat to that latest version of 1.0 Final. However it was still lacking a feature to notify individual(s) that someone has joined the chat if they were not already in the chat application to begin with. I came across a posting explaining how to achieve this in PHP Free Chat at PHP Free Chat Forum. After a little reading and discussion I was able to implement the feature.

Here’s my modified version for the solution based on the forum posting. The pfcmail() function can be made to be way more versatile for any use, however for my use it was made to be simple and produce properly formated email messages.

Solution

1. Create a new PHP file called pfcmail.php with the following lines of code.

2. …

I already wrote once about hosting troubles which we had with this site a while back. Today we had another trouble to one of the European hit servers for ClickAider project.

We had purchased this 1and1 server few months ago, before we were running into troubles and as it was running well and because we have rather quick and automated fail over if it ever crashes we do not get into too much trouble.
There is however yet another traffic trick surprise which we got into.

When we purchased the server we specially looked for traffic limits and 1and1 looked very good from the glance view. Promising …

Recently I've spent hours compiling MySQL 5.1.22 and trying to get my cent0s configured for innodb and partitioning. I tried every imaginable way to run configure, use different plugins, etc.I messed with this forever, then finally looked at the config options, and sure enough, the ./configure expects innobase, not innodb as the plugin name: from: http://www.innodb.com/support/tips On MySQL

How fast do you want your installation? Check this.

$ time ./express_install.pl ~/downloads/mysql-5.0.45-osx10.4-i686.tar.gz --no_confirm
unpacking /Users/gmax/downloads/mysql-5.0.45-osx10.4-i686.tar.gz
Executing ./install.pl --basedir=/Users/gmax/downloads/5.0.45 \
[...]
Installing MySQL system tables...
OK
Filling help tables...
OK
[...]
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/msb_5_0_45

real    0m6.773s
user    0m0.245s
sys 0m0.235s

Old times
MySQL has a long established rule of going from downloading to up and running in less than 15 minutes, as stated in various sources, like this …

For the past six months or so, we've been running MySQL 5.1 for various internal and external applications. MySQl 5.1 has been in beta for quite some time and as we move closer to a GA release, I believe its important for us to "eat our own dogfood" by running the software for most, if not all, of our applications. (The reason it's not all is that I don't have control over all of 'em, but that's a different story.) Of course, eating your own dogfood is not an entirely pain-free experience, but the idea is that we should be... READ MORE

One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column even if function is very simple such as arithmetic operation. Same can apply to order by, if you would like that to use the index for sorting. There are however some interesting exception.

Compare those two queries for example. If you look only at ORDER BY clause you would see first query which sorts by function is able to avoid order by while second which uses direct column value needs to do the filesort:

PLAIN TEXT SQL:

1. mysql> EXPLAIN SELECT * FROM tst WHERE i=5 AND date(d)=date(now()) ORDER BY date(d) \G
2. *************************** 1. row ***************************
3.   …

It might seem odd for Alfresco to be announcing that it has open sourced its JLAN technology - given that the company already releases 100% of its code under the GPL (with a FLOSS Exception) - but today the company announced that it has open sourced its JLAN technology as open source.

Why? Because while JLAN was available before as part of its open source content management solutions, it had also been available under a proprietary license (due to legacy reasons - Alfresco acquired the code from another party back in 2005). Today, JLAN is completely open and offered as a separate component.

Who cares? Well, anyone that wants to offer an embedded virtual file system that offers the only Java client and server implementation of Microsoft Window's CIFS (Common Internet File System) protocol, allowing content, system administration information, and …