If you are coming to the MySQL User Conference, you might want to pop by the Computer History Muesum. The CHM is in Mountain View, jus off the 101. If you have a car, just take the 101 and get off at Shoreline, it's just on the east side of the 101. If you don't have a car, you can get there anyway, from the UC take the light railway to Mountain View and then you can walk (some 20 minutes or so, not the nicest of walks, across the 101, but it's possible, I've done it) or take a bus from Mountain View.

At the CMH, among other cool things, is Babbage's Difference Engine in working order, a mechanical computer. That Babbagewas a smart dude is obvious from the fact that he never finished building the machine, although he designed it, and when now built using his original designs, it actually worked! I mean, …

Percona will have 14 members of our team at next week's O'Reilly MySQL Conference in California. Drop by and meet us at booth 308 (for Percona) or 216 (for Maatkit). Bring your technical questions and problems to our experts. To make it easier for you to meet specific Perconians, check this Google calendar for when each consultant should be present at the booth. (Hint: use Agenda view.) We'll be talking at 23 sessions, tutorials, or BOFs. Check here if you want to see when Percona's speakers are scheduled to be on stage. We look forward to seeing our friends face to face each year in Santa Clara. Please introduce yourself and say hello!

Entry posted by TomBasil | …

Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ?
MySQL distribution has a great script called mysqlbug which was supposed to be used for bug submission. I never have seen anyone using it for this purpose but it is great in providing information about current built. Especially you may be looking at "Configure-Command":

PLAIN TEXT CODE:

1. Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-low-memory' '--with-comment=FreeBSD port: mysql-client-5.0.67_1' '--enable-thread-safe-client' '--with-charset=cp1251' …

Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index for a traditional MySQL storage engine would take too long to be of any practical value. With TokuDB, however, an index can be created on the fly to accelerate any ad hoc query that would otherwise be causing a vastly slower full table scan.

Here are the details.

We've just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, …

I think most developers are able to cache database queries by now. But what about DML queries? Every query, connection - or in the general case - ressource needs time. So I thought a lot about how to write data as efficiently as possible into the database - in my case MySQL. Hmm...We have to take a closer look at the details and we can't choose the same asynchronously writing method for every kind of query. With kind of query I mean that it depends on what storage engine we use, the complexity of the query, should more than one record be written at once, are triggers involved and so on. Sure, the one or the other query MUST be written instantly, but most of the writing querys are stackable with no need to check if the request has succeed.

Read the rest »

I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle its new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.

I think there is some finality to the changing of the guard this time, since there aren’t really that many companies that could conceivably swallow up Oracle itself! (Maybe I shouldn’t say that — next thing you know they’ll spin it off heh.) But regardless, I am looking forward to getting to know Edward Screven and getting a sense from the keynote and other communications exactly what he’s planning to … DO … with …

Brian Aker parted ways with the mainstream MySQL release, and with Sun Microsystems, when Sun was acquired by Oracle. These days, Aker is working on Drizzle, one of several MySQL offshoot projects. In time for next week's MySQL Conference & Expo, Aker discussed a number of topics with us, including Oracle's motivations for buying Sun and the rise of NoSQL.

The key to the Sun acquisition? Hardware:

Brian Aker: I have my opinions, and they're based on what I see happening in the market. IBM has been moving their P Series systems …

We will be demonstrating Entrance Community version in booth 525 at the MySQ User Conference in Santa Clara. Stop by the booth and be sure to mention 'everythingmysql'.
Entrance is a desktop application for drawing charts using data in MySQL databases. If you know a little SQL, browse the documentation page for our PLOT command: http://dbentrance.com/newdocs/en/plotsyntax.html. and I think you will get the idea: Any MySQL SELECT command becomes a chart when you add Entrance PLOT.
Community version is GPLed. We can get help you get set up to both run and build it if you bring a laptop to the booth. (We can also show you the "Animated Shower Curtain" demo made almost famous by the LA MySQL Meetup)
Tod Landis http://www.dbentrance.com/

While a scale-out solution has traditionally been popular for MySQL, it's interesting to see what room we now have to scale up - cheap memory, fast storage, better power efficiency.  There certainly are a lot of options now - I've been meeting about a customer/week using Fusion-IO cards.  One interesting choice I've seen people make however, is buying an SSD when they still have a lot of pages read/second - I would have preferred to buy memory instead, and use the storage device for writes.

Here's the benchmark I came up with to confirm if this is the case:

• Percona-XtraDB-9.1 release
• Sysbench OLTP workload with 80 million rows (about 18GB worth of data+indexes)
• XFS Filesystem mounted with nobarrier option.
• Tests run with:
  • RAID10 with BBU over 8 disks
  • Intel SSD X25-E 32GB
  • FusionIO 320GB MLC
…