Before MySQL 5.1 a UDF was the only way to extend MySQL. All you need in a UDF is: init() execute() deinit()my_bool id3_parse_init(UDF_INIT *initid UDF_ARGS *args, char *message) WARNING: use STRICT mode in MySQL, otherwise there are tons of silent failures.
They charge for some of their products because without money, they cease to exist, and then even the free version stops being developed on. “A necessary evil” is a dangerous phrase, and can lead to a slippery slope….but in this case, I do not envision that it is a big problem. Maybe I will regret saying this if things keep getting more and more closed, but I do not believe so.
Architecture of Maria: A New Storage Engine with a Transactional Design
Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very quickly, and to use them quickly. The sandbox untars in seconds, for installing alternative servers, not main instance, it creates a separated environment (datadir, port, sockets) — for groups of related or unrelated servers. Really good for testing out new server versions. Save yourself some time and read this post to find out how to automate MySQL Sandbox!
I’m at Collaborate 08 in Denver right now.My presentation, Oracle 11g New Features Out of the Box, was originally scheduled on Thursday at 9:45 AM but due to participation in the speaker panel ,”To RAC or Not To RAC: What’s Best for HA?”, it was rescheduled to today, Wednesday, at 4:30 PM. I’m off to the Carol Dacko’s presentation about DBMS_XPLAN now and looking forward to show up at the RAC SIG Birds of a Feather later today. Stay tuned – more to come…
Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. There are links to the slides and video in this post.
Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played from the embedded video at the bottom of this post or directly at YouTube (follow the link in this post)
SQL Server 2005 brought some relief in the form of the Forced Parameterization database option, and SP2 took things one step further with better throttling of the cache… but it’s still not enough. We want a knob! The bad news: We’re not getting quite the knob I was hoping for. The good news: SQL Server 2008 will include an sp_configure option called “optimize for ad hoc workloads”
I arrived at Santa Clara yesterday, just in time for the MySQL Community dinner (check this post on Arjen’s blog). It was a lot of fun, not to mention the opportunity to talk to developers and other folks from MySQL/Sun. I’ve been to a bunch of great presentations and sessions so far, have a look at my post to find out more and stay tuned for updates.
How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [