[Jeffry]

Hello guys,

Is it possible that ~17000 .sav files (User Files of LAdmin) cause TimeOuts?
Here is a entry of the connection traffic:

Код:

[9.7.2010 14:12:20] Timeouts: 35   |   Leaving: 61   |   Banned: 4  |  Traffic: -24 Players  || Total Connects: 3182
[9.7.2010 14:51:36] Timeouts: 45   |   Leaving: 50   |   Banned: 5  |  Traffic: 45 Players  || Total Connects: 145
[9.7.2010 15:30:44] Timeouts: 52   |   Leaving: 45   |   Banned: 3  |  Traffic: -5 Players  || Total Connects: 240
[9.7.2010 16:7:19] Timeouts: 42   |   Leaving: 49   |   Banned: 9  |  Traffic: -3 Players  || Total Connects: 337
[9.7.2010 16:53:38] Timeouts: 44   |   Leaving: 53   |   Banned: 3  |  Traffic: 38 Players  || Total Connects: 138
[9.7.2010 17:35:56] Timeouts: 43   |   Leaving: 50   |   Banned: 7  |  Traffic: -2 Players  || Total Connects: 236
[9.7.2010 18:8:5] Timeouts: 50   |   Leaving: 43   |   Banned: 7  |  Traffic: -4 Players  || Total Connects: 332
[9.7.2010 18:42:48] Timeouts: 36   |   Leaving: 60   |   Banned: 4  |  Traffic: 4 Players  || Total Connects: 436
[9.7.2010 19:22:33] Timeouts: 51   |   Leaving: 46   |   Banned: 3  |  Traffic: 13 Players  || Total Connects: 549
[9.7.2010 19:52:24] Timeouts: 43   |   Leaving: 46   |   Banned: 11  |  Traffic: 1 Players  || Total Connects: 650
[9.7.2010 20:21:36] Timeouts: 39   |   Leaving: 52   |   Banned: 9  |  Traffic: -8 Players  || Total Connects: 742
[9.7.2010 20:49:30] Timeouts: 30   |   Leaving: 62   |   Banned: 8  |  Traffic: -1 Players  || Total Connects: 841
[9.7.2010 21:32:4] Timeouts: 49   |   Leaving: 42   |   Banned: 9  |  Traffic: 5 Players  || Total Connects: 946
[9.7.2010 22:12:26] Timeouts: 44   |   Leaving: 54   |   Banned: 2  |  Traffic: 0 Players  || Total Connects: 1046
[9.7.2010 22:50:33] Timeouts: 39   |   Leaving: 57   |   Banned: 4  |  Traffic: -17 Players  || Total Connects: 1129
[9.7.2010 23:38:1] Timeouts: 43   |   Leaving: 47   |   Banned: 10  |  Traffic: 1 Players  || Total Connects: 1230
[10.7.2010 0:37:46] Timeouts: 44   |   Leaving: 53   |   Banned: 3  |  Traffic: -1 Players  || Total Connects: 1329
[10.7.2010 1:35:59] Timeouts: 37   |   Leaving: 59   |   Banned: 4  |  Traffic: 17 Players  || Total Connects: 1446
[10.7.2010 2:14:42] Timeouts: 33   |   Leaving: 61   |   Banned: 6  |  Traffic: -11 Players  || Total Connects: 1535
[10.7.2010 3:5:52] Timeouts: 44   |   Leaving: 51   |   Banned: 5  |  Traffic: 10 Players  || Total Connects: 1645
[10.7.2010 3:48:10] Timeouts: 40   |   Leaving: 56   |   Banned: 4  |  Traffic: -18 Players  || Total Connects: 1727
[10.7.2010 5:5:1] Timeouts: 47   |   Leaving: 44   |   Banned: 9  |  Traffic: 21 Players  || Total Connects: 121
[10.7.2010 6:19:36] Timeouts: 41   |   Leaving: 56   |   Banned: 3  |  Traffic: -5 Players  || Total Connects: 216
[10.7.2010 7:26:45] Timeouts: 39   |   Leaving: 55   |   Banned: 6  |  Traffic: 2 Players  || Total Connects: 318
[10.7.2010 8:42:7] Timeouts: 58   |   Leaving: 36   |   Banned: 6  |  Traffic: 3 Players  || Total Connects: 421
[10.7.2010 9:40:42] Timeouts: 46   |   Leaving: 51   |   Banned: 3  |  Traffic: 2 Players  || Total Connects: 523
[10.7.2010 10:29:4] Timeouts: 55   |   Leaving: 41   |   Banned: 4  |  Traffic: 9 Players  || Total Connects: 632
[10.7.2010 11:16:34] Timeouts: 60   |   Leaving: 38   |   Banned: 2  |  Traffic: 4 Players  || Total Connects: 736
[10.7.2010 12:5:5] Timeouts: 41   |   Leaving: 58   |   Banned: 1  |  Traffic: -6 Players  || Total Connects: 830
[10.7.2010 12:41:59] Timeouts: 38   |   Leaving: 57   |   Banned: 5  |  Traffic: 8 Players  || Total Connects: 938
[10.7.2010 13:23:22] Timeouts: 39   |   Leaving: 51   |   Banned: 10  |  Traffic: -5 Players  || Total Connects: 1033
[10.7.2010 14:5:1] Timeouts: 48   |   Leaving: 47   |   Banned: 5  |  Traffic: 11 Players  || Total Connects: 1144
[10.7.2010 14:34:32] Timeouts: 46   |   Leaving: 51   |   Banned: 3  |  Traffic: -1 Players  || Total Connects: 1243
[10.7.2010 15:12:48] Timeouts: 32   |   Leaving: 68   |   Banned: 0  |  Traffic: 6 Players  || Total Connects: 1349
[10.7.2010 15:51:59] Timeouts: 39   |   Leaving: 51   |   Banned: 10  |  Traffic: 2 Players  || Total Connects: 1451
[10.7.2010 16:26:51] Timeouts: 41   |   Leaving: 51   |   Banned: 8  |  Traffic: 0 Players  || Total Connects: 1551
[10.7.2010 16:55:41] Timeouts: 40   |   Leaving: 51   |   Banned: 9  |  Traffic: 2 Players  || Total Connects: 1653
[10.7.2010 17:36:7] Timeouts: 48   |   Leaving: 45   |   Banned: 7  |  Traffic: 35 Players  || Total Connects: 135
[10.7.2010 18:9:24] Timeouts: 45   |   Leaving: 48   |   Banned: 7  |  Traffic: 5 Players  || Total Connects: 240
[10.7.2010 18:36:31] Timeouts: 44   |   Leaving: 41   |   Banned: 15  |  Traffic: -1 Players  || Total Connects: 339
[10.7.2010 19:14:36] Timeouts: 48   |   Leaving: 47   |   Banned: 5  |  Traffic: -9 Players  || Total Connects: 430
[10.7.2010 19:43:17] Timeouts: 57   |   Leaving: 41   |   Banned: 2  |  Traffic: -4 Players  || Total Connects: 526
[10.7.2010 20:15:44] Timeouts: 56   |   Leaving: 38   |   Banned: 6  |  Traffic: 9 Players  || Total Connects: 635
[10.7.2010 20:38:26] Timeouts: 52   |   Leaving: 48   |   Banned: 0  |  Traffic: 12 Players  || Total Connects: 747
[10.7.2010 21:0:13] Timeouts: 45   |   Leaving: 49   |   Banned: 6  |  Traffic: 0 Players  || Total Connects: 847
[10.7.2010 21:36:37] Timeouts: 45   |   Leaving: 47   |   Banned: 8  |  Traffic: 4 Players  || Total Connects: 951
[10.7.2010 22:3:10] Timeouts: 42   |   Leaving: 55   |   Banned: 3  |  Traffic: -9 Players  || Total Connects: 1042
[10.7.2010 22:31:5] Timeouts: 37   |   Leaving: 53   |   Banned: 10  |  Traffic: -7 Players  || Total Connects: 1135
[10.7.2010 22:59:33] Timeouts: 40   |   Leaving: 47   |   Banned: 13  |  Traffic: -3 Players  || Total Connects: 1232
[10.7.2010 23:30:34] Timeouts: 34   |   Leaving: 61   |   Banned: 5  |  Traffic: 17 Players  || Total Connects: 1349
[11.7.2010 0:1:55] Timeouts: 37   |   Leaving: 60   |   Banned: 3  |  Traffic: -1 Players  || Total Connects: 1448
[11.7.2010 0:28:31] Timeouts: 41   |   Leaving: 53   |   Banned: 6  |  Traffic: -8 Players  || Total Connects: 1540
[11.7.2010 0:49:19] Timeouts: 47   |   Leaving: 52   |   Banned: 1  |  Traffic: -38 Players  || Total Connects: 1602
[11.7.2010 1:32:20] Timeouts: 46   |   Leaving: 47   |   Banned: 7  |  Traffic: 34 Players  || Total Connects: 134
[11.7.2010 2:23:55] Timeouts: 32   |   Leaving: 57   |   Banned: 11  |  Traffic: -8 Players  || Total Connects: 226
[11.7.2010 3:2:16] Timeouts: 43   |   Leaving: 50   |   Banned: 7  |  Traffic: -26 Players  || Total Connects: 300
[11.7.2010 4:46:44] Timeouts: 48   |   Leaving: 46   |   Banned: 6  |  Traffic: 28 Players  || Total Connects: 128
[11.7.2010 5:49:6] Timeouts: 54   |   Leaving: 43   |   Banned: 3  |  Traffic: -6 Players  || Total Connects: 222
[11.7.2010 6:45:57] Timeouts: 45   |   Leaving: 52   |   Banned: 3  |  Traffic: 6 Players  || Total Connects: 328
[11.7.2010 7:52:36] Timeouts: 44   |   Leaving: 51   |   Banned: 5  |  Traffic: -12 Players  || Total Connects: 416
[11.7.2010 9:2:43] Timeouts: 51   |   Leaving: 46   |   Banned: 3  |  Traffic: 3 Players  || Total Connects: 519
[11.7.2010 10:16:18] Timeouts: 37   |   Leaving: 60   |   Banned: 3  |  Traffic: 11 Players  || Total Connects: 630
[11.7.2010 11:5:11] Timeouts: 39   |   Leaving: 55   |   Banned: 6  |  Traffic: 18 Players  || Total Connects: 748
[11.7.2010 11:40:48] Timeouts: 40   |   Leaving: 52   |   Banned: 8  |  Traffic: -10 Players  || Total Connects: 838
[11.7.2010 12:16:4] Timeouts: 57   |   Leaving: 40   |   Banned: 3  |  Traffic: 8 Players  || Total Connects: 946
[11.7.2010 12:48:3] Timeouts: 45   |   Leaving: 50   |   Banned: 5  |  Traffic: 2 Players  || Total Connects: 1048
[11.7.2010 13:19:40] Timeouts: 41   |   Leaving: 51   |   Banned: 8  |  Traffic: -9 Players  || Total Connects: 1139
[11.7.2010 13:50:29] Timeouts: 41   |   Leaving: 54   |   Banned: 5  |  Traffic: 4 Players  || Total Connects: 1243

Can anyone help me with this?

PS: Server is at Hosted List + Hosted for 24/7 running, so no home-host.

[Sergei]

17k files? Uh that must be slow, so yeah possible causes timeout because operation takes longer than timeout time. Think about using MySQL instead of files.

[zallomallo]

It's possible, after a certain point it's good to switch to MySQL for increased speed and stuff.

[Jeffry]

I think I've to learn MySQL over Summer Holidays then.
But I first give it a try to delete all the user file (With Backup of course) and then check if timeouts are still there.

Can it also be a script mistake?

[Sergei]

If it hasn't been crashing since always, then it's not script mistake.

[Jeffry]

Well, I putted a backup from 26.4. and it was still there. But I can't remeber that the TimeOuts where so many this time. Today I added a script backup of 27.1. () and there are ~70 players on. O.o

*Jeffry is confused.

[Gforcez]

I Want to learn MySQL Too,
Maybe some of you guys have Good tutorials ?

[Jeffry]

Any more ideas? Or comments?

Would help me alot.

[dice7]

Quote:

Originally Posted by Sergei 17k files? Uh that must be slow, so yeah possible causes timeout because operation takes longer than timeout time. Think about using MySQL instead of files.

Please do not post if you do not know. You can have 34 gigs of user files on your computer and nobody will time out, because when a user connects, IT DOESN'T SCAN the whole server for his user file, it just checks if there is one matching his name.

[Jeffry]

Quote:

Originally Posted by dice7 Please do not post if you do not know. You can have 34 gigs of user files on your computer and nobody will time out, because when a user connects, IT DOESN'T SCAN the whole server for his user file, it just checks if there is one matching his name.

So I can re-add my 17k files again?