Firstly, I finally realized who Jonathan Schwartz reminds me of:
That's right, comedian and magician Penn Jillette.
Schwartz started by saying, "enough of this free software stuff!" It got lots of laughs. He started to talk about Sun's agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well -- particularly that each engineer has his/her own opinion.
It is annoying when bloggers would write 'notes' about a
presentation in the conference when all they are doing is just
copying the presentation slides.
That is not note-taking since copying the slides doesn't make
sense. Note-taking is giving insights to the presentation or
adding / deleting information to certain parts of the
slides.
My ears are tingling when I hear people typing on their keyboard
and then later on would upload their 'notes' regarding the
presentation. Instead they should stop what they are doing and
just listen to the speaker and try to digest what he is saying.
Ok, this blog is currently hosted by 1and1.com, and I think that needs to change, which is sad, because up until recently, I’ve been pretty happy with the performance. However, I recently had an issue, and some things came to light about my package that I wasn’t aware of.
First of all, the maximum time a process can run is about 6 seconds. Second of all, the maximum number of processes you can have running at once is 12. When I asked if this was a limitation of my *package*, the answer I got was that it was a limitation of all shared hosting accounts.
This blog started throwing 500 errors some time yesterday. I called support late last night and some lady said that she was running a tool that should fix my issue, and to call back in 30 minutes if the problem persists. Well, I’m sick as a dog, and it was late, so I went to bed. This morning, the problem was still there. I called support 3 times today, got cut off twice, and …
[Read more]Here are some more photos from the MySQL conference during the keynote sessions. I've also posted some video on YouTube.com with clips from presentations by Marten Mickos, Jonathan Schwartz and Werner Vogels, CTO of Amazon.
Update: I've added some more photos and videos from Wednesday also.
Keynotes
The keynote was kick started by Marten Mickos. If you've never met Marten, he is, on a personal note, one of the greatest CEOs I've ever met. The keynotes were especially interesting for me because it was the first time I've had the opportunity to listen to Jonathan Schwartz, the CEO of Sun Microsystems. Jonathan seems like a great guy who gives the impression he "gets it".
The last keynote was by Werner Vogels of Amazon. His talk covered Amazon's growth and the new services they offer including EC2. He announced that EC2 now supports persistent storage, which is a huge improvement, but doesn't quite solve all of the problems.
Testing PHP/MySQL Applications with PHPUnit/DbUnit
I've never been big into testing, but I'm trying to change that. …
[Read more]Yesterday, Oracle‘s Ken Jacobs and Heikki Tuuri, creator of InnoDB, have announced the immediate release of InnoDB Plugin 1.0 for MySQL 5.1. I’ve already downloaded it and played around with it a bit. I haven’t had time to do any performance benchmarks or similar just yet. Those will come in due time.
This release is the beginning of two exciting things: InnoDB is now officially decoupled from MySQL release-wise, and lots of new features have been added to this new release. I will come to what the decoupling means in a moment, but first, the major new features in this release of InnoDB (from my …
[Read more]mysqlreport v3.5 has been released which has the following fixes, changes, updates:
Once again Jeremy weights in on the oddity called "MySQL Enterprise Edition". This time around it seems that Sun/MySQL is moving towards making their Enterprise Edition more proprietary by including features that will never be available in the Community Edition. Not sure, but I guess they are also not providing the source to the general public (I do not remember all the details of the continued mumbo-jumbo saga surrounding this product, but maybe they already pulled the source from the public version a while ago - please correct me here). I do assume that paying customers will still get the source, though obviously not under an open source license.
As before MySQL AB illustrates that they …
[Read more]Properties:
| Applicable To | InnoDB |
| Server Startup Option | --innodb-additional-mem-pool-size=<value> |
| Scope | Global |
| Dynamic | No |
| Possible Values | Integer: Range: 524288 (512K) - 4294967295 (4G) |
| Default Value | 1048576 (1M) |
| Category | Performance |
Description:
As per MySQL documentation, this pool is used to store data …
[Read more]
MySQL has User Defined Functions. These are loadable modules,
written in C, that can be loaded into a running MySQL server, and
used like a "native" built-in function.
A UDF can be an aggregate function. An aggregate function is one
that takes in multiple rows, but emits only one result. For
example, SUM() is a built-in aggregate function.
I just proved to myself via testing and benchmarking that user
defined aggregate functions are about three times slower than the
call interface to the built-in functions.
THREE TIMES SLOWER!
In about twelve hours I am supposed to be presenting a talk
titled Using User-defined Functions and Aggregates to Speed
Up Your Data Warehouse Processing.
Um. Yeah...
UPDATE:
It turns out to be a MacOS thing. On Linux, the …