Log in

View Full Version : Question about rule_values and MariaDB


Thalix
09-28-2016, 10:02 AM
Hello everyone!

I have a number of questions for which I couldn't find answers in the search.

First about entries in the table rule_values:

Which time unit is used by 'Zone:AutoShutdownDelay'?
Default Value is '5000'. Does this mean 5 seconds or 5000 seconds?
We have some duplicate entries in the table 'rule_values' and the table 'variables'.
Is there a list which entries from 'variables' are still in use? (I have the newest peq database).
To be more specific:
- variables 'loglevel' or rule_values 'QueryServ/EventLog'?
- variables 'EXPMod/GroupEXPBonus' or rule_values 'Character:GroupExpMultiplier/Character:ExpMultiplier'?


Second questions is about MariaDB/Linux:
Is it correct to say each new client (player on server) means a new connection to my mariadb?
If so, which settings for thread_pools do you recommend for a peak of 50 players? I am talking about this: Thread Pool in MariaDB (https://mariadb.com/kb/en/mariadb/thread-pool-in-mariadb/)

Thank you so much for answering my questions!

NostalgiaEQ
09-28-2016, 03:31 PM
usually the times are in milliseconds so divide by 1000 to get it in seconds. sometimes it says MS at the end sometimes not.

I would try to make everything consistent between variables and rule values but I don't know about those settings specifically.