Hand-held photo of St. Finbarr’s Cathedral and the River Lee. The original was very dark and the colour was spoilt by the local street lights. Converting it to black and white and adjusting the contrast made for a nice photo IMO!
Me being a big Batman fan, I just took at look at the Batman Begins trailer. It wasn’t great, you don’t get much of a look at the Caped Crusader, but it does give you a taste for the story I suppose! Nice Batman logo! Oh and wget this link if you want to download the trailer in QuickTime format. That at least is friendlier than the wmv format to Mplayer but don’t forget to download the QuickTime codecs to play it!
Pictured from near the Opera House, you can see Shandon, and the construction work building a new appartment block near the river.
Regular visitors to this site will have noticed that this blog and others on the server take an inordinate amount of time to display sometimes. Basically, this machine is unfortunately under-powered but we’re working on making the best of use of the available hardware with some changes to MySQL and Apache and to b2++ too. Here’s what I did this morning:
- Referers are checked and only if requests go to either “/”, “index.php” or “archive/” are they recorded.
- Referers are now recorded using INSERT DELAYED.
- I added keys on the post_date and post_category fields in *posts tables. The main SELECT is now a “range” instead of “all” request.
Here’s a short bash script you can use to update your db. Remember to change “username” and “password” to suit your own setup.
for i in `echo show tables | mysql -u username -ppassword b2|grep posts`; do echo "ALTER TABLE \`$i\` ADD INDEX ( \`post_category\` )"| mysql -u username -ppassword b2; echo "ALTER TABLE \`$i\` ADD INDEX ( \`post_date\` )"| mysql -u username -ppassword b2; done
Useful links: Mysql Optimization | Optimizing MySQL: Hardware and the Mysqld Variables (mentioned previously) | MySQL Optimisation and a few other pages.
Any Corkonians reading this will probably recognise the sign in the background. Before the by-pass was built most traffic going north-west from the City would have passed through Blackpool. I can’t remember this place ever being open! Does anyone know what they made and sold?
It’s rather ironic that a weblog post about Google Privacy which has disappeared off the existing site is now to be found in the Google Cache of the site. hehe.