Secure Login Form






Lost Password?
No account yet? Register

Syndicate

Home
Snow on the Redbuds (again)
Saturday, 20 March 2010

Snow on the Redbuds

Here it is March,
its already spring.
The robins are back,
every morning the birds sing.

Oklahoma weather is strange,
it can rain with the sun up high.
But I love it when
snow falls from the sky.

When I got up this morning,
it was cold and my window was bright.
There was snow on the Redbuds.
It fell through the night.

Mark Grennan
March 23, 2006

Last Updated ( Saturday, 20 March 2010 )
 
MySQL Table Caching
Tuesday, 01 December 2009
Too much of a good thing...

I have had a lot of people asking me about MySQL lately so I thought is was time to share something I learned.  Too much caching space in MySQL can be a bad thing.

You would thing the more you can stuff your entire database into memory the better off you would be and the faster your system would work.  That is not completely true. I have made mprovements by lowering table_cache variable on every version my MySQL 5. From what I have read this seems to be due to overhead managing file descriptors and caching tables.  Like most things there is a point of diminishing returns when dealing with cache tables.  At some point your hit rate is overtaken by the management threads.

This seems to work best.  The read_rnd should be four times the sort and join buffer and they are four times the read buffer.  Something like this;

sort_buffer_size = 16M
read_buffer_size = 4M
read_rnd_buffer_size = 64M
join_buffer_size = 16M

Send me feedback at Mark at Grennan.com
Last Updated ( Tuesday, 01 December 2009 )
 
Simple Disaster Recovery Backup for VMware
Thursday, 08 October 2009

Some time the simple scripts are the best. Disaster Recovery (DR) backups do not have to be made every day.  At some places I've worked we made DR backups as little as one a year.  

DR backups contain everything. You copy the entire envirement so you can buy new hardware and restore the operation of the needed services as quickly as posible without installing from scratch.  Backups on tape are great but how can you restore the data if you don't have a tape server with the right OS and software in place ready to do the restore?  VMware makes this eazy because it uses files as disks and you can make point in time snapshots.
Last Updated ( Thursday, 08 October 2009 )
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Results 5 - 8 of 60