I'm using a couple of myisam tables for search operations cause they have a much better performance than innodb tables. Those tables are getting updated every night at 3 o clock by a cronjob.
Now my question:
It is a kind of stupid work to lock all of those tables and some of them several times with aliases. I would prefer to lock the whole database for that time as it is only some seconds and it's in the middle of the night. Do you know something like "lock database foo write"?