lunatechian (lunatech-ian)

If you use mysql's innodb table engine, you might find it useful to add the innodb_file_per_table option to your my.cnf file (under the [mysqld] section). This will create each innodb table in its own file/tablespace instead of putting everything in the ibdata file, thus making it easier for you to run optimize table faster. However, this option only affects new tables. Old tables would still live in the shared ibdata file.

Links: mySQL DBA has some further observations about this option and this is the mysql's manual page about this issue.

My dear friends,

I know you love me and wish me well. I know Orkut has this feature where you can mail all your friends in one click, but if you really consider me such a special friend, do take some time out to send me a separate email. Or better still, give me a call. If you cannot be bothered enough to do this much for your friends, please don't flood their mail boxes with generic greetings. No one reads them, and you really should not bother sending such emails. If you feel like you are doing a disservice to your friends by not sending them even generic greetings, trust me, no one really cares.

Thanks for reading till the end,
Your grumpy friend,
raj shekhar

PS: I will still love you even if you don't send me an email greeting.