There are some tools we commonly use doing performance review and optimization and we often ask each other where that particular stuff is located on the web or what is exactly name of the command what does that.

Initially I thought creating internal Percona Wiki page, but thought there is no reason this information should not be public instead.

So now you can find our favorite MySQL Performance Review Tools on the site.

This is just list of tools which came from the top of my head and I'm sure it is far from complete. We will extend it and we would like to hear your suggestions on what else we should add to it.

In this list we focused on Open Source tools which are helpful for "in time" performance audit - for example you see no graphing software in this list or any commercial offerings. …

Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn't. Don't let it catch you off guard.

Do you really need to restrict MySQL users based on hostnames? If you don't, you should probably disable this feature of MySQL's authentication system. You never know when your hosting provider's DNS (or your own for that matter) will go into the toilet. And when that happens, MySQL mysteriously stops letting users log in, and all kinds of chaos ensues. Worse, it can be kind of hard to know that this is the problem, and diagnosing adds to your downtime.

Here's another scenario: DNS doesn't really fail. It just gets a little bit slow. Subtle enough that you don't really notice it, but enough to cause connection problems every now and then.

I've seen both scenarios recently when working with clients. Oh, and did I mention that not enabling skip_name_resolve actually leaves you open …

I think this is going to be really neat: you walk around the streets of San Francisco, for example, with your Android powered phone, en route to your destination 20 blocks away.

You whip out your phone, go to Google Maps, pull up the StreetView (remember this?), which zeroes in on your location using a built-in GPS, and then changes as you move the phone around using the built-in compass.

You then virtually walk the city, looking around, without actually moving an inch (looking for the closest ATM, restaurant, etc, hint-hint?).

Without further ado, let's have a look at this video from Google's I/O Conference for a demonstration?

    This video …

Today, I knocked out a couple feature requests for MySQL Forge that Giuseppe had submitted. Namely, the ability to add an avatar image to a person's profile, and also restoring the "traditional" links in the wiki top-navigation for editing, moving, deleting, watching, etc the wiki page (if you are logged in, of course).

For the avatar images, I used a web service from the Gravatar website. It's super-easy to setup. Simply grab an account on Gravatar.com for the email address you use to login to the Forge, upload your avatar image, and voilá, your avatar will be displayed on your profile page …

For all you dolphins and elePHPants out there, please take a look at MySQL Magazine's community survey, graciously produced by Mark Schoonover and B. Keith Murphy. Why bother taking the survey? Well, that's simple. It gives us insight into what you think about MySQL, what languages and platforms you use most often, and what you think about current release schedules/policies and other things. In short, you're helping to make our community better!

Please spend five minutes to take this short survey. Thanks!

Last week there there was a short scheduled downtime for the system, and I've used the chance to upgrade the MySQL servers to a newer version. We've tested it for more than a month before deploying to production, so I wasn't worried about any potential problems.

The upgrade itself went smoothly and was complete in about less than 10 minutes. Speaking of which, this is one of the things I like in MySQL upgrades as opposed to SQL Server.

1. Copy new version
2. Shut down the server
3. Rename directories
4. Start server
5. Run mysql_upgrade
6. Restart server

All of the above usually takes about 2 minutes, and can be reverted quite easily, if you have backup for the data files. This is compared to a SQL Server upgrade, or even a Service Pack install which includes running an installer for what can be 20 minutes or more. Uninstalling is equality lengthy, though both …

Hi,

Few days back, I had blogged about “Tryst with MySQL“. Today, I shall move ahead and give an insight on database management with MySQL using NetBeans.

Its meant for Windows user only, rest can follow too, though just for the content and may try exploring these steps for their OS as well.

MySQL Tools -

Apart from being a popular open source database. It also has some amazing tools, which have been formed, due to years of users invaluable feedback, on their forums. Here’s what the website describes about MySQL Administrator;

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your …

We've sailed past 200 responses! Thanks to all those community members that have taken the time to survey. That leaves us 800 responses to go. Please spread the word far and wide to make this the most comprehensive MySQL community survey.

I blogged in an earlier post that the survey was going to be offline for system upgrades. At the time of this post, it's up and running.

Have you surveyed?MySQL DBA & Programming Blog by Mark Schoonover

We've sailed past 200 responses! Thanks to all those community members that have taken the time to survey. That leaves us 800 responses to go. Please spread the word far and wide to make this the most comprehensive MySQL community survey.

I blogged in an earlier post that the survey was going to be offline for system upgrades. At the time of this post, it's up and running.

Have you surveyed?MySQL DBA & Programming Blog by Mark Schoonover

Yesterday, during the talk of Ivan Zoratti, at the meeting with Marten Mickos and the Italian Team of SUN | MySQL in Rome, there was a question about Falcon performance: a guy pointed out that InnoDB is better than Falcon.

Well, this is not really the truth.

How many processors are you using for Falcon benchmarking?

Falcon is designed to make optimal use of modern large-memory multi-CPU/multi-core hardware. So when comparing performance of Falcon and InnoDB, you can’t leave this out of consideration!

Please, see the shoots below: