Select Page

MySQL tuning

I use mysql a lot. It is the underpinning of these blogs, my online photo albums, my new drupal sites – a lot.

I found this collection of great scripts to help even the seasoned mysql admin tweak some more.

I especially liked the tuning script:

SLOW QUERIES
Current long_query_time = 10 sec.
You have 9 out of 8370223 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.

TABLE CACHE
Current table_cache value = 64 tables
You have a total of 288 tables
You have 64 open tables.
Current table_cache hit rate is 0%, while 100% of your table cache is in use
You should probably increase your table_cache

Very nice work. I’ll be working on squeezing that extra 1% out of mysql tomorrow.

Time off

Back from travelling – I’m taking a few more days off to decompress.

Working on a website for Grania – I’ve decided to use Drupal again. I’m a bit rusty (it’s been 18 months since I touched Drupal 4.7) and I’ve been exposed to too much WordPress. I need to get my head around Drupal templates again rather than WordPress themes.

Also looking at migrating the production webserver from Apache to lighttp – I’ve been testing lighttp for a while and it is incredible.

Time for a break

It’s been a busy few months.

I’m taking some time off for a while to get back to normal.

No more logging bugs, testing fixes, writing docs, building demos, working in the superlab, answering questions, defending the decisions of others …

I’ll be back online in a week or so.

ENGL ZToolkit 5 beta

I’m building demos – and I’m using a pre-release (very restricted) version of the ENGL ZToolkit version 5.

It not only supports Vista – but also ZENworks Configuration Management.

I’ll get round to doing some screencams later.