|
You last visited: Today at 15:35
Advertisement
memory usage of msgserver increasing over time which causes losing connection with db
Discussion on memory usage of msgserver increasing over time which causes losing connection with db within the CO2 Private Server forum part of the Conquer Online 2 category.
07/19/2016, 20:46
|
#1
|
elite*gold: 0
Join Date: Jul 2016
Posts: 2
Received Thanks: 0
|
memory usage of msgserver increasing over time which causes losing connection with db
i've 5095 p-server the gameserver lost connection with database after 2 hrs from starting it
The Error >>
PHP Code:
2016-7-14 16:17:52 -- ERROR: Database ExecuteSQL(MySQL client run out of memory) occur mysql error(SELECT * FROM cq_tutor WHERE tutor_id = 160840 AND Betrayal_flag = 0). 2016-7-14 16:17:52 -- ERROR: Database ExecuteSQL(Lost connection to MySQL server during query) occur mysql error(SELECT * FROM cq_tutor WHERE Student_id = 160840 AND Betrayal_flag = 0 LIMIT 1).
the msgserver memory usage increases too fast over time i know the reason but i can't find solution
login action of players have many actions of type 1077 like that
PHP Code:
REPLACE INTO `cq_action` VALUES ('100000', '00000000', '00000000', '1071', '000000', '1 200000'); REPLACE INTO `cq_action` VALUES ('200000', '500000', '100000', '1077', '50', 'select who FROM bigmano where weap1=%user_id'); REPLACE INTO `cq_action` VALUES ('300000', '500000', '100000', '1077', '50', 'select who FROM bigmano where weap2=%user_id'); REPLACE INTO `cq_action` VALUES ('400000', '500000', '100000', '1077', '50', 'select who FROM bigmano where weap3=%user_id'); REPLACE INTO `cq_action` VALUES ('500000', '600000', '100000', '1077', '50', 'select who FROM bigmano where weap4=%user_id');
This actions repeating itself every 1 second for all online players
that's just example i've many of that kind of actions starting with login action
i tried to convert my tables from MyIsam To InnoDB but the problem still occuring
i mean .. is there any solution to make msg server memory usage increase slower ?? like stoping caching or saving logs in game server or other way ?
i want to solve this problem without deleting actions if that possible
thanks for reading ,,
|
|
|
07/19/2016, 21:06
|
#2
|
elite*gold: 0
Join Date: Jun 2007
Posts: 659
Received Thanks: 31
|
Your over using that actiontype opening so many Querys and never closing them thus causing the MYSQL service to crash. A solution is properly writing your querys. Read your error's specfically your out of memory.
|
|
|
07/19/2016, 21:55
|
#3
|
elite*gold: 0
Join Date: Jul 2016
Posts: 2
Received Thanks: 0
|
Quote:
Originally Posted by angel12345
Your over using that actiontype opening so many Querys and never closing them thus causing the MYSQL service to crash. A solution is properly writing your query. Read your error's specfically your out of memory.
|
thanks for replying but i think it isn't mysql crashing ... the msg server memory usage still increasing until the total memory usage become 100 % ( No Physical Memory Available ) and commit charge (Task Manager) become more than 80% which cause losing connection between database and gameserver cuz there isn't more memory available ... do u think there's any solution except deleting actions ?
|
|
|
07/19/2016, 22:25
|
#4
|
elite*gold: 21
Join Date: Jul 2005
Posts: 9,193
Received Thanks: 5,376
|
Quote:
Originally Posted by ManoLucky
thanks for replying but i think it isn't mysql crashing ... the msg server memory usage still increasing until the total memory usage become 100 % ( No Physical Memory Available ) and commit charge (Task Manager) become more than 80% which cause losing connection between database and gameserver cuz there isn't more memory available ... do u think there's any solution except deleting actions ?
|
The solution is to not use TQ binaries. They are full of huge exploits that lets anyone who wants to crash your server, delete your database, etc. That's not even mentioning the fact that they are highly illegal and don't let you actually do much in terms of client protection or add custom features.
|
|
|
07/19/2016, 22:52
|
#5
|
elite*gold: 0
Join Date: Jun 2007
Posts: 659
Received Thanks: 31
|
Quote:
Originally Posted by pro4never
The solution is to not use TQ binaries. They are full of huge exploits that lets anyone who wants to crash your server, delete your database, etc. That's not even mentioning the fact that they are highly illegal and don't let you actually do much in terms of client protection or add custom features.
|
Indeed but if he wishes to use them at least realize the problem isn't his system but an issue with how the binaries run the SQL Statements.
|
|
|
|
Similar Threads
|
Client Memory usage
10/23/2013 - Flyff Private Server - 2 Replies
Hi elitepvpers,
I am wondering if there is anything i can do to reduce the RAM usage of the client.
Currently my Client is using 220MB of RAM.
I have tested it with 2 sets of models.
1 Folder have over 3.5GB of models in it. And the other 1.25GB of models
However the RAM is still 220MB
With kind regards,
|
Reduce memory usage?
02/20/2013 - CO2 Private Server - 6 Replies
Hello, i've an edited version of Trinity base, it's 5672+
The source is pretty stable, and most of bugs i can handle, however, there's one thing bothering me, it SUCKS the rams, with 0 players online it runs on 200mb!!!
There source is kinda not original, because most of numbers are in Hexadecimal and there's that "goto Label_1B9C5;" thing
It also have a LOT of auto invite that check every 1 sec
this is one of em:
if (DateTime.Now.Minute == 20 && DateTime.Now.Second == 00)
|
Source Memory Usage
05/14/2012 - CO2 Private Server - 18 Replies
well my Source Consumes 88k Memory and it get raised by 30 when player login or so .. so my questions : -
1 - is it Normal or bad ?
2 - if i got same features but Consume just 20k would it matter in performance and sending faster Packet or w.e
3 - How to Reduce its CpUsage and memory too ?
|
Memory Usage?
01/19/2011 - Perfect World - 1 Replies
Sorry if this has been mentioned before but, I'm running PWI and the memory usage is insane! upwards of 500MB RAM for a client! D:
Is there a way to lower it's memory usage? Why is it using so much? -_-
|
Memory usage of conquer?
07/04/2007 - Conquer Online 2 - 2 Replies
Hi guys,
i have on my new com vista... and i think co is eating too much memory after few hours it goes like 250MB and that never happened to me on XP where it was like 50-80MB did anyone experienced this too? or i just have somethin messed up...
thnx for replies
|
All times are GMT +2. The time now is 15:35.
|
|