• MySQL security top wish list

    August 29, 2013

    Security seems to have no boundaries. I've been tightening our database security lately, and it seems like this could go on forever: from app to console to privileges to server, there are so many aspects to managing database security. Unfortunately, this is a field where MySQL is in particular weak, and with very little work […]

  • Trick: recovering from "no space left on device" issues with MySQL

    August 23, 2013

    Just read Ronald Bradford's post on an unnecessary 3am (emergency) call. I sympathize! Running out of disk space makes for some weird MySQL behaviour, and in fact whenever I encounter weird behaviour I verify disk space. But here's a trick I've been using for years to avoid such cases and to be able to recover […]

  • common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params

    August 13, 2013

    common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality. Highlights of the 2.2 release: Better QueryScript isolation & cleanup: isolation improved across replication topology, cleanup done even on error Added TokuDB related views split with […]

  • Tool of the day: q

    August 8, 2013

    If you work with command line and know your SQL, q is a great tool to use: q allows you to query your text files or standard input with SQL. You can: SELECT c1, COUNT(*) FROM /home/shlomi/tmp/my_file.csv GROUP BY c1 And you can: SELECT all.c2 FROM /tmp/all_engines.txt AS all LEFT JOIN /tmp/innodb_engines.txt AS inno USING […]

 
Powered by Wordpress and MySQL. Theme by openark.org