This Thursday, Martin "MC" Brown will explain how to use memcached in MySQL deployments.

MC is the author of the memcached section of the MySQL Reference Manual, and does all other memcached documentation in the Sun Database Group, too.

This MySQL University session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). The virtual meeting room will open 15 minutes before the hour. Point your browser to this address.

Here's the updated MySQL University schedule for the rest of this …

I've always been intrigued by the FIRST_ROWS hint, so I paid special attention when we reached it in the 11g SQL Tuning class. But I'm still puzzled.The course notes said that although you shouldn't be using hints generally, when you do, FIRST_ROWS is the most useful of the hints (in the form FIRST_ROWS(n) where you specify how many rows to optimize for). Also that it's not effective when the

Taming MySQL is… challenging. Especially in very large, fast-growth, ‘always-on’ environments. It’s one of those things where you seemingly can never know all there is to know about it. That’s why I really like coming across posts like this one from FreshBooks that describes a very real problem that was affecting their users, how they dealt with it, why *that* failed, and what the final fix was. Post a link to your favorite MySQL Problem and Solution post in the comments (oh yeah, and “subscribe to comments” should be working now!)

I’m not someone who wakes up every day and looks at how my blog is ranked by all of the various services. I check out my WordPress stats, but that’s really about it. However, someone went and did some of the work for me, and they’ve decided that, of the blogs that they read or that were suggested to them, this blog ranks #20 in a listing of 25.

I’m really flattered, but wonder if it’s an indicator that this is a quality blog, or that they should aim higher in their blog reading ;-P  Either way, listing 25 bloggers in a flattering way is a fantastic marketing technique, because most of us are probably egomaniacal enough to say “Hey! Look!” and link back to the list on *your* blog, resulting in lots of traffic. Kudos, and thanks Mobile Maven!

<!-- http://4.bp.blogspot.com/_aUgNMQ2wQTE/SUs_eaEFKSI/AAAAAAAAAoQ/FUG8BLpXtF0/s1600-h/Speed_Highway.jpg -->I've just finished taking the (EM-based) Performance Tuning course and the SQL Tuning course. It's always a strange feeling taking a course where I already have hands-on experience, or I was around in the early days when standards were being hammered out. Sometimes that odd feeling (I know

This Thursday (November 6, 2008), Jay Pipes will guide you on a tour of Bazaar and Launchpad for beginners. Since Jay is located in Columbus, Ohio, this session will start later than usual, that is, at 17:00 UTC / 9:00am PDT / 12:00 EST / 17:00 BST / 18:00 CET.

Getting to know Bazaar and Launchpad is certainly interesting for most developers, but it's a "must-know" for anyone thinking of contributing code to MySQL, since MySQL development has been using Bazaar and Launchpad for quite a while now.

While I'm at it: 

On the eve of the Berlin Marathon a few weeks ago, I saw Santa Claus on skates, which reminded me …

Yesterday I was going through the locks related code; and found that in 5.0; when you have a global read lock; then the SHOW TABLE STATUS actually gets blocked when it had its own read lock on the new session; and this is not the case with MySQL 5.1

For example; lets execute the following set of statements in two sessions with MySQL 5.0 (latest bazaar version with InnoDB enabled):

Session 1:

mysql> use test;
Database changed
mysql> drop table if exists t1;
Query OK, 0 rows affected (0.07 sec)
 
mysql> create table test.t1(c1 int)Engine=InnoDB;
Query OK, 0 rows affected (0.00 sec)
 
mysql> flush tables with read lock;
Query OK, 0 rows affected (0.00 sec)

Session 2:

mysql> use test
Database changed
mysql> lock table t1 read;
Query OK, 0 rows affected (0.01 sec)
 
mysql> show …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …