Blog
Where is the innovation?
The 2009 MySQL Conference has closed it’s submissions for papers. This year the motto is “Innovation Everywhere”. Last weekend’s Open SQL Camp in Charlottesville, Virginia, we had the chance to talk about the movements in the MySQL ecosystem.
Read moreWhen mysqldump –no-set-names matters
I had this perplexing problem yesterday where a mysql dump and restore was producing different results when using MaatKit mk-table-checksum. mk-table-checksum --algorithm=BIT_XOR h=192.168.X.XX,u=user,p=password --databases=db1 --tables=c DATABASE TABLE CHUNK HOST ENGINE COUNT CHECKSUM TIME WAIT STAT LAG db1 c 0 192.
Read moreORDER BY (the lesser known way)
We all know with MySQL you can use ORDER BY with a list of columns to return an ordered set, e.g. ORDER BY name, type, state; I often use the syntax ORDER BY 1,2; which I’m surprised that some people do not know about.
Read moreJavascript Helpers
Combined with my old favorites of Dynamic Drive , DHTML Goodies and Brain Jar , I’ve added the following to my list of Javascript sources. Mochikit JQuery
Read moreIt begins, the downfall of current Web 2.0 sites
The current US financial situation has claimed a victim in the Web 2.0 world — Uber . I’m not sure if this is the first significant name, but it will not be the last site running MySQL where investors will be quick to cut losses and move on.
Read moreImproving your web site compatibility with browsers
Every website page content uses two basic elements, HyperText Markup Language (HTML) and Cascading Style Sheets (CSS) . Each of these has various standards, HTML has versions such as 3.2, 4.
Read moreSelecting wise indexes
Indexes are a great way to improve performed in a MySQL database, when used appropriately. When used in-appropriately the impact can be a degradation of performance. The following example from Movable Type shows how when reviewing the slow query log I found numerous occurrences of Inserts take 3 or more seconds, with no reported lock contention time for this insert.
Read moreBrand identity with undesirable domain names
Choosing a domain name for your brand identity is the start. Protecting your domain name by registering for example .net, .org, and the many more extensions is one step in brand identity.
Read moreWhy you do not use GRANT ALL ON .?
Why you do not use GRANT ALL ON *.*? I was with a client today, and after rebooting a MySQL 5.0.22 instance cleanly with /etc/init.d/mysqld service, I observed the following error, because you always check the log file after starting MySQL.
Read moreTo www or not www
Domain names historically have been www.example.com , written also with the protocol prefix http://www.example.com , but in reality www. is optional, only example.com is actually needed. www. is technically a sub-domain and sub-domains incur a small penalty in search engine optimization.
Read morePatience and Passion at Web 2.0 NY
Gary Vaynerchuk spoke next at Web 2.0 NY on Building Personal Brand Within the Social Media Landscape . He was hilarious. His video presentation is available online , to share with others.
Read moreIntegrity, clarity and responsibility – Web 2.0 NY Keynote
Next on the Web 2.0 keynote speaker list was Maria Thomas of www.etsy.com with her talk The DIY Guide to Growing a Company . If never heard of Etsy before – Your place to buy & sell all things handmade, interesting site.
Read moreWhat if software was a physical object – NY Web 2.0 Third Keynote
Some points of reference from the next Web 2.0 keynote by Jason Fried of 37 Signals Software business is a great place to be. You can build anything you want. All you really have to it type, it’s not easy to do, it’s just not that hard to do.
Read moreTechnology changes, humans don’t. – Web 2.0 NY Second keynote
I needed a rest from my opening keynote review NY Tech 1995-2008. Opening Web 2.0 Expo NY Keynote but a few siginificant points from The Death of the Grand Gesture by Deb Schultz.
Read more