Sounds like a concurrency problem to me. Is your code ACID (Atomicity, Concurrency, Isolation, Durability) safe?

I do not think it is a "commit" problem. For one, because PHP/Perl client interfaces almost always default to auto-commit (so you would have to have disabled it explicitely); and, for two, because, as long as your MySQL server still runs, the data is transparently present (whether physically saved to disk or not).

I take it by "link" you mean something which describes your database:user:password, etc? Please, show the error. And you are not sharing the same database handle for multiple connection, btw, right?

System Administrator Asarian-host.org