The Apache Friends team is proud to announce XAMPP 1.5.3 for
Linux and Windows. The new version of XAMPP includes fresh, green
and up-to-date versions of: PHP 5.1.4, MySQL 5.0.21, Apache
2.2.2, phpMyAdmin 2.8.1 and OpenSSL 0.9.8b.
In case of Linux we also upgraded ProFTPD to the recent 1.3.0 and
in case of Windows we included the new version of FileZilla FTP
Server 0.9.16c.
Download XAMPP 1.5.3 here
May
29
2006
May
29
2006
Couple of weeks ago when testing the Disk based storage in MySQL cluster 5.1.6 I ran into some annoying unstabilities
I've updated to 5.1.9 in the meanwhile.. my cluster has been up for 5 days now it seems like the problem has been fixed in the more recent versions.
I`ll continue runnnig tests to see if it stays stable :)
May
29
2006
"Ovid":http://users.easystreet.com/ovid/ wrote a short article "giving a glimpse of Perl 6":http://www.oreillynet.com/onlamp/blog/2006/05/lamp_linuxsapachesmysqlphpytho.html?CMP=OTC-6YE827253101&ATT=lamp+Linux+s+Apache+s+MySQL+P+hp+ython+erl+56
If that was too dry and technical for you, then instead go read about how he "he caught two idiots using his credit card":http://www.askbjoernhansen.com/archives/2005/03/25/catching_the_cr.html last year.
May
29
2006
"Ovid":http://users.easystreet.com/ovid/ wrote a short article "giving a glimpse of Perl 6":http://www.oreillynet.com/onlamp/blog/2006/05/lamp_linuxsapachesmysqlphpytho.html?CMP=OTC-6YE827253101&ATT=lamp+Linux+s+Apache+s+MySQL+P+hp+ython+erl+56
If that was too dry and technical for you, then instead go read about how he "he caught two idiots using his credit card":http://www.askbjoernhansen.com/archives/2005/03/25/catching_the_cr.html last year.
May
29
2006
I've always been interested in refactoring code, but one thing
that is always a little harder is refactoring databases... there
isn't enough documentation available on it.
I was quite excited to see a new book published this month. I've started
reading it through my Safari subscription.
I've inherited a fair bit of bad code in the past. Sometimes you
can see that things don't work, but you don't know what to fix.
The refactoring process is all about 'smells'. A smell is a
particular design pattern that might have been a bad
choice.
I'm particularly fond of this 'smells' term (commonly appearing
refactoring books). It makes me think of food; if it smells, it's
probably bad, or rotting. That's not *always* true …
May
29
2006
I'll be coming to the MySQL User Conference next month, then hanging
around a little while longer for a support group meet.
After booking various things my bank called me about possible
fraudulent charges on my credit card. Apparently I wasn't
supposed to go?
May
29
2006
I sat the MySQL Core Exam in November, and I'm happy to report
that I passed!
Last month came time to sit the pro exam, and not feeling as
confident after what was quite a tough core sitting, I thought it
was time for some study. While some things might appear obvious
to some, I thought I'd share the notes I took when I was reading
it:
-
- Enums and sets can be set by their 'bit' value or actual
value.
- <=> is the null safe equivalent to =
- MyISAM provides no data caches (except query cache). It
relies on the host OS to provide it.
- InnoDB can use a raw partition for its tablespace
- There is a general log file which can store all queries (as
well as of course binary log & slow query)
- Temporary tables can be named the same as non-temporary tables, with the temporary taking precedence (could …
May
29
2006
The current version of mysqldump can export a database to a
tabbed output. This is nice, but it seems it can only do one
database at a time.
I wrote a quick script to attempt to merge multiple tab dumps.
It's incomplete -- and the chmod 777 in it is definitely
evil.
Tab dumping is faster for MySQL to import than an SQL dump, and
it produces a smaller file. With a bit of work, this is the way
to get your exports as small as possible. This helps if you had
to rebuild a slave on another network, and/or you pay too much
for bandwidth!
Your thoughts appreciated.
See: http://tocker.id.au/files/mysqltabdump.phps
May
29
2006
It doesn't look like I'll be making it to the MySQL User
Conference (argh!). I've constructed a list of sessions I'll be
missing out on. Perhaps some of the others
in Brisbane will take notes for our user group
Monday:
-
- Optimizing MySQL Applications Using the Pluggable Storage
Engine Architecture : Lentz
- MySQL Performance Optimization : Zaitsev, Asplund
Peter Zaitsev is often online at the same time as me. I like
to ask him all my idiot InnoDB questions -- he know's his
stuff.
Tuesday:
-
- The 5.1 Release : Aker
- Migrating a Large System to MySQL …
May
29
2006
The Apache Friends team is proud to announce XAMPP 1.5.3 for Linux and Windows. The new version of XAMPP includes fresh, green and up-to-date versions of: PHP 5.1.4, MySQL 5.0.21, Apache 2.2.2, phpMyAdmin 2.8.1 and OpenSSL 0.9.8b.
In case of Linux we also upgraded ProFTPD to the recent 1.3.0 and in case of Windows we included the new version of FileZilla FTP Server 0.9.16c.