Pythian DBA’s have daily reports for each monitored database and some of the components are using charts to visualize the data. I’m a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You’d be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.
I apologize for off-topic on this blog but I think it’s important…Victoria experienced unprecedented bushfire this month taking lives of almost 180 (the list is growing) people and leaving thousands without homes. This disaster left tears on everyone’s faces even outside of Australia. If you would like to show the compassion and provide some help there are few ways. One of them is to contribute to the Red Cross Bushfire Appeal 2009. You don’t have to be in Australia to do that — you just need to have a big heart and few bucks to share.
In Part 1 of this series, we prepared our Windows Server 2008 servers to be a part of a cluster. In this part, we will look at adding the iSCSI disks to the servers. The series of steps outlined below should be done on both nodes.
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.
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.
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.
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.
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.
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…
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.