In what situation will this succeed:

ALTER TABLE t1 RENAME t2;

but this fail:

RENAME TABLE t1 TO t2;

?

Highlight the white text below for the answer:

When t1 is a temporary table.

Wow… I wonder why that is, I can’t think of any good reason…

Finding free quality wallpaper is hard and its even harder to find quality wallpaper for Christmas. Here is a couple sources I came across with a pretty good selection. If you have any suggestions of other sources for the holiday season drop a comment.

Source: CSSBuilt - 29 Beautiful Christmas Wallpapers
Source: CSS Count - 30 List of Stunning Christmas Wallpapers

Well… there’s:

• database
• table name

(both of these are quite obvious).

But then you have:

• temporary tables

Well… two types of temporary tables:

• those created in the course of query execution, typically in /tmp/
• those created during ALTER TABLE, typically in the database directory

You may have seen these “#sql-foo.frm” etc files around.

but you can also CREATE TABLE `#sql-foo` (you know, because that’s a good string to use in your app). In fact, you can (and shouldn’t) create a table with the exact same name as the temporary #sql table and use it in your app.

So really the primary key for a table is: string database name, string table name, bool is_tmp. Oh, and the /tmp/ temporary tables just to screw with your braiiiinn.

In drizzle, this is what the storage engine API is …

GlassFish and MySQL student contest winners are announced!

Kolli Bharath from Dhirubhai Ambani Institute of Information and Communication Technology, India (review, project) and Tomas Augusto Muller, Universidade de Santa Cruz do Sul, Brazil (review, …

Wikipedia is one of the world's most visited web sites (8th in the top 10, in fact), delivering an enormous breadth of content to an audience as vast as the internet.

But Wikipedia's evolved to become more than an on-line encyclopedia: they've become one of the world's largest search engines, they're a global source of real-time news, alongisde educational, political and health related content - and one of the world's most valuable brands and media properties.

Wikipedia's also a great example of a "redshift" application: a segment of the market that's growing faster than the technology industry's capacity to innovate. Technology companies have to pay special attention to such …

It’s the FRM file format version number.

It’s not the version of the table as one might expect (i.e. after CREATE it’s 1. Then, if you ALTER, it’s 2. Alter again 3 etc).

In Drizzle, we now return 0.

In future, I plan that Drizzle will allow the engine to say what version it is (where 0 is “dunno”).

This’ll be a good step towards being able to cope with multiple versions of a table in use at once (and making sense of this to the user).

One of the new features in the new release of MySQL Enterprise Monitor is Query Analyzer. As the name suggests, the Query Analyzer provides information about the queries that are running on your server, the response times and row and byte statistics. The information provided is great, and it doesn’t take very long to see from the query data supplied that there are places where you could improve the the query, or even reduce the number of queries that you submit.

The system works by using the functionality of the MySQL Proxy to monitor the queries being executed and then provide that information up to the MySQL Enterprise Service Manager so that the information can be displayed within the Query Analyzer page. To get the queries monitored, you have to send the queries through the agent which both monitors their execution and sends the information on up to the Manager, along with all the other data being monitored.

The team, …

As I mentioned earlier this week, I did a presentation on MySQL in OpenSolaris today.

The presentation (audio and slides) is now viewable online (and downloadable), and you can also get hold of the transcript of the questions: here (or download). The original presentation is here.

One minor difference from the presentation is that we …

I rarely use MySQL Fulltext indexes. Their performance is just not good enough, so often its better to just stick with "LIKE" or move to something else like Sphinx, Lucene etc. The only nice thing about them is the ability to compute a match "rank". Well anyways I had to write a new search plugin for a project that is based around MySQL Fulltext indexes and a match rank and all as well .. except that for some reasons some words just would not produce any results. As I was trying to find a pattern I finally noticed that in my test data some words were used in most rows and exactly those were not matching. Obviously it makes sense to exclude automatically any words that have a very high hit ratio. And indeed the documentation states that by default …

As consumer spending slows across the world, a variety of "brick and mortar" retailers are clearly feeling the impact. Foot traffic is slowing, and it's getting harder to balance debt laden real estate portfolios and fickle consumer trends.

For consumer product manufacturers, retail distribution is key - it's how you get in front of a customer. It's why the big PC manufacturers are all working hard to score deals with big retailers (or build their own retail outlets) around the world.

But making money on PC's is tough - for most PC makers, you're remarketing someone else's operating system and someone else's microprocessor - it's not for the faint of heart (or faint of balance sheet). For Sun, our retail distribution concerns don't surround consumer hardware (we don't make PC's) as much as consumer software - the popularity of which defines our market opportunity. …