by Andrew Johnstone
A while back I wrote an awk script to process a custom log file to work out how an application was performing over a period of time. The following script takes a timestamp in field one $1 and also an arbitrary field $10 in this case. For every 100 lines of the log file processed […]
Recently I started migrating an old server, which had skip-networking within my.cnf, which is not a dynamic option and requires you to restart the mysql server. I typically rsync the source code and static data to a new machine. Configure the webserver with the relevant vhosts and change the database connection details to point to […]
In: Linux
29 May 2010After attaching an EBS volume and rsyncing files to the EBS device the server had a load average of 6 before the server became unresponsive to ssh connections and complained of a broken pipe for ssh. The server was still responding to http requests and ping, however trying to establish a ssh connection, it connected […]
In: Linux
22 May 2010I wrote a few munin plugins to monitor memory, CPU and IO usage per process. After collecting the stats for a few days I noticed that MySQL CPU usage had a constant value of 9.1, however all other processes collected CPU usage correctly.. CPU usage proc=mysqld value=$(ps u -C $proc | awk ‘BEGIN { sum […]
I have been a developer for roughly 10 years and have worked with an extensive range of technologies. Whilst working for relatively small companies, I have worked with all aspects of the development life cycle, which has given me a broad and in-depth experience.