Linux

Extending vmplot

Taking the work already done with vmplot.sh, a useful tool for MySQL performance tuning by Yves and Matt at BigDBAHead, and in true Open Source fashion I’ve enhanced and modified for my own purposes.

Read more

Your Code, Your Community, Your Cloud… Project Kenai

Following the opening keynote announcement about Kenai I ventured into a talk on Project Kenai . With today’s economy, the drive is towards efficiency is certainly a key consideration, it was quoted that dedicated hosting servers only run at 30% efficiency.

Read more

Beginner CSV Engine issues

I’ve just started using the CSV engine for a practical application and I’ve come across a few subtle and unexpected issues/limitations. First, you can’t create any columns in your CSV table nullable.

Read more

Identifying Bad Memory

I was having problems recently with a dedicated production server, that runs my MySQL Server and a number of websites. It’s most annoying when your system crashes without any reporting in /var/log/messages

Read more

Are you monitoring RSS & VSZ?

Monitoring MySQL Memory is a rather critical task because you can’t limit MySQL’s usage of physical memory resources. Improperly configured servers running MySQL can crash because you don’t understand memory usage.

Read more

Watching a slave catchup

This neat one line command can be of interest when you are rebuilding a MySQL slave and replication is currently catching up. $ watch --interval=1 --differences 'mysql -uuser -ppassword -e "

Read more

Reducing the MySQL 5.1.30 disk footprint

The current size of a MySQL 5.1.30 installation is around 420M. $ du -sh . 426M . A further breakdown. $ du -sh * 213M bin 20K COPYING 9.8M docs 8.

Read more

Dependency error installing mylvmbackup on Ubuntu 8.04

I’ve started an investigation of MySQL Backups using LVM . I’m working with Lenz’s mylvmbackup but I found it both used Perl and needed a number of dependencies installed. Installing dependencies failed on my test system, yet I found it actually worked when I went back to my dev system (but it is not configured with LVM for full testing).

Read more

Some MySQL pairs terminology

In response to a number of comments, I thought I would clarify the scope of my discussion regarding Options using MySQL pairs before I begin. As mentioned their is no one way or type of configuration for MySQL in a HA solution, however the simplest progression from a single Master/Slave environment is the concept of a pair of servers, configured to support a fail over and fail back via MySQL Replication.

Read more

VirtualBox, compiling Part 2

So I managed to find all dependencies after some trial and error for compiling VirtualBox 1.6.4 under Ubuntu 8.0.4, then finding the Linux build instructions to confirm. It was not successful however in building, throwing the following error:

Read more

apt & dpkg Reference

I found a good reference page for Debian package management commands apt-??? and dpkg. Check out http://diablo.ucsc.edu/~wgscott/debian/apt-dpkg-ref.html

Read more

Installing Skype

A fresh install of my laptop with Ubuntu 7.10 after stuff just didn’t work causes pains sometimes of the installed programs. Skype being one of them. Goto Skype for Linux and get the Ubuntu installer.

Read more

Ubuntu Tricks today

ctrl-alt-l – Lock Screen ctrl-alt-d – Desktop # Multi Cut-Paste History apt-get install glipper Add to System|Preferences|Sessions|Startup Programs Thanks Yves

Read more