by ezs | Aug 23, 2007 | evilzenscientist, Uncategorized
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.
by ezs | Aug 23, 2007 | Technology, Uncategorized
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.
by ezs | Aug 22, 2007 | evilzenscientist, Uncategorized
It’s a feature. Working as designed. Closed as invalid.
by ezs | Aug 16, 2007 | evilzenscientist, Uncategorized
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.
by ezs | Aug 14, 2007 | evilzenscientist, Uncategorized
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.
Recent Comments