It's innodb_data_file_path that fills me with hate. Say, you want to keep your datafiles under 2 gigs. Maybe you're worried about the occasional filesystem bug, or maybe you just want to keep things more manageable. Conveniently, there's a max size option. Unfortunatly, there's no way to tell it to start a new file when the old one is full.
Which means, you can either get one monster file, or deal with strange errors when mysql runs out of space periodicly. Such a hateful database. seph
