You can now download MySQL 5.0.3-beta. Horay! Beta means “feature freeze“. No more new stuff will be added, to allow the new and changed code to stabalise as more people use it and report bugs and other quirks. It also focuses the developers’ efforts on this process. So what’s new? Well… Updatable VIEWs SQL:2003 Stored [...]
The MySQL users conf is now only a few weeks away… there’s a new quickpoll up on the MySQL Developer Zone about which topics are of the most interest to you. Multiple answers are allowed. Cast your vote! Thanks.
We have a tradition (ok, it is now the second time) of announcing our “Application of the Year” award at our annual MySQL Users Conference. This award is designed to publicize the best applications built using MySQL and to recognize the organizations and professionals who implemented the technology. To be considered for the 2004/2005 MySQL [...]
Part of my job is to support local MySQL User Groups. I also started a local one in my own town of Brisbane, Queensland, Australia. It is a good exercise to not only work on the macro level but also see the little details. A few months ago I discovered Novell Users International (formerly NetWare [...]
If you’re joining us at the MySQL Users Conference, please consider setting up a BoF session: http://www.mysqluc.com/pub/w/35/bof.html They’re always good fun, and can cover topics in a nice informal setting. Sure, you could wait and just announce the BoF on the notice board, but if you enter your suggestion now, it shows up on the [...]
I wrote a new article about which MySQL version to choose, when to upgrade, bug reporting, etc… it’s up on the dev zone now: http://dev.mysql.com/tech-resources/articles/choosing_mysql.html It has been sadly swiped from feature status by Peter Gulutzan’s item “MySQL 5.0 New Features: Stored Procedures” which is also an excellent read: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
Pretty cool: http://code.google.com/ Google engineers are encouraged to spend 20% of their time (i.e., one day a week) on personal projects, which often end up being Open Source. This, and other code developed inside Google may now be found on those pages, with more coming. I think that is an excellent initiative. I know that [...]
PHP Quebec organises PHP Quebec Conference 2005, at the Crowne Plaza Hotel in Montreal, March 30th and April 1st. They have a great program lined up, and MySQL AB is sponsoring this event. There will also be two really great speakers from MySQL AB, and MySQL certification: Brian Aker, Director of Architecture, MySQL AB Clustering [...]
You do “ps xa | grep mysqld” and see lots of lines… looks like heaps of processes. Newsflash: they aren’t. On closer investigation, you will find that each of the processes appears to be using the exact same amount of RAM, too… what a coincidence What are in fact looking at a Linux 2.4 kernel [...]
When assigning unique IDs to rows, do not do SELECT MAX() FROM table; Add one. Why not? Well, if two people insert a new row at the same time, you will get into trouble. And it will happen. The same applies to using this “method” to find out which id was just added for your [...]