Skip to content

Thoughts about technical things

Musings on a random collection of technical topics

Category Archives: mysql

MySQL performance problems

I wrote a stored procedure on MySQL that is using a cursor to update a table of about 45,000 rows. The details what it is doing is are unimportant but the logic is very simple. The procedure was running extremely slowly (of the order of 1/10 th second per operation) – the steps below describe […]

Posted byadmin.ianMarch 29, 2012Posted inmysqlLeave a comment on MySQL performance problems

Recent Posts

  • Getting Started with microk8s – using Activiti Cloud
  • SSO
  • Alfresco DevCon 2019
  • Simple Kibana monitoring (for Alfresco)
  • Puppet – the very basics

Recent Comments

  • grails – the very basics – Thoughts about technical things on Using Roo on an existing database
  • Ian on Upgrade time?
  • Richard Esplin on Upgrade time?
  • Aikau and CMIS – Thoughts about technical things on A dojo store for the cmis browser binding
  • Ian on Share CAS logout

Archives

  • May 2019
  • February 2019
  • February 2017
  • June 2016
  • May 2016
  • June 2014
  • April 2014
  • December 2013
  • October 2013
  • July 2013
  • June 2013
  • May 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • May 2012
  • March 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • August 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • January 2011
  • November 2010
  • October 2010
  • August 2010
  • December 2008
  • October 2008
  • September 2008
  • October 2007

Categories

  • alfresco
  • cas
  • classloader
  • cmis
  • dojo
  • etl
  • git
  • hadoop
  • java
  • jaxb
  • jpa
  • ldap
  • Linux
  • mongodb
  • mvn
  • mysql
  • orbeon
  • perl
  • python
  • Ubuntu
  • Uncategorized
  • xml

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Thoughts about technical things, Proudly powered by WordPress.