Multi Level Transaction (InnoDB)

Just wondor how InnoDB handle Multi Level Transaction, For example, BEGIN DELETE FORM table1 WHERE id = 123 BEGIN< New Transaction Level 2 DELETE FROM table1 WHERE id = 234 COMMIT <--- Level2 ROLLBACK <---Level1 Thanks.

Slow Connection to MySql 4 Host

My MySql4.1 run on RH Linux 9. I found when I coonect to MySql Host, it take so long. How to fine tune it. Thanks.