Tag: MySQL

Log Buffer #196, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly roundup of database industry news.

Read More >

Three Editions of MySQL are Available

Those of us that have been around for the past 3 or so years know that there was a point in time where there were two different editions of MySQL available, back when MySQL Enterprise and MySQL Community were actually different. But that experiment was a complete failure, and the code is now the same. MySQL Enterprise does package the software in a way that is not available to the community, specifically the quarterly service pack (QSP) releases. But the actual code….the same.

Read More >

INFORMATION_SCHEMA tables are case sensitive

I wanted to get examples of some of the extra information that the Percona server has in its INFORMATION_SCHEMA metadata, and in doing so, I stumbled across an interesting MySQL bug/feature/point — INFORMATION_SCHEMA tables (which are actually system views) are case sensitive when used in comparisons:

Read More >

Log Buffer #195, A Carnival of The Vanities for DBAs

A short post marks Pythian’s 195th edition of Log Buffer, a blog of blogs encapsulating what’s going on in the world of database administration.

Read More >

Log Buffer #194, A Carnival of The Vanities for DBAs

We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.

Read More >

Log Buffer #193 – A Carnival of The Vanities for DBAs

Welcome to Log Buffer, the weekly roundup of DBA industry happenings.

Read More >

ODTUG Kscope Wrap-up and Slides

Ronald Bradford and I produced a successful MySQL track at Kaleidoscope (hereinafter referred to as Kscope). With a speaker list of Philip Antoniades, Josh Sled and Craig Sylvester of Oracle, Laine Campbell of PalominoDB, Patrick Galbraith of Northscale, Sarah Novotny of Blue Gecko, Padrig O’Sullivan of Akiba, Dossy Shiobara of Panoptic.com and Matt Yonkovic of Percona, we knew the technical content was going to be great.

Read More >

ODTUG Kaleidoscope 2010: Best Practices

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.

Read More >

MySQL’s SQL Deviations and Extensions

Today at Kaleidoscope I will be doing a 90-minute session comparing MySQL’s SQL syntax to the ANSI/ISO SQL:2003 standard, entitled What Do You Mean, “SQL Syntax Error”? You can download the PDF slides here.

Read More >

MySQL and Quoting

MySQL does not follow the ANSI SQL standard for quoting. MySQL’s default quoting behavior is that either single or double quotes can be used to quote a string (this gets me into trouble when I work with Oracle databases, as double quotes do not indicate a string!).

Read More >
Page 40 of 87« First Page...10...3839404142...50...Last Page »