DBA Lounge

MySQL Query Analyzer Review

I had the chance to review the new Query Analyzer program from Sun over the last few days. I am very interested in how it performs as I have previously not had a chance to see the program in action (or the Enterprise Monitor program either for that matter). So, before getting into what the Query Analyzer can (and cannot) do let’s look at what Sun says it does.

Building a Windows Server 2008 Cluster, Part 1

This happens to be my very first blog post with Pythian, and to kick this thing off, I would like to talk about building a Windows Server 2008 cluster. The goal of this series of posts is to be able to help DBAs who may be charged with installing SQL Server on a Windows Server 2008 cluster. The best approach is to always have an environment on which to run these tests. In my case, I run VMware Workstation 6.5 on my Windows XP laptop. Here are the steps that you need to take.

Apparent vs. actual data integrity

I realized tonight exactly why MySQL’s default behavior of silent truncation bothers me. It reminds me of people who use a ticketing system and close every ticket as soon as they are done working on the issue instead of actually asking the other party if they are satisfied, because closing more tickets make it look like they’re doing more work.

Remote connections without leaving the mysql shell

You probably know that mysql -h host_or_ip can connect you to a remote host. But did you know that you can change the host you are connected to from within mysql? The undocumented (as far as I can tell, in the MySQL manual and in the “help” on the mysql command line) CONNECT statement can help.

Pop Quiz – Index length

A quiz, in 4 parts: Given the following table definition in the sakila database…Please prove your answers with examples. I’ll start off in the first comment with getting you part of the way there, so you can see what a “answer” with an example looks like.

Overloading BINARY

The term “binary” in MySQL has many different meanings. How many can you come up with? I have 6, but I am willing to believe there are more! Here they are…

Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex

Hello, there! With another Ubuntu release, it has come the time to update our series of posts on how to install Oracle 11g on Ubuntu. In this post, we’ll see the steps needed to install Oracle 11gR1 on an Ubuntu 8.10 Intrepid Ibex box all the way to creating your very first database. I’ve been working very hard to ensure that at every new post, the results you get when executing this procedure are as deterministic as possible, leading to a successful setup.

Performance Tuning: HugePages in Linux

Recently we quickly and efficiently resolved a major performance issue with one of our clients related to a central database that was intermittently freezing because of high CPU usage. In this blog, I will discuss this performance issue and its solution.

Page 41 of 67« First Page...10...3940414243...50...Last Page »