Development, Analysis And Research
by Andrew Johnstone
Archive for May, 2010
Emailing Attachments: Exim Filters and PHP streams
In: PHP
31 May 2010A while back a colleague and myself had a two week sprint to ensure that we could deliver 20k emails with up to 5mb attachments each. We experimented with 4k emails at 5mb each sending straight through the MTA, which we found to cause excessive load on the servers. Using exim filters we could add [...]
- No Comments
- Tags: Exim, Mail, PHP
Broken XFS on Elastic Block Storage (EBS) and SSH failing on “Write failed: Broken pipe”
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 [...]
- No Comments
- Tags: EBS, Linux, Storage
MySQL: LAST_INSERT_ID()
In: MySQL
26 May 2010If you use LAST_INSERT_ID() and insert on the primary key value it will only return the last “insert id” which has not included the primary key DROP TABLE IF EXISTS `example`; CREATE TABLE IF NOT EXISTS `example` ( id INT(11) NOT NULL AUTO_INCREMENT, b CHAR(3), PRIMARY KEY(id)) ENGINE=InnoDB; INSERT INTO example SET id=1; INSERT INTO [...]
- No Comments
- Tags: MySQL
Monitoring Processes with PS
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 [...]
- No Comments
- Tags: Bash, Linux, Monitoring
About this blog
Andrew Johnstone is a software engineer / lead developer working at Everlution Software.
Photostream
Archives
- January 2012
- December 2011
- June 2011
- February 2011
- January 2011
- December 2010
- July 2010
- May 2010
- April 2010
- January 2010
- December 2009
- October 2009
- June 2009
- February 2008
- July 2007
- June 2007
- April 2007
- December 2006
- October 2006
- August 2006
- July 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- August 2005
- July 2005
- June 2005
- March 2005
- June 2004
- apt-get unattended / non-interactive installation | Development, Analysis And Research: [...] previously wrote about “Installing Java & MySQL – unattended/non-interactive insta [...]
- franck: http://en.wikipedia.org/wiki/FreeBSD_jail [...]
- franck: That web server should not live in such close proximity to that SMTP server... chroot/jail may be th [...]
- Vagrant – Automating PHP Installation with bash/slack for continuous deployment | Development, Analysis And Research: [...] More examples of installing MySQL unattended can be found at Installing Java & MySQL – u [...]
- Can the NIC ucarp uses be bridged? - Admins Goodies: [...] http://ajohnstone.com/achives/running-several-vips-on-the-same-interface-with-ucarp-and-haprox [...]
- apt-get unattended / non-interactive installation
- PHP apache_note, Graphite & Logster for logging
- Vagrant – Automating PHP/MySQL Installation with bash/slack for continuous deployment
- PHP5.3 autoload/class_exists fail
- Selenium
- Installing Java & MySQL – unattended/non-interactive installation
- Memcached multigets – ubuntu vs debian
- Optimizing and testing MySQL over NFS with NetAPP
- MySQL oddity with disappearing body of stored procedures
- MySQL to Oracle synchronization using PHP over VPNC