It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

Admins in the U.S got a chance to talk shop at EDUCAUSE and the LISA ‘08 summit, but what about those in Europe? Don’t despair, because we’re co-hosting a mini-conference with MySQL, SchoolForge, RedHat, Sun, Op5, and Fusis at our UK headquarters in London on November 27th.

While the presentations are specifically aimed at education as well as the non-profit sector, anyone is welcome to attend. Engage us in discussions about your thoughts on the latest technology, how it blends with your …

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of "amount". The other is the limit of "age".

-- limit of "amount" --

As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the buffer pool is filled by dirty blocks, InnoDB cannot allocate new blocks without flushing the dirty blocks and the performance would get worse. This is the limit of dirty block "amount". We can avoid this limit by setting 'innodb_max_dirty_pages_pct' smaller or setting the larger buffer pool size. We might be never at a loss about the limit.

The another limit we should understand is limit of dirty block "age".

-- limit of "age" --

As you know again, because InnoDB write the modifies of datafile to transaction log file synchronously, InnoDB is allowed to treat its buffer pool as write-back …

We have finally found the time to update out presentation pages - we've added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I've given at HighLoad++ conference back in October.
Innodb Scalability and New Features (Russian),
Scaling MySQL-powered Web Sites by Sharding and Replication (Russian),
…

I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …

I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …

Sun Microsystems always seems to be forced to defend itself, whether it is the company’s ongoing strategy amid dimmed revenue and earnings or its participation in open source. As one who recently considered the fate of a somewhat weakened Sun, I’d also like to highlight a recent series of promising technologies and efforts — dominated by open source — from the venerable technology giant.

Despite continued doubts, Sun continues to focus its strategy on open source software, which is finding its way into the company’s Solaris OS, storage technology with ZFS file system and MySQL database and elsewhere. The company recently launched a new Web site where it is figuratively letting its open source ponytail down and more succinctly staking out its place and …

My prayers have been answered.

We have found a worthy replacement for Jay Pipes: Dups.

• Dups joined MySQL in July 2007.
• Dups until recently was in the MySQL Web Team, and has joined us now.
• Dups comes from Canada (Newfoundland).
• Dups even lives in Canada (Montreal).
• Dups will roam the North American continent to serve the MySQL community, to learn from it, to explain Sun to the community, and to explain the community to Sun.
• Dups is sometimes mistaken for Colin Charles, because of similarities in physical appearance.
• Dups has a somewhat challenging name, Duleepa Wijayawardhana.

I’m very happy we got Dups as our Jay clone, because

• Dups is a MySQL user since last century.
• Dups knows MySQL very well.
• Dups is an excellent communicator: he structures his thoughts clearly and writes an enjoyable …

Exit Jay, whom we will miss dearly. He was the first person that I met in the MySQL community who went to work for the company. That's when I started thinking that maybe I could become an employee as well. …