World has opened up in San Fransisco with the database bangs. MySQL and Oracle databases have scintillated the hearts of developers, DBAs, technology aficionados, and the mere spectators. That and plethora of news has also poured in from SQLServer melas. This Log Buffer Edition is proud to shed spotlight on all these happenings in this Log Buffer #241.
Better late than never – we absolutely have prizes this year for the Blogger’s Meetup. Alex has been way too busy of late to get this organized (joking, not ALL his fault…). Seriously, we do have prizes. We will have beer and there will be food at Jillian’s in a very short time.
Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it. Read to find out more.
For those who missed my presentations at Oracle OpenWorld (or if you caught it but want the slides) – PDF slide decks are online: Securing MySQL (IOUG) –http://technocation.org/files/doc/MySQLSecurity2011_09.pdf How to Be a Rockstar MySQL DBA –http://technocation.org/files/doc/2011_09_RockStar.pdf
Last night at the Oracle OpenWorld MySQL Community Reception, there were lots of old and new friends milling about. It occurred to me that there is one very important thing Oracle has NOT changed about the MySQL world – the rock stars and higher-ups are still readily accessible. One of the things I love about…
Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it. Read to find out more. Preface: Views have security context and their own access control….
Thomas Ulin, VP of MySQL Enginnering, speaks about “State of the Dolphin” at 2011 Oracle OpenWorld. There are some pretty cool new features in MySQL 5.6 development milestone release 2, and they are all quite stable, which is exciting. They want to add more features before going GA with MySQL 5.6, but the ones in…
The call for papers for Collaborate ends tomorrow, Friday October 14th. Collaborate is Sunday, April 22nd through Thursday April 26th at the Mandalay Bay Convention Center in Las Vegas. This year the folks scheduling the MySQL Conference and Expohave smartly chosen not to conflict, and in fact they are 2 weeks apart. Collaborate is the…
With Oracle Open World in the offing, Oracle and MySQL bloggers and professionals are flocking to either San Fransisco or to their blogs to relish this annual medley of technologies under one roof. This Log Buffer Edition covers that and much more in Log Buffer #240.
It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors because they are exact numeric data types. It must be kept it mind, that there are limits in precision, and the maximum number of digits for DECIMAL is 65. What I am discussing here is rounding error.