Mickael Marchand noticed a problem with the mysql-dfsg backport on amd64. I don't own such hardware, but fortunately Christian Hammers was able to reproduce that problem, which seems not to be Debian related, so he filed a bugreport to the MySQL bug tracking system.

Readers of PlanetMySQL may have recently noticed some posts on tuning MySQL server performance in five minutes or even in three minutes, I’d like to take things in the opposite direction, showing you how to tune performance in two to four days.

Actually I should say you can learn to tune performance in two to four days, tuning itself actually takes a long time and is a continuing process because things change constantly. I’m not talking about performance tuning in the ‘limit resource usage so the server does not crash’ sense that you see in limiting connections, but in the sense of getting the most from your server, making specific changes and measuring the results. Remember folks, if you don’t benchmark you have no idea if your changes have improved your situation or actually made it worse. Do you want to know if your server can handle a traffic spike? Better to simulate one ahead of time than find out the hard way.

So …

I could have internet access if I wanted to right now. All I would
need to do is go up to the wireless icon on my Mac, select the
airplane's wireless network, and fork over some cash. Presto, I am
surfing the web.

The point of this is lost on me since all I currently have is just
two batteries. I could be hacking MySQL right about now, aka ssh'ing
into my cluster and firing up builds but all I have is two batteries.
There are four boxes just a simple ssh away which could be spinning
up their disks right now solving problems for me.

That is unless I go recharge my laptop off the outlet in the bathroom.

Don't knock the bathroom on a plane. I'm not the only person out
there that has discovered this, and its not like this is the first
flight this has come to mind (I believe I was first inspired on a
flight to New York about six years …

Arjen, I am now registered for the MySQL user's conference. See you there.

Tags for this post: mysql()

Comment

The first Hamburg MySQL User Group meeting was held yesterday evening. It took place at 19:00 in a chinese restaurant named Ni Hao - they had a separate room for us that also provided a video projector. The location was suggested by Jens Bollmann, thanks a lot for the hint! We had a pretty good lineup from the MySQL side: Jens Bollmann (Consulting), Jan Kneschke (MySQL Network Development), Kai Voigt (Training/Consulting), Ulf Wendel (MaxDB) and myself (Community) were present. We had a total of 35 people attending.

I started the meeting with introducing myself and the community relations team and giving a short presentation about MySQL (the company - some facts and figures). I then asked everbody to shortly introduce himself to the …

We’re busy expanding the MySQL certification program to include more MySQL products, managing translations, updating our exams to match the evolving features of the existing products, and much more. There is much work to do, but too few heads and hands to put to the task of doing all this!

So that’s why we’re looking for a technical writer to help us develop and update our exams. What we’re looking for is a person who has the right combination of excellent written English-language skills, careful attention to details, and of course good working knowledge of MySQL. If you have experience working with training materials or testing, all the better!

And the best part of it all: You get to work from home! No need to throw yourself at the mercy of the morning and evening rush-hours, no irritating radio in the next cubicle.

The downside is, of course, that you’ll need to refill the coffee maker yourself.

For …

January saw the advent of the new MySQL 5.0 Developer exams, and now the MySQL 5.0 DBA exams are available, too. Exams for both of these MySQL 5.0 certifications are currently offered at “Beta” exams. That an exam is in Beta basically means that

• There are more questions to answer
• You have more time to answer questions (both overall exam time as well as time-per-question and overall exam time)
• If you’re quick, heavy discounts are available
• You do not receive immediate feedback on your score, but must many weeks before you know if you have passed or failed.

A more detailed explanation of Beta exams is available on http://www.mysql.com/certification/beta.html

Discounts on MySQL 5.0 Beta Exams

The quick movers among you can get Beta exams at half the price! It’s easy, …

Florian Müller has started his own blog. His new website no-lobbyists-as-such.com promotes his book on the EU fight against Software Patents in 2004 and 2005. As part of it, he has also started a blog, well worth following.

I’ve previously stated that I am glad to see good books on advanced MySQL usage appearing such as Pro MySQL, High Performance MySQL and the like. Well, now there is a book that makes be glad to see good books for beginners: MySQL Crash Course by Ben Forta.

While experienced MySQL users should steer clear of this book, MySQL Crash Course is an excellent book for the beginner. It starts right from the basics, talking about what a database is, what SQL is, what MySQL is, then hits the ground running talking about constructing queries, sorting, using functions, etc.

The book has a good, …

Brisbane MySQL UG meeting tonight. We'll have both a "fundamentals" and "advanced" talk, to cater for the interests of more members.
I'm don't do many talks these days, as there are also quite a few other UG members with excellent stuff to tell. But tonight I'll present the fundamentals one, about MySQL User Management. The GRANT and REVOKE statements and other related stuff.
Mind you, we purposely didn't call it "beginner" talks, since they're really not; sure they're useful for beginners, but many experienced users can also benefit as there's always some aspect discussed that they just haven't encountered in their work. "Filling in the gaps".