You may have noticed the new link on dev.mysql.com to the MySQL GUI Tool Download.

This bundle includes new beta versions for MySQL Administrator, MySQL QueryBrowser, the MySQL MigrationToolkit and a new alpha version of MySQL Workbench. All these GUI products are supposed to be offered in one single package in the future.

To get all details, read Mike Zinner's Announcements in the forum:

http://forums.mysql.com/read.php?108,100559,100559#msg-100559
http://forums.mysql.com/read.php?108,100561,100561#msg-100561

Needless to say, Feedback and Bug Reports are very …

Sometime last night the crawler computed the keywords from last week. Same goal for stats as last week, take 250K of non-spam URLs for RSS and pull the contents for the week. Very error prone for aggregation sites, but ok for people who don't post enough to scroll their RSS feed. I am starting to factor out the aggregation sites and just pin point articles written by original authors.

The results:

Word: Linux: 4870
Word: PHP: 1971
Word: MySQL: 1099
Word: Perl: 992
Word: Apache: 940
Word: Ruby: 852
Word: APR: 800
Word: Python: 790
Word: Asterisk: 111

I have page refreshing results that I look at while the parsers are running. Python and Ruby play a game for a while of "who is first for the moment", with Ruby winning in the end. I am going to extend out the stats to flatten any cases of people "over using" any term, and I have some weighting …

SciBit has released update MyCon MySQL GUI v2.10 today. This is primarily a bugfix and existing feature enhancement update for v2.9.x. In short, it contains all the fixes which SciBit could already release without having our customers wait for the upcoming MyCon version 3.0 release:

* Add: Alt+C combination on any grid cell to NULL the column value of the record.
* Fix: Column Editing for MySQL >5.0.15.
* Fix: Queries now prompt before overwriting existing SQL queries

For more info on improvements made in earlier versions, see
v2.8.1
v2.8
…

I'm visiting with some of my young nieces and nephews today.  They're between the ages of 9 and 12 and they are all Habbo Hotel power users.  (Their parents thought it was "Hobbit Hotel" so I guess they are not power users!)  If you don't have young kids or nieces and nephews, you may not know it, but Habbo Hotel is virtual meeting place and game environment for teens.  They can buy, sell and trade furniture to create rooms in their hotel.  It's run by Sulake Corporation of Finland which is one of Europe's fastest growing technology companies.

Habbo Hotel runs on a LAMP stack using MySQL 5.0 with databases that range from hundreds of Gigabytes to Terabytes in size using a mixture of transactional  and non-transactional storage engines. They achieve performance levels of tens of thousands of events per second scaling out with dozens of multi-CPU …

All -

Just a quick note to let you know that a new beta release is available for all MySQL management tools (Query Browser, Administrator, Migration Toolkit, and Workbench, which is still alpha). You can download the new tools, which sport a single installer now for the entire management tools pack, here.

One great note of interest - for those wishing to migrate from Sybase to MySQL, the Migration Toolkit now has native support for moving between Sybase and MySQL! I tested it this morning and it works like a champ. Versions of Sybase supported are 12.x and higher. Those using 11.9.2 may be OK as well.

Let me know what you think!

If you have ever felt the need of measuring how much of your resources a MySQL process is eating up, you're welcome to share my experience on the subject, reading Measuring resources for a MySQL server on Linux, which also introduces mysqlresources, a new command line tool that gets your server's statitics from the operating system and prints a nice report.

With MySQL, it's easy to get statistics from the server itself, but sometimes you need a view from the outside. mysqlresources does just that. Read on.

The MySQL UG will have a meeting in Catro Pub next Thusday (11. July) @19.00. It will be pleasure for me to meet some MySQL fans from Denmark for a beer (or more).

The address is :
Nørrebrogade 209
2200 København N

Map?

MySQL { MySQLUG{
Denmark

Partha Dutta posted pretty interesting post about iSCSI vs SCSI performance using SysBench.

This is nice to finally see some iSCSI benchmarks done with MySQL - something we were planning to do for a while but never ended up doing, mainly due to lack of hardware available for tests. It is also good to see Sysbench being used, as It is developed by our team, even more I write first version of this tool myself, for performance research (The new version was complete rewrite).

The problem I see in this test however - the benchmark is not fully described which makes it hard to judge what they really mean. Was it OLTP test or some other combination ? Was default table size used (that one is pretty small and would typically keep load CPU bound)

The …

What is Wiki

A wiki (IPA: [?wi?.ki?] or [?w?.ki?] [1]) is a type of website that allows users to add, remove, or otherwise edit and change most content very quickly and easily, sometimes without the need for registration.

This ease of interaction and operation makes a wiki an effective tool for collaborative writing. More in Wikipedia

MySQL Wiki
After the WebTech conference I discovered the MySQL wiki. It is still on development phase, becouse there is not a lot of materials in there, but is pleasure for me to contribute

I make a new Category called MySQL events worldwide. If you have information about such events, …

Greg Lehey wrote today Is MySQL getting buggier?. The underlying question of his comments is a more fundamental and passionate topic, and especially for me. That is “Software Quality”.

The quintessential question is this. “How do you determine the ’software quality’ of a product?” And then quickly followed by, “How do you benchmark this with other software products?”

The short answer to second question is simple. You can’t. The reasons why become apparent in addressing the first question. (There’s a mathematical term for this two question situation, another one of the million things to research and remember one day).

15 years ago as part of my masters research I worked on “Improving Software Quality and Software Productivity”. At the time when I started, I found that these were generally considered …