• Online ALTER TABLE now available in openark kit

    March 24, 2009

    A new utility in openark kit allows for online ALTER TABLE operation. That is, the modification of table structure without locking down the entire table for the duration of the operation. The oak-online-alter-table utility works under the following restrictions: The table has at least one single-column UNIQUE KEY [*] Altered table shares a single-column UNIQUE […]

  • LOCK TABLES in MyISAM is NOT a poor man's tranactions substitute

    March 18, 2009

    I get to hear that a lot: that LOCK TABLES with MyISAM is some sort of replacement for transactions; some model we can work with which gives us 'transactional flavor'. It isn't, and here's why. When we speak of a transactional database/engine, we check out its ACID compliance. Let's break out the ACID and see […]

  • Tales of the Trade #1: A day in the life of a MySQL instructor

    March 12, 2009
  • MySQL User Group Meetings in Israel

    March 11, 2009

    This is a short note that the MySQL User Group Meetings in Israel are established (well, re-established after a very long period). Thanks to Eddy Resnick from Sun Microsystems Israel who has set up the meetings. So far, we've had 2 successful meetings, and we intend to have more! First one was in Sun's offices […]

  • Blocking user accounts

    March 5, 2009

    A long time missing feature in MySQL is temporarily blocking accounts: denying a user to log in, without affecting any other of her privileges. There is no such privilege as 'LOGIN' in the grants table, as the ability to log in is the most basic one MySQL allows. This basic privilege is called USAGE. I'll […]

 
Powered by Wordpress and MySQL. Theme by openark.org