Seems like having a random primary key like GUID affects database peformance.  See here and here for SQL Server and here for My SQL. Main reasons are: Affects physical row orders and as because of its randomness, it affects fragmentation and database size. Affects lookups for joins Key size: 4 bytes compared to 16 For example: I have a real [...]

Just downloaded and installed MySQL 5.1.  Found that the good old MySQL GUI Tools Bundle is now End of Life. So I downloaded MySQL Workbench 5.1 OSS (open source version). Couldn’t find SQL Browser and Server Administrator equivalents.  Doh! Should have RTFM. Need to download Workbench 5.2 or later. Tweet