Mysql show processlist

A very quick entry today, life seems to be so busy at the moment but I have to write this down before I forget. Today I had a weird situation where mysql was consuming a lot of resources but didn’t seem to be actually getting anywhere, as if something was “stuck” inside it. Using the processlist I was able to diagnose the problem. From the command line just run:

show processlist;

If you’re a phpMyAdmin user, then there’s a link for “processes” on the front page of your installation. Give it a try when things seem to be taking longer than they should!

Models and Mentors

The thing with a blog is that its public, so sometimes there are things that happen in my life that I don’t write about here – especially when these are work-related. So instead I’d like to chatter about people I have met in my professional life who have influenced me.

Mentors

Mentors come in two flavours – official and unofficial. An official mentor is part of a formal agreement and may even be regulated by your employer, and an unofficial one is someone you adopt and turn to for advice; I have one of each.

My offical mentor is Lig. my “Big Sis” from phpwomen.org where we run a Big Sis, Little Sis scheme. I expected this to involve a lot of technical input but the biggest thing I’ve got out of this relationship is moral support and an introduction to the wider php community – who in turn provide more of the aforementioned moral support in addition to the raft of technical information you’d expect, and serveral more rafts that you wouldn’t!

My unofficial mentor Mark is an ex-colleague from Snowdrop. Whilst we’ve only met a handful of times in person I took over the Oracle DBA stuff at Snowdrop from Mark and spent a lot of time on the phone/jabber/email with him with that and various other projects. Although we’re both now working elsewhere, live far away from one another, and have other distractions in our lives we still stay in touch. Mark is my “professional” mentor – although we work in different fields of technology, I tap into his business experiences to inform my own choices and deal with situations that are new.

Models

Models are people whose behaviour you learn from or emulate in order to extend your own skill set, either by being actively coached by that person or by learning by observation. I have learned from a senior manager that to stutter endearingly while delivering bad news can work surprisingly well (not an approach to use every day!). When I worked as an administrational temp one summer, I was told to smile when on the phone – something which came in very handy when I worked on a technical helpdesk a few years later. I’ve also learned numerous tricks and techniques from the old hands in the technical departments in the various places that I’ve worked. These battle-hardened geeks can be hard nuts to crack, but they have so many stories to tell its worth it – and some have grown to be real-life friends.

Sometimes you have to ask to be taught something, this can be tricky to do if the person is busy or you are shy. On other occasions you may be able to learn from observation or the other person may mentor you of their own accord. However it happens, I try to make the most of the positive role models and coaches around me. From these people I have learned so many of the skills that I use day-to-day to perform my role and I’m grateful!

Charity Natty Keyrings

At the knitting group I attend in Leeds (first Tuesday and third Wednesday of every month in Starbucks in Borders if you’re interested) we received an invitation to join the “Knit a Natty Keyring” charity event. I can’t find a website for them but here’s a good description of what its all about. I signed up to make two and here they are:

The jumper one was supposed to have sleeves but I ran out of time and enthusiasm at about the same point so it’s staying as it is :)

Extending Joomla! Eventlist

Recently I extended the Eventlist extension for Joomla! to allow my netball club to add the results of fixtures to their site as well as the fixtures which are managed using eventlist.

It was actually much more straightforward than I expected so here’s a quick rundown of the changes:

  1. add two columns to the jos_eventlist_dates table to hold the scores
  2. add them to the class by editing components/com_eventlist/eventlist.class.php
  3. edit the sql statements in components/com_eventlist/eventlist.php and add in our new columns
  4. adding input boxes to the admin interface to administrator/components/com_eventlist/admin.eventlist.html.php, just a couple of input type=”text” boxes
  5. adding a new column to fixture lists in file components/com_eventlist/eventlist.html.php (not taking account of the lovely flexible width administration tool in the admin interface) and putting the results into each row

The scores default to 0-0 and show as 0-0 when there are no results – netball doesn’t really finish with no goals scored so its safe to assume that this means no result in this case! Last weekend our match finished 40-28 which is about average.

Hopefully this is interesting or useful to someone – if nothing else it will remind me what I changed next time I come to do something similar or further modify this!

Pink Snowflake Hoodie

This project has been a very long time in the making. In fact it had stalled completely at one front, one back and half a sleeve when the baby in question arrived! Its for the new daughter of a friend of mine and the first thing I’ve attempted to knit on this scale.

Its knitted in snowflake – the result was absolutely beautiful but I wouldn’t recommend snowflake to a beginner knitter and I won’t be knitting with it again in a hurry. The project was much bigger than I anticipated, the sleeves were almost the size of the front and the hood was something else again – picking up stitches is something I struggle with at the best of times, never mind in novelty yarn!

Thanks to support from my mum (both moral and technical) I did finish the project and manage to give the hoodie to its new owner – welcome Molly :)

A Very Narrow Howto of Podcasting

I recently featured in an episode of Zend’s PHP Abstract. A few people have asked how I went about preparing and recording the piece so here’s a quick overview.

Choosing a Topic

This actually wasn’t hard because I wanted to pick something that I have particular knowledge of. As a part-trained Oracle DBA with experience of Oracle and PHP, these two topics seemed like an obvious choice.

Preparing the ‘Cast

I was quite determined not to read aloud from a script, so I put together some bullet points and practised doing the talk from those quite a lot. Playing back these attempts helped me to see what worked and what didn’t – those points got added, removed and re-ordered quite a few times. Even after a lot of practise, I was still pausing too much between points. I ended up transcribing my unscripted version and then re-recording it, which worked well as I had my own natural language but no pauses!

Sound and Software

I was concerned that I would need additional equipment, such as a better microphone. However my partner has a macbook and the built-in microphone on that proved to be up to the job. I used Garageband from Apple’s ilife to record the track (and also to edit out the clicking I got from pressing the mouse to start/stop recording!). This saves files in .m4a format, but this can be converted to .mp3 using itunes.

PHP Abstract Podcast

I’m a regular listener to the PHP Abstract podcast from DevZone – and this week, I’m the star! Its a short podcast about PHP and Oracle, and you can find it here. Most of the comments so far seem to mostly revolve around my accent …

New LornaJane

Welcome to the newly made-over lornajane.net!

I wasn’t desperate for a change of look but I have been tiring of textpattern for a while. The new version is running on serendipity which will hopefully be easier to work with and suit me better. Handily serendipity was able to import most of my textpattern content (more about the actual process in a later post) so it’s been more about ironing out kinks (like getting the images across) and fiddling with templates than anything else.

The angel up the top there is a new acquisition – the result of my commissioning my good friend Gretchen at http://www.girlscantwhat.com (they also do design work, see http://design.girlscantwhat.com/) to make me something to use as an avatar and general virtual familiar. I hope you like her, I do!

I’ve taken care to get links from the old site working and hopefully the feeds should be working as well – if you’re reading this on your feed reader, then pop in and see the new setup. If you see anything, not working or looking otherwise wrong, please let me know and I’ll take a look. Otherwise, enjoy :)

Facebook Followup

So I was having trouble with facebook a while back, but things have improved.

  • I now check facebook every day
  • I have 38 friends
  • I have seen the pictures of my cousin’s first few weeks at university.
  • I’ve finally uploaded a profile picture because everyone seems to have one! Only two of my friends don’t … and I can understand why.

Facebook is good for staying in touch with people, I’ve exchanged messages with lots of people who are on my peripheral network but with whom I could easily have lost touch, especially because I’ve moved house a lot. People have a “status” and can update it at will, so you can see who is looking forward to their weekend or who is having a bad day.

I utterly adore the daft applications that come with facebook. My two current favourites (although they don’t see a lot of action it must be said) are the aquarium and the garden. Basically people can send each other flowers and fish (for each application respectively) along with a little message, literally just a one-liner to touch base. Its like a wave but the thing they send hangs around in your profile for a bit so you can enjoy it.

I think I’m starting to see the point, but I suspect its only the tip of the iceberg – am I missing anything important do you think?