MySQL show status: How to show open database connections

MySQL "show status" FAQ: Can you demonstrate how to use the MySQL show status command to show MySQL variables and status information, such as the number of open MySQL connections?

I don't have a whole lot of time today to give this a detailed discussion, but here is a quick look at some MySQL work that I did recently to show MySQL open database connections.

git status message - Your branch is ahead of origin/master by X commits

git status FAQ: When I issue the "git status" command, I see the following "Your branch is ahead or origin/master ..." git message:

# On branch master
# Your branch is ahead of 'origin/master' by 5 commits.
nothing to commit (working directory clean)

What does this "Your branch is ahead of 'origin/master' by X commits" message mean? I keep committing my changes with "git commit", so this message seems to be in error.

When is Dropbox syncing? The icons tell

Dropbox syncing FAQ: How do I know when Dropbox is syncing my files?

On a Mac, you can tell when Dropbox is syncing your files by looking at the Dropbox icon in your Mac menu bar. When Dropbox is not syncing your files the icon will have a little check mark on it, like this blown-up image:

Git shortcuts/aliases - How to create

Git shortcuts FAQ: Can I create Git shortcuts (aliases) so I don't have to type out full Git commands like "git commit..."?

I've been reading the Pro Git book a lot lately, and the short answer is yes, you can create Git shortcuts so you don't have to type out the long Git commands. Here are several Git shortcut commands (referred to as "git aliases") from the Pro Git book:

Mac mouse and keyboard battery levels (How to check)

Mac mouse/keyboard battery FAQ: How can I check the battery level of my Mac mouse or Mac keyboard?

The easiest way I know to see the Mac keyboard/mouse battery level is to put the Bluetooth menu on your Mac menu bar, and check it from there. This menu will be in the upper-right corner of the Mac menu bar, and it looks like three small dashes with some other figure behind those dashes. (This is something like the normal Bluetooth icon, but a little different.)

A Java class that lists constants for all FTP server return codes

Here's a Java class that I created today that creates constants for all the FTP server return codes listed on this Wikipedia page. If you ever start doing programming against a real FTP server, or perhaps a mock FTP server, you'll know what these FTP return codes are needed for.

Without any further delay, here's the Java source code for a class I've named FtpServerReturnCodes:

svn status - how to get svn status information

After you've made a few changes in your local SVN sandbox it can be helpful to check the SVN status to see what you've changed, or at least see what SVN thinks you've changed. To do this, just issue the svn status command to see the changes, like this:

svn status

In my case this "svn status" command returned the following information:

A      build.alspc
A      antAlsPC.bat
M      build.xml