ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by XpKiller*: The queries get slower because you DB has more entries. I didn't changed any indexes. Please post the query which is slow. An other reason could be that your innodb is not optimized well. E.g. bufferpool too small. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by ty_ger07*: The queries get slower because you DB has more entries.The number of players in the DB has only increased from 20k to 22k. I didn't think it would have such a crippling affect. I didn't changed any indexes. Please post the query which is slow.These slowed down the most: Code: SELECT tps.StatsID, tpd.CountryCode, tpd.SoldierName, tpd.PBGUID, tps.Suicide, tps.FirstSeenOnServer, tps.LastSeenOnServer, tps.Score, tps.Kills, tps.Deaths, tps.Suicide, tps.TKs, tps.Playtime, tps.Headshots, tps.Rounds, tps.Killstreak, tps.Deathstreak FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '{$server_ID}' AND SoldierName = '{$player_name}'Code: SELECT tpd.SoldierName, tpd.PBGUID, tps.Kills, tps.Deaths, tps.Headshots, tps.Rounds, (tps.Headshots/(tps.Kills+0.0001)) AS HSratio FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 2.0 AND (tps.Headshots/(tps.Kills+0.0001)) > 0.65 AND tps.Kills > 20 AND tps.Rounds > 1) OR (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 5.0 AND tps.Kills > 30 AND tps.Rounds > 1) OR (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 1.0 AND (tps.Headshots/(tps.Kills+0.0001)) > 0.75 AND tps.Rounds > 1 AND tps.Kills > 15) ORDER BY HSratio DESCPerhaps my server host has just throttled its services instead due to heavy use. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by EBassie*: XpKiller, since R21 we now see the chat 'logsubset' in Procon. (Playername - Attackers - Alpha Squad > Message) Will you be updating the chatlogger to add this info? Is it also possible to log the YELLS? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by ty_ger07*: Nevermind XpKiller, I found out why my stats pages slowed way down. GGC-Stream started slowing down their rate of reply. I don't know if it is because they are under heavier load then normal or if they have changed something, but now, the exact same page takes about 5 seconds per each GGC-Stream query response compared to less than a second before. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by XpKiller*: that sounds like the reason because 2k players should make such a difference. @EBastard must take a look at it. anyway im looking to release a new version friday. Vetula has test my beta so i was able to sort out the most issues. must look if any changes are need due R21. Also i was busy because of metabans. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by EBassie*: that sounds like the reason because 2k players should make such a difference. @EBastard must take a look at it. anyway im looking to release a new version friday. Vetula has test my beta so i was able to sort out the most issues. must look if any changes are need due R21. Also i was busy because of metabans. Yeah I noticed. Nice job on that one! BTW: these were just thought / suggestions... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 19, 2012 Author Share Posted April 19, 2012 Originally Posted by Athlon*: Nevermind XpKiller, I found out why my stats pages slowed way down. GGC-Stream started slowing down their rate of reply. I don't know if it is because they are under heavier load then normal or if they have changed something, but now, the exact same page takes about 5 seconds per each GGC-Stream query response compared to less than a second before. ty_ger07, I wonder if GGC's activity has gone way up because of the recent DDoS attacks on PBBans. Many servers are not streaming Punkbuster as a result. I hope GGC is not under attack too. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 20, 2012 Author Share Posted April 20, 2012 Originally Posted by TankCeo*: Can some one help me set this up please? I don't have a MYSQL server. I do have MYSQL software though. Some one please help me! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 20, 2012 Author Share Posted April 20, 2012 Originally Posted by ammoniak007*: @XpKiller , Very thx fo you help , you PV messages @ty_ger07 , Very thx fo you "script" http://ascendance.verygames.net/stat...5_players=View Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 21, 2012 Author Share Posted April 21, 2012 Originally Posted by Athlon*: Can some one help me set this up please? I don't have a MYSQL server. I do have MYSQL software though. Some one please help me! www.phogue.net/forumvb/showth...-Configuration* Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 21, 2012 Author Share Posted April 21, 2012 Originally Posted by cc*: The only 4 tables receiving any information are the following: tbl_chatlog, tbl_mapstats, tbl_playerdata, tbl_playerrank The other 17 remain empty. What could be the problem? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 21, 2012 Author Share Posted April 21, 2012 Originally Posted by XpKiller*: pls post you plugin settings Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 21, 2012 Author Share Posted April 21, 2012 Originally Posted by cc*: Code: procon.protected.plugins.enable "CChatGUIDStatsLoggerBF3" True "Close Connection after each request_" "No" "High performance mode(no connection limit!)" "Off" "Enable Chatlogging_" "Yes" "Log ServerSPAM_" "No" "Instant Logging of Chat Messages_" "Yes" "Enable chatlog filter(Regex)_" "No" "Enable Statslogging_" "Yes" "Ranking by Score_" "Yes" "Enable ingame commands_" "Yes" "Overall ranking(merged Serverranking)" "Yes" "Server group (0 - 128)" "0" "Send Stats to all Players_" "No" "PlayerMessage" "Serverstats for %playerName%:|Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%|Your Serverrank is: %playerRank% of %allRanks%" "Weaponstats Message" "[yell,2]%playerName%'s Stats for %Weapon%:|[yell,3]%playerKills% Kills %playerHeadshots% Headshots Headshotrate: %playerKHR%% %playerDeaths% died by this Weapon|[yell,3]Your Weaponrank is: %playerRank% of %allRanks%" "Serverstats Message" "[yell,2]Serverstatistics for server %serverName%|[yell,3]Unique Players: %countPlayer% Totalplaytime: %sumPlaytime%|[yell,3]Totalscore: %sumScore% Avg. Score: %avgScore% Avg. SPM: %avgSPM%|[yell,3]Totalkills: %sumKills% Avg. Kills: %avgKills% Avg. KPM: %avgKPM%" "Awards ON_" "No" "Enable Welcomestats_" "No" "Yell Welcome Message(not the stats)_" "No" "Welcome Message" "Nice to see you on our Server again, %playerName%" "Welcome Message for new Player" "Welcome to the %serverName% Server, %playerName%" "Welcomestats Delay" "60" "Top10 ingame" "No" "Top10 header line" "[yell,2]Top 10 Player of the %serverName% Server" "Top10 row format" "[yell,2]%Rank%. %playerName% Score: %playerScore% %playerKills% Kills %playerHeadshots% Headshots %playerDeaths% Deaths KDR: %playerKDR%" "WeaponTop10 header line" "[yell,2]Top 10 Player with %Weapon% of the %serverName%" "WeaponTop10 row format" "[yell,2]%Rank%. %playerName% %playerKills% Kills %playerHeadshots% Headshots %playerDeaths% deaths by this Weapon Headshotrate: %playerKHR%%" "DebugLevel" "Error" "Keywordlist" "" "tableSuffix" "" "MapStats ON_" "Yes" "Session ON_" "Yes" "SessionMessage" "%playerName%'s Session Data Session started %SessionStarted%|Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%|Your Rank: %playerRank% (%RankDif%) Sessionlength: %SessionDuration% Minutes" "Save Sessiondata to DB_" "Yes" "Playerrequests per Round" "10" "Servertime Offset" "0" "Periodical Webrequest On_(P&S Stats)" "Yes" "Webaddress" "" "Webrequest Intervall" "60" Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 21, 2012 Author Share Posted April 21, 2012 Originally Posted by XpKiller*: @-cc- settings logs ok it should be working Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 22, 2012 Author Share Posted April 22, 2012 Originally Posted by cc*: I have no idea then, the chat table is getting updated no problem, all the weapon tables are completely empty. Thanks anyway. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 22, 2012 Author Share Posted April 22, 2012 Originally Posted by XpKiller*: you could check if your bf3.def is up to date. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 22, 2012 Author Share Posted April 22, 2012 Originally Posted by XpKiller*: Finally new Version 1.0.0.5! Changelog: Optimzed some transactions Added locktimeout and deadlock detection and handling this should solve those lock/deadlock errors which some user have. fixed bug with the yell command fixed a broken query changed welcomestats a bit Note: Welcomestats are now customizable like the playerstats Messages Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 23, 2012 Author Share Posted April 23, 2012 Originally Posted by Polak*: Im having some error codes. Code: procon.protected.plugins.enable "CChatGUIDStatsLoggerBF3" True procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Close Connection after each request_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "High performance mode(no connection limit!)" "On" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Failed Transaction retry attempts" "3" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Chatlogging_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Log ServerSPAM_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Instant Logging of Chat Messages_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable chatlog filter(Regex)_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Statslogging_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Ranking by Score_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable ingame commands_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Overall ranking(merged Serverranking)" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Server group (0 - 128)" "0" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Send Stats to all Players_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "PlayerMessage" "[yell,2]Serverstats for %playerName%:|[yell,3]Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Serverrank is: %playerRank% of %allRanks%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Weaponstats Message" "[yell,2]%playerName%'s Stats for %Weapon%:|[yell,3]%playerKills% Kills %playerHeadshots% Headshots Headshotrate: %playerKHR%% %playerDeaths% died by this Weapon|[yell,3]Your Weaponrank is: %playerRank% of %allRanks%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Serverstats Message" "[yell,2]Serverstatistics for server %serverName%|[yell,3]Unique Players: %countPlayer% Totalplaytime: %sumPlaytime%|[yell,3]Totalscore: %sumScore% Avg. Score: %avgScore% Avg. SPM: %avgSPM%|[yell,3]Totalkills: %sumKills% Avg. Kills: %avgKills% Avg. KPM: %avgKPM%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Awards ON_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Welcomestats_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Yell Welcome Message(not the stats)_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message" "[yell,3]Nice to see you on our Server again, %playerName%|[yell,2]Serverstats for %playerName%:|[yell,3]Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Serverrank is: %playerRank% of %allRanks%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message for new Player" "[yell,3]Welcome to the %serverName% Server, %playerName%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcomestats Delay" "5" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 ingame" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 header line" "[yell,2]Top 10 Player of the %serverName% Server" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 row format" "[yell,2]%Rank%. %playerName% Score: %playerScore% %playerKills% Kills %playerHeadshots% Headshots %playerDeaths% Deaths KDR: %playerKDR%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "WeaponTop10 header line" "[yell,2]Top 10 Player with %Weapon% of the %serverName%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "WeaponTop10 row format" "[yell,2]%Rank%. %playerName% %playerKills% Kills %playerHeadshots% Headshots %playerDeaths% deaths by this Weapon Headshotrate: %playerKHR%%" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "DebugLevel" "Info" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "RPG-7{RPG}|Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H,SCARH}|USAS-12{USAS12,USAS}|M27IAR{M27}|M16A4{M16,M16A3}|AEK-971{AEK971,AEK}|Weapons/A91/A91{A91,A-91}|Weapons/AK74M/AK74{AK74,AK74M,AK74-M}|Weapons/G36C/G36C{G36C,G36}|Weapons/G3A3/G3A3{G3A3,G3}|Weapons/Gadgets/C4/C4{C4,C-4}|Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}|Weapons/KH2002/KH2002{KH2002}|Weapons/Knife/Knife{KNIFE,MESSER}|Weapons/M416/M416{M416,M-416}|Weapons/MagpulPDR/MagpulPDR{MagpulPDR,PDR}|Weapons/MP412Rex/MP412REX{MP412REX,REX,MP412}|Weapons/MP443/MP443{MP443}|Taurus .44{.44,TAURUS,TAURUS.44}|Weapons/P90/P90{P90}|Weapons/Sa18IGLA/Sa18IGLA{Sa18IGLA,Sa18,IGLA}|Weapons/UMP45/UMP45{UMP,UMP-45,UMP45}|Weapons/XP1_L85A2/L85A2{L85A2,L85A,L85}|Glock18{GLOCK}" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "tableSuffix" "" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "MapStats ON_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Session ON_" "No" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "SessionMessage" "[yell,3]%playerName%'s Session Data Session started %SessionStarted%|[yell,3]Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Rank: %playerRank% (%RankDif%) Sessionlength: %SessionDuration% Minutes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Save Sessiondata to DB_" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Playerrequests per Round" "10" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Servertime Offset" "0" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Periodical Webrequest On_(P&S Stats)" "Yes" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Webaddress" "" procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Webrequest Intervall" "60"Code: [08:13:47 58] Error: Error in Startstreaming: System.InvalidOperationException: OdbcConnection does not support parallel transactions. at System.Data.Odbc.OdbcConnection.Open_BeginTransaction(IsolationLevel isolevel) at System.Data.Odbc.OdbcConnectionOpen.BeginTransaction(IsolationLevel isolevel) at System.Data.Odbc.OdbcConnection.BeginTransaction(IsolationLevel isolevel) at System.Data.Odbc.OdbcConnection.BeginTransaction() at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming() [08:13:47 86] Info: Connection OdbcConn closed [08:13:47 86] Error: Error in Startstreaming: System.InvalidOperationException: Invalid operation. The connection is closed. at System.Data.ProviderBase.DbConnectionClosed.BeginTransaction(IsolationLevel il) at System.Data.Odbc.OdbcConnection.BeginTransaction(IsolationLevel isolevel) at System.Data.Odbc.OdbcConnection.BeginTransaction() at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming() [08:13:52 02] Info: Streamingprocess duration: 7.578 seconds [08:13:52 25] Info: Streamingprocess duration: 6.641 seconds [08:13:52 25] Error: Error in Startstreaming OuterException: System.InvalidOperationException: This OdbcTransaction has completed; it is no longer usable. at System.Data.Odbc.OdbcTransaction.Rollback() at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming() Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 23, 2012 Author Share Posted April 23, 2012 Originally Posted by XpKiller*: Damn I missed a transaction rollback. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 23, 2012 Author Share Posted April 23, 2012 Originally Posted by Polak*: Damn I missed a transaction rollback.Can that cause an error in my statspage from RMG-Dr4k3 ? I'm having a little problem with it. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 23, 2012 Author Share Posted April 23, 2012 Originally Posted by XpKiller*: Can that cause an error in my statspage from RMG-Dr4k3 ? I'm having a little problem with it.No dont think so. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 24, 2012 Author Share Posted April 24, 2012 Originally Posted by XpKiller*: New version 1.0.0.6 Changelog: fixed an error which could cause that the streamingprocess could fail. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 24, 2012 Author Share Posted April 24, 2012 Originally Posted by Polak*: What's the size of the DB with.. i dont know what's the player limit, 1.500? and around 500 chat messages? Which would be the approximate size? My free DB host is tooooo slow... and I want to host it on my website but i dont know if i have enough space, I'm also worried about the data transfer Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 24, 2012 Author Share Posted April 24, 2012 Originally Posted by ty_ger07*: What's the size of the DB with.. i dont know what's the player limit, 1.500? and around 500 chat messages? Which would be the approximate size? My free DB host is tooooo slow... and I want to host it on my website but i dont know if i have enough space, I'm also worried about the data transfer My database has two servers in it and one month of chat messages. Between the two servers, there are about 45,000 players logged. My database size is 117 MB. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 24, 2012 Author Share Posted April 24, 2012 Originally Posted by HaNg_MaN*: 2 server, with 160000 player,no chatlog=300mb Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 25, 2012 Author Share Posted April 25, 2012 Originally Posted by Vetula*: 27 Servers With 255891 Player's No Chatlog -> No Mapstats 834 MB Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 25, 2012 Author Share Posted April 25, 2012 Originally Posted by Polak*: And where can I set max. players and max. chat messages? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 25, 2012 Author Share Posted April 25, 2012 Originally Posted by XpKiller*: Why? You can't set this. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 26, 2012 Author Share Posted April 26, 2012 Originally Posted by Buster78*: Is there a video tutorial on how to set this up? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 27, 2012 Author Share Posted April 27, 2012 Originally Posted by Polak*: Why? You can't set this. Be cause if i want to setup this on my website, I can't have another 500Mb DB, i have 2Gb of HardDisk and already using 800Mb for the Website and one DB. Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.