• 0
Sign in to follow this  
Followers 0
SneakyDuServer

Question? Updating Mysql database

Question

I would like to increase the speed of database saves. Just in-case it restarts and i have some loop of vehicles, or death loops and it restores the vehicles on the map (last known spot)

Where would i increase the saves? and what is the default time to save - update or refresh.

Thank you

Sneaks

 

p.s i did not change the exile.ini as it pre defines what saves, but is there a function that we can change from 60minutes to 5minutes or more if we choose.

 

Edited by SneakyDuServer

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

Extdb-conf.ini has this

idleTime = 60

can i change that to a lower time to do an update check?

Share this post


Link to post
Share on other sites
  • 0

Here is the default settings

minSessions = 2
idleTime = 60
; Really should only use this if MySQL server is external. Also only for MySQL
compress = false
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth
Secure Auth = true

 

Removed everything else not associated to this question.

 

minSessions = 1
; minSession Default Value = 1

;maxSessions = 4
; maxSession Default Value = number of Main->Threads
;     You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
;     idleTime is the time before a database session is stopped if not used.
;    If Database Sessions are greater than minSessions

Share this post


Link to post
Share on other sites
  • 0

Could one force commands from a bat file? to call those prior to lock?

Just asking, i am no pro

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.