I would be very surprised if you found a database where the last_insert_id is not session specific. That is you always get YOUR last inserted id. You can test it by a script that'd make two connections, insert one row by each connection and then looked at the last_insert_id() for each connection.