Open Query blog

Tip of the day… if your application uses features such as transactions or foreign keys, and you use the InnoDB storage engine for some (or all) of the tables, do
SHOW VARIABLES LIKE “have_innodb”
and check for
have_innodb having the value of YES
at the start of your application.
That covers InnoDB not having been excluded [...]

Filed under: Uncategorized | by arjen
No Comments »

People, I need some help here. Many users run into the problem that on Gentoo, InnoDB is disabled. It’s not even compiled in. So, no transactions, no foreign keys. Unless you recompile.
Someone reported it as a Gentoo bug: http://bugs.gentoo.org/show_bug.cgi?id=44592
It was closed as “Won’t Fix” and the argument was
“USE=innodb greatly increases the MySQL compile time.
[...]

Filed under: Uncategorized | by arjen
No Comments »

I’m sure you’ve seen the alert on (dev.)mysql.com or elsewhere, there’s a bot/worm on the loose that targets unsecured MySQL servers on Windows platforms.
See also http://forums.mysql.com/read.php?3,13227,13227 for more details.
Regardless of whether you can be affected by this particular worm, it is a good opportunity to check out your own setup… is it properly secured? Here [...]

Filed under: Uncategorized | by arjen
No Comments »

OSCON 2005 is happening, Aug 1-5 in Portland, Oregon.
There’s a database track which includes MySQL (of course
Now’s your chance to submit for the call for papers!
Talks, tutorials, workshops, BoFs….
See http://conferences.oreillynet.com/os2005/ for all details.
Deadline February 13th, but you don’t want to wait
I don’t know if I can be there yet myself, but who [...]

Filed under: Uncategorized | by arjen
No Comments »

You may or may not have heard of Eventum… it’s an issue tracking system that MySQL AB uses to manage its technical support.
Eventum’s history in a nutshell:
It was written by Joao Prado Maia, and it was already looking rather nifty before its first official release! However, MySQL support needed more, and nothing else came even [...]

Filed under: Uncategorized | by arjen
2 Comments »

Been teaching a MySQL training course in Sydney this week. I don’t get to teach training courses nearly as often as I’d like to – I love doing it. Nothing wrong with my main job though
Met up with Pia Smith from Linux Australia this evening, played a dismal round of pool…. then visited [...]

Filed under: Uncategorized | by arjen
No Comments »

PHP has been awarded the Programming Language of 2004, according to the TIOBE Programming Community Index.
This index uses information collected from the popular search engines, and are based on the world-wide availability of skilled engineers, courses and third party vendors.
I am a PHP fan, I know PHP is often used, but you generally hear more [...]

Filed under: Uncategorized | by arjen
No Comments »

We have created a page for the MySQL User Groups: http://dev.mysql.com/user-groups/
I know that many more groups exist, but not which ones are active. So my question to you is, please use the feedback form from the page (or send a mail to: ug at mysql.com) to tell me about your user group!
Thanks!

Filed under: Uncategorized | by arjen
No Comments »

As earlybird registration for the MySQL User Conference is open, I’d like to draw your attention to one tutorial which I think is of particular interest: Mastering Changes and Upgrades to Mission Critical Systems, by Andrew Cowie of Operational Dynamics.
It is about how to plan upgrades (or any other changes) on mission critical systems. Of [...]

Filed under: Uncategorized | by arjen
4 Comments »

Happy New Year!
At this year’s beginning, please spare a moment’s thought (and funds) for the people in the region where the tsunami struck last week. Donate to a local organization or via http://donate.ifrc.org/
Don’t wait, just do it now!
Thanks.

Filed under: Uncategorized | by arjen
No Comments »