Lately, I've been trying to keep up with at least one of the MySQL Forums: Partitioning.It's a great way to keep on top of issues surrounding partitioning, and also get an idea of what people are trying to do with the new 5.1 feature. Richard came up with an interesting problem that I jumped into only to realize that I hadn't done my homework, and my initial suggestion wouldn't work at all due

Do you want to use MySQL cartoons in your blog posts?
Feel free to borrow the images from this MySQL Forge wiki page.
Rules of the game:

• You should only use these cartoons to illustrate an appropriate MySQL subject (Summer of code, conference, Forge, Using MySQL with the Lamp stack, and so on);
• They are only for blogging. If you need these cartoons for other usage, or if you need different sizes, we are flexible. Please contact us at community - AT - mysql - DOT - com.

Last November, I became an employee of MySQL Inc, which was owned by MySQB AB.

A few weeks ago, MySQL AB and MySQL Inc etc et al became wholly owned by Sun Microsystems, which immediately started rapidly digesting this new corporate M&A meal.

As of today, I am now an employee of Sun Microsystems.

For the most part, for the time being, nothing changes. I do the same kind of work, have the same lovely workplace (an array of local cafes), and the same annoying business travel. (And the same expense reporting "system". Ugh!)

We shall see what does change, next.

But for now, when someone asks me what my job is, my short answer will remain "I work on MySQL".

Ivan Sagalaev has created a mysql_cluster database backend for Django, which allows you to configure master and slave servers, and then specify which should be used on given view with Python decorators. Found via del.icio.us and Simon Willison's blog.

As Giuseppe and Kaj have blogged about, the student proposal period for the Google Summer of Code is underway from today through March 31st.

The new MySQL Forge has a wiki page with suggested MySQL-related GSoC projects that a number of MySQL engineers and community team members have proposed. The projects include C/C++ projects in the MySQL server as well as other projects for the non C gurus among you, including some projects in Lua for the MySQL Proxy.

PHP Hacker? Know MySQL? Hack on the …

Three small per session tips in improving the speed of loading into Innodb Tables (assuming you already have a correctly configured Innodb environment)

SET FOREIGN_KEY_CHECKS=0;
SET AUTOCOMMIT  = 0;
SET UNIQUE_KEYS = 0; # if you know your data is clean.

I wanted to follow up my earlier post My Ideas for MySQL Camp III with some of motivations. Luckily, good friend and colleague Jeremy literally took all of 15 mins to respond to my post with “So, I see your vision for the event itself. What?s your vision for the results of the event?” (Unfortunately with 150+ draft posts, it’s taken some time to complete my reply).

The present differentiation of MySQL Community and MySQL Enterprise in my eyes is a joke. Now before I start or re-start more then already one flame war let me first talk about MySQL Enterprise. MySQL Enterprise is a great and necessary product offering by MySQL Inc. It serves essential services to essential customers with features such as commercial 24×7 support, MySQL Enterprise Monitor which is an excellent start when clients have nothing (and boy …

The answers to the last pop quiz are up: http://www.pythian.com/blogs/868/pop-quiz-mysql-cluster

So here’s another pop quiz. Given the following:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16450949 to server version: 4.1.14-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select count(*),length(password) from mysql.user group by length(password);
+----------+------------------+
| count(*) | length(password) |
+----------+------------------+
|       49 |               16 |
|       31 |               41 |
+----------+------------------+
2 rows in set (0.00 sec)

mysql> select password('foo');
+-------------------------------------------+
| password('foo')                           |
+-------------------------------------------+
| *F3A2A51A9B0F2BE2468926B4132313728C250DBF | …

I've just finished reading two recent blog posts about new query optimizations in the upcoming MySQL 6.0, it's all fine and dandy but ...Looking at Correlated semi-join subqueries and PostgreSQL by S. Petrunia we can read something like Quote: The first thing we did was to take a look at PostgreSQL as it is easily available and seems to have at least decent subquery handling (or even better

Some caveats for students willing to try their hand at any Summer Of Code project:

• Please state your programming skills clearly. Don't inflate your previous …