Is it possible...? - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Is it possible...? (/showthread.php?tid=158906)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Is it possible...? (/showthread.php?tid=158906)
Is it possible...? - Jeffry - 11.07.2010
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
PS: Server is at Hosted List + Hosted for 24/7 running, so no home-host.
Re: Is it possible...? - Sergei - 11.07.2010
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.
Re: Is it possible...? - zallomallo - 11.07.2010
It's possible, after a certain point it's good to switch to MySQL for increased speed and stuff.
Re: Is it possible...? - Jeffry - 11.07.2010
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?
Re: Is it possible...? - Sergei - 11.07.2010
If it hasn't been crashing since always, then it's not script mistake.
Re: Is it possible...? - Jeffry - 11.07.2010
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.
Re: Is it possible...? - Gforcez - 11.07.2010
I Want to learn MySQL Too,
Maybe some of you guys have Good tutorials ?
Re: Is it possible...? - Jeffry - 16.07.2010
Any more ideas? Or comments?
Would help me alot.
Re: Is it possible...? - dice7 - 16.07.2010
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.
|
Re: Is it possible...? - Jeffry - 16.07.2010
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.
|