SQL Antipatterns, by Bill Karwin
I remember that when I finished reading The Lord Of The Rings, I
felt a pang of disappointment. "What? Already finished? What am I
going to read now? What can give me the same pleasure and sense
of accomplishment that these wonderful pages have given
me?"
That's how I felt when I came to the last page of SQL Antipatterns. And, no, Bill Karwin doesn't
tell imaginary tales from a fictitious world. This book is full
of very real and very practical advice, but all the material is
presented with such grace and verve that I could not put it down
until the very end. I read it cover to cover in just a few hours,
and I savored every page.
What is this Antipatterns, anyway? The title may deceive a casual
bookshop browser into believing that it's about some
philosophical database theory. Digging further, you realize …
Updated: 29-Jun-2010, 30-Jun-2010.
For me, ODTUG Kaleidoscope 2010 started on Friday with the ACE Directors briefing. Best practices topic was touched there slightly and I twitted about it. I decided that the feedback deserves a blog post so I’m simply quoting the conversation here. If you have anything to add, you know where to find the comment box.
alexgorbachev:
best practices should be forbidden or rather renamed to
blue-prints #ACED …
By default MySQL allows you to create user accounts and privileges with no password. In my earlier MySQL Best Practices: User Security I describe how to address the default installation empty passwords.
For new user accounts, you can improve this default behavior
using the SQL_MODE variable, with a value of NO_AUTO_CREATE_USER.
As detailed via the 5.1 Reference Manual
NO_AUTO_CREATE_USER
Prevent the GRANT statement from automatically creating new users
if it would otherwise do so, unless a nonempty password also is
specified.
Having set this variable I attempted to show the error of operation to demonstrate in my upcoming “MySQL Idiosyncrasies that bite” presentation. …
[Read more]I was there in the meetup and my feeling was a mix about the same. It was nice to have Kaj here (for the first time) and listen to him about Sun's acquisition. On the other hand it was disheartening to see so few people from corporates turning up. It was almost negligible. I'm still positive on this and do expect many more people to turn up. There were a total of three talks in the meet and then we had some chit chat with people.
In his first talk, Kaj first greeted everybody in Hindi, Tamil and Kannada and many were delighted. Kaj touched various aspects of Sun's acquisition and also their on-boarding struggle. He also mentioned about MySQL considering Sun's liberal SCA in place of their stricter CLA. (I haven't gone through SCA to actually comment on it's benefits)
Second talk by Thava was on how to contribute code to …
[Read more]Properties:
| Applicable To | MySQL Server |
| Server Startup Option |
--log-queries-not-using-indexes
|
| Scope | Global |
| Dynamic | Yes |
| Possible Values | Boolean |
| Default | False |
| Category | Performance, Monitoring, Best Practices |
Description:
If you have slow query logs enabled (with
--log-slow-queries), this variable will help
interpret all those queries that are not using indexes as slow
queries.
Usage:
While …
[Read more]Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. I was successful in streaming the live video on www.ustream.tv, and you can see it in totality at http://www.ustream.tv/recorded/352479.
The slides are available in pdf form. And here are some of the links I spoke about:
[Read more]Jay Pipes is a co-author of the recently published Pro MySQL recently spoke at Google on MySQL Performance Tuning Best Practices
You can check out a video of the presentation on Google Video
There is also a good video from Google called The Paradox of Choice: Why More is Less.