• 23:59:59 is not the end of the day. No, really!

    July 27, 2011

    How would you check whether some TIMESTAMP column falls within a given day, say July 26th, 2011? This is a question I tend to ask students, and usually I get the same range of answers. Some are wrong; some cannot utilize an index, some are correct, and some are temporarily correct. I wish to take […]

  • common_schema: looking for contributions

    July 20, 2011

    In my announcement for common_schema I have failed to deliver the following message: I will be happy to receive contributions to common_schema, and I will be happy to have contributors on this project What kind of contributions are wanted? So, I'm mostly interested right now in: Views: providing more insight on metadata (data types, schemata, […]

  • Announcing common_schema: common views & routines for MySQL

    July 13, 2011

    Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server. What does it do? There are views answering for all sorts of useful information: stuff related to schema analysis, data dimensions, monitoring, processes & transactions, security, internals... There are […]

  • Useful sed / awk liners for MySQL

    July 6, 2011

    Listing some useful sed / awk liners to use with MySQL. I use these on occasion. sed, awk & grep have many overlapping features. Some simple tasks can be performed by either. For example, stripping empty lines can be performed by either: grep '.' awk '/./' sed '/./!d' grep -v '^$' awk '!/^$/' sed '/^$/d' […]

 
Powered by Wordpress and MySQL. Theme by openark.org