• SQL: forcing single row tables integrity

    June 22, 2010

    Single row tables are used in various cases. Such tables can be used for "preferences" or "settings"; for managing counters (e.g. summary tables), for general-purpose administration tasks (e.g. heartbeat table) etc. The problem with single row tables is that, well, they must have s single row. And the question is: how can you force them […]

  • Personal observation: more migrations from MyISAM to InnoDB

    June 16, 2010

    I'm evidencing an increase in the planning, confidence & execution for MyISAM to InnoDB migration. How much can a single consultant observe? I agree Oracle should not go to PR based on my experience. But I find that: More companies are now familiar with InnoDB than there used to. More companies are interested in migration […]

  • Verifying GROUP_CONCAT limit without using variables

    June 10, 2010

    I have a case where I must know if group_concat_max_len is at its default value (1024), which means there are some operation I cannot work out. I've ranted on this here. Normally, I would simply: However, I am using views, where session variables are not allowed. Using a stored function can do the trick, but […]

  • Those oversized, undersized variables defaults

    June 9, 2010

    Some mysqld parameters are far from having reasonable defaults. Most notable are the engine-specific values, and in particular the InnoDB parameters. Some of these variables have different defaults as of MySQL 5.4. innodb_buffer_pool_size, for example, is 128M on 5.4. innodb_log_file_size, however, has changed back and forth, as far as I understand, and is down to […]

  • mycheckpoint (rev. 132): custom monitoring, custom charts, process list dump

    June 4, 2010

    Revision 132 of mycheckpoint has been released. New and updated in this revision: Custom monitoring: monitoring & charting for user defined queries HTML reports for custom monitoring Process list dump upon alert notifications Custom monitoring & charts Custom monitoring allows the user to supply with a query, the results of which will be monitored. That […]

  • Choosing MySQL boolean data types

    June 3, 2010

    How do you implement True/False columns? There are many ways to do it, each with its own pros and cons. ENUM Create you column as ENUM('F', 'T'), or ENUM('N','Y') or ENUM('0', '1'). This is the method used in the mysql tables (e.g. mysql.user privileges table). It's very simple and intuitive. It truly restricts the values […]

Powered by Wordpress and MySQL. Theme by openark.org