Hi list,
the subject says it all:
What happens to the state of ser, when I briefly write-lock the attached MySQL-database to make a file-copy. Briefly meaning 0.5 to 2 seconds.
Are requests simply delayed or can serious errors occur?
Thanks, Gerhard
__________________________________________________________________________________ Dieses Mail wurde vom Infotech SecureMail Service ueberprueft und fuer sicher befunden. Fuer weitere Informationen zu Infotech SecureMail Service waehlen Sie bitte: www.infotech.at/securemail/
This email has been scanned by Infotech SecureMail Service and it has been classified as secure. For more information on Infotech SecureMail direct your web browser to: www.infotech.at/securemail/
It depends on the configuration of your server. SER writes data into acc and location tables. If you write accounting data into MySQL then the process writing the data will block, other processes will continue running unless they try to write accounting data too.
Regarding usrloc module (writing into location table) I recommend you to set db_mode to 2. In this mode writes to mysql database will be delayed and performed periodically by timer. If you lock the database often then make sure you set timer_interval of usrloc module to some higher value.
Jan.
On 10-09 09:23, Gerhard Zweimueller wrote:
Hi list,
the subject says it all:
What happens to the state of ser, when I briefly write-lock the attached MySQL-database to make a file-copy. Briefly meaning 0.5 to 2 seconds.
Are requests simply delayed or can serious errors occur?
Thanks, Gerhard
Dieses Mail wurde vom Infotech SecureMail Service ueberprueft und fuer sicher befunden. Fuer weitere Informationen zu Infotech SecureMail Service waehlen Sie bitte: www.infotech.at/securemail/
This email has been scanned by Infotech SecureMail Service and it has been classified as secure. For more information on Infotech SecureMail direct your web browser to: www.infotech.at/securemail/
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers