SQL Language Guide : 7. Database Procedures, Sessions, and Events : Multiple Session Connections : What You Should Know When Creating Multiple Sessions
 
Share this page                  
What You Should Know When Creating Multiple Sessions
The DBMS Server treats each session in a multiple-session application as an individual application. When creating multiple-session applications, keep the following points in mind:
Be sure that the server parameter connect_limit is large enough to accommodate the number of sessions required by the application.
An application can encounter deadlock against itself. For example, one session may attempt to update a table that was locked by another session.
An application can also lock itself out in an undetectable manner. For example, if a table is updated in a transaction in one session and selected from in another transaction in a second session, the second session waits indefinitely.