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 […]
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 […]
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 […]
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 […]