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.
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.
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.
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
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.
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 "
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.
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).
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.
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:
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
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.
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