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 …

Yesterday I've attended MySQL Customers Conference in London. This event is much smaller size than Users Conference (one day and about 170 people attending) and surely less geeky - there were no one from MySQL Development Support or Consulting teams and Sales Engineers were as close as you could get. Though Anders Karlsson and Ivan Zoratti are one of the best of the kind being more technical than quite a few of the teams mentioned.

It started with Robins presentation about MySQL features and Roadmap. Not what it was something new but it was good to hear about release plans for MySQL 5.1 (Q1 2008) and MySQL 6.0 (Q4 2008) - which sounds pretty ambitious to me but we shall see how many resources 5.1 will take after it is released to get all the issues resolved. Falcon will be default transactional storage engine in MySQL 6.0 - I did not truly understand if it will be recommended transactional storage engine or just default storage engine will …