The latest from the MySQL community

I've just been informed that a PDF of my slides as well as a recording of yesterday's webinar about MySQL Backup and Security (in German) is already available for replay/review. You can access the files from our on demand webinars page (free registration required). Enjoy!

In code just tested:

ndb_mgm> ndbinfo MEMUSAGE
RESOURCE_NAME    NODE_ID    PAGE_SIZE_KB    PAGES_USED    PAGES_TOTAL    BLOCK
IndexMemory,1,8192,16,160,DBACC
DataMemory,1,32768,20,640,DBTUP
IndexMemory,2,8192,16,160,DBACC
DataMemory,2,32768,20,640,DBTUP

Win!

This is the first time that we’ve been able to get this kind of info out of the cluster without using the magic “all dump 1000″ (or “all report MemUsage”) which end up using events, which go to the log file, aren’t exactly reliable etc.

This performs a scan on the NDBINFO tables (in ndbd) from ndb_mgmd and returns the result to the management client. You can then use this in scripts from the command line. e.g. to find out how many pages of datamemory are used on each node:

$ ./storage/ndb/src/mgmclient/ndb_mgm -c localhost:9311 …

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

One of the potential favourites for EURO 2008 was always going to be eliminated from the group stages given France, Italy and The Netherlands were all drawn in Group C and it was France that made an early exit following a 2-0 defeat to the Italians last night.

France must also be considered one of the favourites to be crowned EURO 2008 Open Source champion given the number of open source-related policies, projects …

Well, neither did I until today. HA!

Velocity is a new O'Reilly conference dedicated to "Optimizing Web Performance and Scalability".  It starts next Monday.  Yesterday I was contacted by Adam Jacobs of HJK Solutions about taking part in a panel discussion about what happens when success comes suddenly to a web site.  I think he thought I was in the bay area.  Little did he know I am in Alabama.  But, amazingly, I was able to work it all out so I can be there.  I wish I had known about this conference ahead of time.  It sounds really awesome.  Performance has always been something I focus on.  I hope to share some and learn …

The Red Hat Summit started today here in Boston. Based on the evening reception today, it is shaping up to be a pretty good show. I will be speaking at the show on Thursday, June 19, 2008 at 11:30 AM eastern time. I will discuss current state of open source backup as well as where things are headed. We also have a booth located towards the right side of the exhibit floor (by small meeting rooms). We are demonstrating Amanda as well as ZRM for MySQL. Do stop by if you are coming to the show!
adobe cs2 download photo shop Download Adobe Acrobat 7 MAC
oem software adobe
After Effects 6.0 software …

Its the Firefox Download Day. That not only means Firefox 3 is out, it also means that they’re trying to set a world record, by getting the most downloads of a software package in 24-hours. There’s a nice world map, similar to the kind you might have seen in presentations by Jonathan Schwartz (ok, I prefer seeing the dots per region, rather than the Firefox one :P).

The pending general availability of MySQL 5.1 was announced in April at the MySQL Conference. While I’ve seen 1,400+ attendees (a pleasant problem for the event organisers, as they scurried to get people into overflow rooms, and herd the crowd during food times) show up at the Tech Days in the Philippines, I’m wondering if we can achieve 3 …

MySQL/Sun released a new storage engine "Falcon" in January, 2007. Falcon is a high performance transactional (fully compliant with ACID) storage engine, which is beta at this time (June 2008). In this article, I describe Falcon's features and its architecture in detail.

We often recommend to set lighttpd in front of apache to handle http requests (more about http://www.mysqlperformanceblog.com/2006/05/21/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic requests to apache and handle static files by itself. I just gathered step-by-step instruction how to do that in 10 minutes, as it may be not so obvious.

• Of course you need lighttpd by itself, it's available on http://www.lighttpd.net/download
• You may want pcre-devel packet, which allows to use regular expressions in lighttpd.conf. For CentOS boxes we just run yum install pcre-devel
• Take sample config file lighttpd-1.4.XX/doc/lighttpd.conf and put to /etc/lighttpd/lighttpd.conf
• Create directory to store log files, e.g. …

I acquired an Eee PC for my Phoebs. On special somewhere, unfortunately not a pink one ;-)
While I see that lots of people are replacing the Asus/Xandros OS with Ubuntu for Eee or other distros, I've decided to stick with the default for now. It's a very easy desktop to use, with all clutter, confusion and traps disabled but still accessible through other means. Traps you ask? Yea... traps. A three-year-old with a mouse is a dangerous mix ;-)

So, why have a computer for a 3 year old anyway, and why an Eee, and ....?
Phoebe is already quite aware that work generally involves using a computer, so she insists having one on her little play desk: "for work"; that's no reason to give her one though. Eee starts very quickly, being flash based and in its default simple desktop mode. Smurf gets easily bored so any regular machine just doesn't cut it (believe me I've tried).

But kids these days must to become …

Everybody knows than Nagios can be used as a service monitor to monitor things like Load Averages, MySQL Replication Status, RAID Array States, etc… Fewer know that there are plug-ins to monitor MySQL Performance Status, such as check_mysql_perf. Fewer still utilize Nagios’ built-in triggering mechanism to execute an additional script on the event of [...]