Category Archives: Server Tuning

Find All Tables With No Primary Key

A friend asked for this, so I thought it’d be helpful:
All tables with no primary key:

use INFORMATION_SCHEMA;
select CONCAT(t.table_name,”.”,t.table_schema) as tbl,
from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c
ON (t.TABLE_NAME=c.TABLE_NAME
AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA
AND constraint_name=’PRIMARY’)
WHERE t.table_schema!=”information_schema”
AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA;
select CONCAT(t.table_name,”.”,t.table_schema) as tbl,
c.column_name,c.constraint_name
from TABLES AS t LEFT JOIN […]

Web Crawling 1.0

In Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions:
. . . just how poorly the big search engines index small sites with large collections of data . . .
But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do […]

8 for 2008

Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..
Eight things about me that aren’t common knowledge:

I like to start lists with 0. I stole that idea from a friend of mine, who is not a computer geek…completely.
I’m more of a “problem solver” engineer […]

Source Controlling the Database Schema

In a linkage of biblical proportions, Log Buffer #83 pointed me to Tom Kyte’s reiteration which pointed me to Coding Horror’s rant about source controlling the database schema.
Now, for starters, I agree with Tom’s sarcasm and Coding Horror’s rant — the database schema really should be source controlled in the same place as the application […]

The Value of Vendor-Neutral Database Certification

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. Now, the specifics of how a query optimizer handles queries, how backups, restores and security are done and with MySQL specifically, how different storage engines act are […]

What Applications Are Good For MySQL Cluster?

Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an […]

Special Interview with Brian Aker of MySQL

Play or download the podcast here: http://technocation.org/content/oursql-episode-24%3A-sun-shining
OurSQL Episode 24: “The Sun is Shining”
Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.
Tell us what you think of Sun buying MySQL by calling the […]

OurSQL Episode 24: The Sun is Shining

Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.

Tell us what you think of Sun buying MySQL by calling the comment line or sending your voice through Odeo!

Links:
Register for the MySQL Users Conference Today!
www.mysqlconf.com

A special thank you to our sponsor, The Pythian Group, www.pythian.com.

Feedback:

Email podcast@technocation.org“>podcast@technocation.org

OurSQL Podcast Interviewing Brian Aker — What Are Your Questions?

At 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL.
If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment […]

OK, Now I Am a Bit Worried

SUN Microsystems just bought MySQL, see the announcement at http://www.sun.com/aboutsun/pr/2008-01/sunflash.20080116.1.xml
Now, MySQL isn’t going away any time soon; there are just way too many people that use it. And while Postgres is not actually owned by SUN, they do employ some great folks to develop on it, and those folks are the the “known” Postgres […]