Tag: MySQL

TechRepublic Article: “Are tech certs valuable or not?”

I normally do not repost articles and make teeny tiny blog posts (I have noticed a few bloggers who do that, and it bothers me), but I found a short article on TechRepubliccalled Are tech certs valuable or not? to…

Read More >

Why are your indexes larger than your actual data?

I sometimes encounter this phenomenon when a database has tables in which the indexes are larger—sometimes much larger—than the actual data stored in the table. Often, the table becomes unwieldy, which generates a number of questions: Should I partition? Should…

Read More >

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

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.

Read More >

Better late than never…. prizes for this year’s OOW11 Blogger’s Meetup

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.

Read More >

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

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 More >

Securing MySQL and How to Be a Rock Star DBA Presentation Slides

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

Read More >

How Oracle Has Done Nothing to Change MySQL

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…

Read More >

Change Views DEFINER without ALTER VIEW : how to fix thousands of views!

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 More >

Liveblogging at OOW: State of the Dolphin

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…

Read More >

Call for Papers for Collaborate ends tomorrow!

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…

Read More >
Page 27 of 89« First Page...10...2526272829...40...Last Page »