This blog describes background and implementation of a poll
set to monitor many sockets in one or several receive
threads. The blog is intended as a description but also to
enable some feedback on the design.

I've been spending some time working out all the gory details
of starting and stopping lots of send threads, connection
threads and receive threads over the last few months.

The receive threads will be monitoring a number of socket
connections and as soon as data is available ensure that
the data is received and forwarded to the proper user
thread for execution.

However listening on many sockets is a problem which needs
a scalable solution. Almost every operating system on the
planet has some solution to this problem. The problem is
that they all have different solutions. So I decided to
make a simple interface to those socket …

phpMyAdmin and MySQL Forge, along with the MySQL Build Farm initiative were the main MySQL related benefactors of Google Summer of Code 2008. phpMyAdmin got BLOB Streaming support and a simplified setup script, MySQL Forge got RSS and Atom feeds and the MySQL Build Farm got a test schedule.

Directly mentored by phpMyAdmin originator Marc Delisle, GSoC student Raj Kissu Rajandran completed the BLOB streaming support in phpMyAdmin. This is how he describes his project goals (which are now achieved):

It is often common to come across a website, especially a blog, that is built on a pairing of MySQL and PHP. Seeing as how most of those who run such websites on the Internet do not have access to a Shell account or have experience in managing applications from the command-line, …

The 2009 MySQL Conference has closed it’s submissions for papers. This year the motto is “Innovation Everywhere”.

Last weekend’s Open SQL Camp in Charlottesville, Virginia, we had the chance to talk about the movements in the MySQL ecosystem. I was impressed to get the details of the Percona MySQL Patches, but focus is still in 5.0. (Welcome to the Percona team Tom Basil) Our Delta is attempting now to integrate patches into various MySQL branches. There was an opening keynote by Brian Aker from Drizzle, and Drizzle team Jay Pipes and Stewart Smith on hand. It was also announced that MySQL 5.1.30 will be GA, available in early December.

But these …

MySQL Query Analyzer is already helping people to drastically improve their application performance. 

Jeff Freund (CTO, Clickability) shares an interesting use case.

This week (November 24/25/26) I'm visiting the Providence RI, Attleboro MA and Marlboro MA areas just before thanksgiving in the US. If anyone in the MySQL community, or heck any open-source community in those areas wants to meet up, please drop a message onto this blog. For everyone else in the US, I wish you a happy thanksgiving.

From ha_myisam.cc:

/*
TODO: switch from protocol to push_warning here. The main reason we didn’t
it yet is parallel repair. Due to following trace:
mi_check_print_msg/push_warning/sql_alloc/my_pthread_getspecific_ptr.

Also we likely need to lock mutex here (in both cases with protocol and
push_warning).
*/
protocol->prepare_for_resend();
protocol->store(name, length, system_charset_info);
protocol->store(param->op_name, system_charset_info);
protocol->store(msg_type, system_charset_info);
protocol->store(msgbuf, msg_length, system_charset_info);
if (protocol->write())
sql_print_error(”Failed on my_net_write, writing to stderr instead: %s\n”,
msgbuf);
return;

Hopefully this will serve as a good TODO list to go and fix at some point.

Breadboard BI provides affordable business intelligence (BI), data integration, and general software application development consulting. We also offer a suite of customizable BI modules that form a modular and scalable enterprise solution. Our mission is to provide products and service that enable companies to reduce costs, improve sales, and satisfy regulatory requirements.

Big Fish Games, Inc. develops, publishes, and distributes casual games through its website at http://bigfishgames.com. It offers downloadable games for PC/Mac; and online games, including puzzle, card, and word games. The company was founded in 2002 and is based in Seattle, Washington.