Blog
Data Modelling
I’m a data modeller. I specialise in this, and for a number of years on large projects I’ve been able to focus on this single task within the System Development Life Cycle of software development for several months at a time.
Read moreFormat new Linux Disk
fdisk /dev/hdb mkfs.ext3 /dev/hdb1 mkdir /u03 mount -t ext3 /dev/hdb1 /u03 ls /u03 umount /u03 vi /etc/fstab mount /u03
Read moreContributing to JMeter
As part of my using JMeter for the purpose of testing a new Transactional storage engine PBXT for MySQL, I’ve been investigating the best approach for handling transactions. Read more about earlier decisions at my earlier post Testing a new MySQL Transactional Storage Engine .
Read moreWithdrawl symptoms
I’ve recently started a new contract position, and the combination of more restrictive working hours, and at least 1 hour travel each way each day, has lead to me not being about to write like I have of late.
Read moreEmulating Oracle Output Functionality
Updated 28-mar-2006 There really is no way to do a comparision by numbers in features and functionality when it comes to Oracle and MySQL in the area of Stored Procedures and Triggers.
Read moreJust how many articles are at Planet MySQL?
I was trying to find an old article at Planet MySQL . One about a MySQL UDF to write to /var/log/messages. No luck. Anyway, there is no search option on the site, and the latest addition of 10 entries per page makes it difficult to review pages.
Read moreMySQL Forge
I was reading Zack Urlocker’s MySQL Workbench Beta article and was keen to look at the Extensible architecture. Not much detail yet in the Figure Stylesheets, Scripts and Plugins, which will be good when it’s there, however it lead me to another secret.
Read moreAnother dissappointing MySQL article
Another slightly disappointing article regarding MySQL, this one from a printed magazine. Below are my comments to the editor of Linux Format. The Dear Editor is an email link should others wish to make any comments.
Read moreAtomicity, Consistency, Isolation, and Durability = ACID
ACID is the key transaction processing feature for a RDBMS. Without this, the integrity of the database cannot be guaranteed. In Summary. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state.
Read moreGooglewack
This fad started many years ago, and once I achieved it. Well today, I got the google 1 of 1 result. Here are the rules GoogleWack “Your goal: find that elusive query (two words – no quote marks) with a single, solitary result!
Read moredbus messaging error under CentOS 4.2
The Problem I’ve been getting the following /var/log/messages errors: <br /> Mar 13 21:38:42 lamda dbus: Can't send to audit system: USER_AVC pid=3606 uid=81 loginuid=-1 message=avc: denied { send_msg } for scontext=user_u:system_r:unconfined_t tcontext=user_u:system_r:initrc_t tclass=dbus<br /> Mar 13 21:39:17 lamda last message repeated 7 times<br /> Based on the command dbus-launch – Utility to start a message bus from a shell script.
Read moreBeating those annoying telephone menus
Everybody hates having to listen to automated telephone systems, with long menu options, and you just want to speak to a human, even to be redirected to another human. I can’t count the number of times I’ve been in the menu system for 30 mins.
Read moreTesting a new MySQL Transactional Storage Engine
As part of my A call to arms! post about a month ago, I’ve had a number of unofficial comments of support. In addition, I’ve also been approached to assist in the completion of a MySQL Transactional support engine.
Read more