|Smartmedia Icons||Monday 28th November 2005|
I have recently had to reinstall the bulk of my computer (damn overclocking). I decided it was about time I moved from Windows 2000 to Windows XP, as everybody else is. I never did before due to the problem with Mouse Acceleration on Intelli Explorer mice; but as I don't play many games these days, I think I'll live.|
In my customisation stint I thought it would be nice if I changed the icons for all my drives (All the letters up to M are in use, plus some more past there!). I spent ages searching Google for suitable icons for my removable media card reader. Didn't find anything very good.
After a long time I had a burst of inspiration that paid off. Don't go searching on the net, just look in your shell32.dll. These icons didn't exist in older versions of Windows, but there are ones suitable for card readers in there.
I also linked up my mapped drives with a bit more spinky icons. If you are wondering how to do this then you need to play in your registry:
Create a new key for each drive, then inside that key create a new one called "DefaultIcon". Assign the default property the full path to the icon file followed by a comma and the icon number (starting at 0, use 0 if it's an .ico file etc). e.g:
You can also add a key called "DefaultLabel" to give the drive a default name.
|MySQL Transaction locking.||Tuesday 1st November 2005|
Just a quick note before I forget.|
Holding open a transaction in MySQL with the InnoDB engine (the standard doesn't support specific transactions) won't lock the table to read.
Using SQL Server you would expect to find everybody else locking if you open a transaction and update a table. This would stay in place until you either commit or rollback. By the looks of things in MySQL this is not the case. All other sessions will read the current committed data and ignore the changes being made until the transaction has been committed.
I believe this can be changed either on a session level, or on the server level.
Handy to know though when writing web-sites...