Development, Analysis And Research
by Andrew Johnstone
Archive for February, 2011
MySQL oddity with disappearing body of stored procedures
In: MySQL
5 Feb 2011I wrote a couple rather large stored procedure some time ago to generate a couple reports. A bash script truncates a temporary file and executes the stored procedure writing to a temporary location, the bash script adds the headers to the final location of the csv file and concatenates the contents of the csv written [...]
- No Comments
- Tags: MySQL, Stored Procedures
About this blog
Andrew Johnstone is a software engineer / lead developer working at Everlution Software.
Photostream
Archives
- April 2013
- October 2012
- September 2012
- July 2012
- 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
- Steve: Hi there... sorry that this is old, but I'm trying to use your script to check for my usage per seco [...]
- vinodh: great. thanks . My boss wanted me to configure multiple mysql instances on same physical machine . i [...]
- andrew.johnstone: In the example above this was in fact using spl_autoload_register. I've never debugged this properly [...]
- Mike: I had a similar problem I think where a random class would fail to load when others loaded just fine [...]
- John Cannon: Hey that was really needful. Thanks for sharing. I'll surely be looking for more. [...]
- Awk craziness: Processing log files
- Elastic Search Presentation
- Requests per second from Apache logs
- Hackday @ Everlution
- 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
