locking all tables

[godisatheist]

Hi,

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"?

Greetings, Andreas

[Nick]

It seems like the flush command will lock the entire database. Not sure if that is the best way to do this though, but it is mentioned in the MySQL doc

[longneck]

if you only need it for a few seconds, then you probably don't need the locks at all.

why do you think you need the locks?