Hi all,

As I mentioned in a previous blog entry, big changes are underway to the database connection connection node in NetBeans 7.0. If you look at the image above, you'll see what I mean. In the connection that is highlighted, no schema was selected when the connection was made, thus "default" is displayed as the schema.

When the schema is default, all schemas are displayed under the connection node when it is expanded. When you expand the schema, you'll see a familiar sight: the Tables, Views, and Procedures folders.

Individual database connections are also displayed as separate nodes below, even with default schemas.

Be sure to stay tuned for changes.

Happy Holidays!

--James

Can you use TRIGGERs to increase performance? Really? Isn't so that a TRIGGER on a table will reduce performance, just as any FOREIGN KEYs will? Right?

Nope, none of those statements is necessarily very true. In the case of reads, for example, neither TRIGGERs, nor FOREIGN KEYs has any negative impact at all. Then, assuming we have a read-intensive system, such as some website, then performance isn't much of an argument for not using triggers or foreign keys.

You already know I'm quite a fan of foreign keys. Let me reiterate why I like them: They keep my data integrity intact, that's why. The argument that if I have transactions, then the only thing that might cause data integrity to fail is if there is a bug in the application. There are two things I have to say against that:

• 
  
• Many, if not most, users use more than one application. For example, if nothing else, the mysql …

I’ve been thinking about the business of what’s variously come to be called commercial open-source and enterprise open-source. I’m interested in the gestalt — the product, development processes, marketing, licensing and so on.

MySQL has tried many different ways to earn money. These include dual licensing, support subscriptions, a knowledgebase, consulting, an Enterprise/Community split, [...]

Our Mac Developers have done an outstanding job in catching up with the Mac frontend. We have worked hard in the last days to get a little Christmas present out for all people waiting for a Mac Version of our Database Tool.
It’s a 1st alpha version, so don’t expect a full blown design application already - and the binary is Intel only this time (hey, it’s only Christmas folks ;).  But what we deliver is a working UI where you can load/save existing Workbench-documents and create diagrams from imported SQL-scripts. The canvas and the GRT system is up and running and there’s a shell which enables messing with the objects on GRT level. There are no object editors yet (so you can’t create and edit objects, but still build your diagrams for your existing SQL CREATE scripts) and wizards for exporting scripts, and connecting to databases are also missing. But enough writing, grab the .dmg package from our server and give it a try to get …

As you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our patchset.
Patches are mostly equal to build 10
http://www.mysqlperformanceblog.com/2008/12/11/mysql-binaries-percona-build10/, only change:
it includes bugfix for https://bugs.launchpad.net/percona-patches/+bug/308849

You can download binaries (RPMS x86_64) and sources with patches here
http://www.percona.com/mysql/5.0.75-b11/

Entry posted by Vadim | 7 comments

Add to: …

This is the 1st post in my MoFo Futures 2009 blog series. | Post 2 »

Christmas is nearly upon the Christian and Consumerist parts of the globe. Along much of my latitude, snow is piling up in record quantities and weather warnings abound. Even in oft-green Vancouver, there is a foot or so of the white stuff accumulated in my yard and the parking lot outside my window often echos with the sounds of snow-beached cars helplessly spinning their wheels.

Usually all these things taken together would mean a series of harrowing drives to visit family, followed by lovely hours staying warm indoors, eating comfort food, retelling old stories and enjoying the company of loved ones as the year draws to its close.

However, this year our family time is coming after the holidays and I'm left with the unexpected gift of a week or so of free time.

…

I hate looking for this….

This will give you a rough idea of your innodb memory usage. I know it’s in a hundred spots, but i hate looking for it when i double check things.

innodb_buffer_pool_size
+ key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size +2MB)

lsof works under linux and MacOS X and will help you figure out what files are open.

lsof | grep ‘mysqld’

I spent the last month taking a break from Open Source, partly due to FreeBSD 7.1 failing to hit the FTP servers as scheduled (any excuse), but mostly due to Santa’s early delivery of Ableton Live. Not really Open Source I may add but extremely cool nonetheless and a much needed break from coding!.

I find that staring too much at code can hamper the creative process (hehe), and as you know Creativity and Innovation go hand in hand with Open Source Software!.

Speaking of which, while I have been busy playing with waveforms and elastic audio, the Open Source world has been all guns blazing with cool releases like MySQL 5.1 GA, …

tl;dr: The MySQL community rocks. Percona, XtraDB, Drizzle, SSD storage, InnoDB IO scalability challenges.

For anyone who lives and dies by MySQL and InnoDB, things are finally starting to heat up and get interesting. I’ve been banging the “MySQL/InnoDB scales poorly” drums for years now, and despite having paid Enterprise licenses, I haven’t been able to get anywhere. I was pretty excited when Sun …