On a lark tonight I decided to transfer BDB pack_row code to
the
Archive engine to see if packing made any difference. I had
commented
to Peter about this in my previous post (http://krow.livejournal.com/459263.html).
The results?
-rw-rw---- 1 brian brian 1836836760 Nov 27 00:19
accesslog4.ARZ
-rw-rw---- 1 brian brian 1836810272 Nov 27 02:12 foo.ARZ
Accesslog4 is without packing, foo is with packing.
Not much change at all.
Without compression the difference would be noticeable, but
with
compression packing does not make much difference. The
additional
memory required in overhead for packing alone makes it a bad idea
to
implement for an engine already compressing the data
stream.
MySQL does not dictate how an engine stores data. Each of
the …
Maybe the last XAMPP release of 2006: XAMPP 1.5.5 for Windows and
Linux is out. New in both releases of XAMPP are MySQL (5.0.27),
PHP (5.2.0), phpMyAdmin (2.9.1) and a Japanese translation. The
Windows version also contains up-to-date versions of: FileZilla
FTP Server (0.9.20) and ADOdb (4.93).
And today we have yet another scoop for you: The first and long
awaited Intel version of XAMPP for Mac OS X. Also updated with
all the recent versions of Apache, PHP, MySQL and Co.
Download XAMPP 1.5.5 here
I normally read Planet MySQL from RSS, but for some reason I ended up on the actual site today in a Web Browser (Epiphany to be exact) and saw this:
And thought, “wow, ugly”. I don’t keep my browser “maximised” because I think it’s a stupid way to work - I often switch between tasks or like to have an editor open while referring to something in a browser (e.g. some tech details of some source module), or monitor IRC or IM. I remembered that Epiphany has an Ad Blocking extension, so in an effort to de-uglify, I enabled it. I now see:
Hrrm… much better. Notice how the links on the left to the most active are actually useful now (I can read them).
Note that this isn’t a rant on adverts on web sites - I can handle them (the google ones which aren’t obtrusive) - I’m against the uglyweb.
The inaugural MySQL Community podcast is up at:
http://technocation.org/index.php?option=com_content&task=view&id=16
Let me know what you think — leave a comment, suggestion, question or other feedback. We’re also looking for guest speakers, so if you’re willing to produce a piece, let me know…or just produce one and send it!
Call the comment line at +1 617-674-2369
Or use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or leave a message at the Technocation forums:
Or send an e-mail to podcast@sheeri.com
The other night I was thinking about MySQL cluster and whether or not a high speed interconnect would be worth the investment. Doing some research lead me to the conclusion that ethernet latency isn't discussed very often except in niche mailing list threads. I had to do a lot of research to find even a basic discussion of the problem (Note. If you have any good resources on the subject please add a comment.)
In order to help other developers avoid mistakes I've made in the past I figure a good blog post on the subject was in order.
What's ethernet latency? When you send a packet to a remote machine over gigabit ethernet it's not just instant. There's overhead involved in sending the packet back and worth. The data has to go from user space into the kernel, out the network interface, onto a switch, and then back up the kernel and into userland …
[Read more]Innochecksum is a small undocumented (at least in the manual) utility that verifies the checksum of ibdata file pages. I stumbled across it the other day while wandering through the source tree. It has a small bug that prevents it from being able to check files larger than 4G. This patch fixes it in linux. Someone that knows more about large file support in different OSs please comment on the patch.
It lives in the extras folder in the MySQL source. Here is the credits comment:
/*
InnoDB offline file checksum utility. 85% of the code in this
file
was taken wholesale fron the InnoDB codebase.
The final 15% was originally written by Mark Smith of Danga
Interactive, Inc.
Published with a permission.
*/
I think as a community we need to make sure that tools like this are kept in the forge and actively …
[Read more]
No, not for te Elton John concert - though that's made finding
accomodation very "interesting", almost everything is booked out
on the Wednesday... anyway, I'll be in Wellington NZ all next
week (3-8 December) to teach an in-house training course.
If anyone from around Wellington would like to catch up during
that time, please do drop me a line!
- MySQL Bugs: #24601: MySQLd crashes upon creation of an index Bug report I just submitted because MySQL is crashing when I try to create an index. So much for spending the afternoon tweaking performance, eh? (tags: mysql bugs)
A kind soul has contributed a Debian/Ubuntu package for the innotop MySQL and InnoDB monitor. Thanks Sebastien Estienne! Sebastien wrote me that he tested it on Ubuntu Dapper Drake, and I just verified that it works on Edgy Eft. Since I use Ubuntu on my own machine now, I may integrate this into my build process for future releases of innotop. But for right now, at least there’s another installation option.
Maybe the last XAMPP release of 2006: XAMPP 1.5.5 for Windows and Linux is out. New in both releases of XAMPP are MySQL (5.0.27), PHP (5.2.0), phpMyAdmin (2.9.1) and a Japanese translation. The Windows version also contains up-to-date versions of: FileZilla FTP Server (0.9.20) and ADOdb (4.93).
And today we have yet another scoop for you: The first and long awaited Intel version of XAMPP for Mac OS X. Also updated with all the recent versions of Apache, PHP, MySQL and Co.