10 Sep
2004
10 Sep
'04
3:23 a.m.
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/
10 Sep
10 Sep
8:32 a.m.
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7428
days inactive
7428
days old
1 comments
2 participants
participants (2)
-
Gerhard Zweimueller -
Jan Janak