My last post asking what people are looking for in being part of
the Certified MySQL Community brought me a good deal of email. I
will pursue looking into training and service contract discounts
with my bosses. Mugs and t-shirts seem to be popular requests
also.
I even had someone who saw my mention of beta exam testers as
'guinea pigs' and requested branded guinea pigs. Now, I live in
Texas and two miles from my house there is a heard of Bison. A
few folks in the area have cattle, mainly longhorns. A lot of
livestock these days actually get implanted microchips but
branding irons are still used for the recognition of livestock on
the days the cowboys leave the RFID scanner out of the
saddlebags. So I asked about branding.
My consultants on the subject were not inclined to
favorably recommend branding Cavia porcellus. Having
Sakila, the MySQL dolphin, and/or the letters 'MySQL' would
probably be too busy …
Well, that didn't take long. Monty Widenius, one of the founders of MySQL, resigned from Sun Microsystems last week but has already invested some of his hard-earned MySQL dollars in IT Mill, a Finland-based open-source start-up focused on the development of Rich Internet Applications.
While no mention is made ...
In the xml parser that I’ve been writing for rss/atom feeds I’ve encountered what many people have found; bizarre encoding issues when displaying the data from the database on a webpage. Since this is not really well explained by the searches I did on google I’ll explain it here.
Issue: you have utf-8 data coming from a source, you put it into a utf8_general_ci column of a mysql database table. You read the data from the database and display it as html/xhtml. Instead of getting things like double backquotes or long dashes you get euro signs or umlaut type of characters, usually strings of them instead of the correct format.
Potential solution: use utf8_encode and htmlentities in PHP to clean the data before going into the database. This does not work. Why? Those characters are not covered by html standards since they are above ascii code 126. See here for the full code chart: …
[Read more]Knut Anders Hatlen writes about memcached user-defined functions (UDF) for Java DB on OpenSolaris.
Knut has also mentioned the recent release of Apache Derby 10.4.2. A corresponding Java DB release should be available for download soon. (Usually this happens immediately but we're all at a developers' conference for the next couple of …
[Read more]We’re happy to announce the next release of MySQL Workbench 5.0. This one has 19 bugs fixed compared to the last version. We’re about to complete the first alpha version of Workbench 5.1 but in parallel we’re continuing our bug-raid for 5.0 (most of the fixes also go into 5.1 code as well). Stay tuned for the next announcements here on wb.mysql.com
Last week Giuseppe Maxia announced the Call for Papers for the 2009 MySQL Users Conference and Expo, and also announced that there would be an unconference, MySQL Camp, organized by me.
It’s true! Currently MySQL Camp is set to happen, though I am still working out details with Colin Charles and Giuseppe Maxia. We had originally talked about having MySQL Camp on Tuesday and Wednesday, but I would like to add Monday so that folks attending the conference who are not attending a tutorial have a choice on Monday. I am also looking into lunch options, since the conference venue does not have many options within walking distance.
There will be plenty of …
[Read more]While Colin beat me in blogging about Project Kenai, I think I can still provide some additional background information about this new project hosting service from Sun.
If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice.
Some of the hosting services that I am currently aware of and the choice of SCM they offer include:
- BitBucket ( …
First of all, I know this is a known problem, but it struck me so hard, I just had to write about it!
As Peter Zaitev points out calling SHOW STATUS
might have a huge performance impact.
We recently replaced one of our servers with a DELL R900 with 96GB RAM. Having a disk-bound workload and > 1TB worth of data in InnoDB we expected a noticeable performance gain compared to the former server with 32GB. The new server even has better RAID and HDD.
But that was not the case. Things got even worse! A lot of
queries “hang”, server load peaked at almost 7 and we saw a lot
of cpu activity. Just before I started a deep analysis of what is
going on inside I spotted a SHOW GLOBAL …
The Netways Nagios Conference 2008 in Nürnberg (DE)
was opened today by Ethan Galstad, creator of Nagios. He gave an
overview of how Nagios evolved and the steady growth of the
monthly downloads, now reaching 16k!
The Nagios 3.0 overview was quite nice. Apparently lots of effort
was put in optimizing it for bigger setups, like doing host
checks in parallel and changing internal structures not using
linked lists.Great was also to hear that the web interface is
being revamped, as well as the Embedded Perl becoming some kind
of plugin, called Event Broker Modules. This is however for the
next experimental versions (v3.).NRPE/NSCA are probably doomed to
go into maintenance. Ethan said they would likely be replaced by
more standard protocols and web services.
MySQL was mentioned when the NDOUtils were …
I have been talking about the UDFs for MySQL during lunch, and Knut Anders bragged about being able to do that in Java DB as well..
So what could I do? I just had to challenge him ;-)
As always, Knut Anders delivers! Just check out the blog entry he wrote!
Knut Anders, I'm impressed! This looks like a clean solution! keep up the good work! (By the way, you should use SMF to control the memcached server. Check out my blog post for the details).