/tg/ Station 13 - Modules - TypesVar Details - Proc Details

dbcore

Vars

all_queriesAll the current queries that exist.
all_queries_numNumber of all queries, reset to 0 when logged in SStime_track. Used by SStime_track
failed_connection_timeoutworld.time that connection attempts can resume
failed_connection_timeout_countTotal number of times connections have had to be timed out.
failed_connectionsNumber of failed connection attempts this try. Resets after the timeout or successful connection
max_connection_failuresMax number of consecutive failures before a timeout (here and not a define so it can be vv'ed mid round if needed)
processing_queriesQueries being checked for timeouts.
queries_activeQueries currently being handled by database driver
queries_active_numNumber of active queries, reset to 0 when logged in SStime_track. Used by SStime_track
queries_standbyQueries pending execution, mapped to complete arguments
queries_standby_numNumber of standby queries, reset to 0 when logged in SStime_track. Used by SStime_track
queued_log_entries_by_tableAn associative list of list of rows to add to a database table with the name of the target table as a key. Used to queue up log entries for bigger queries that happen less often, to reduce the strain on the server caused by hundreds of additional queries constantly trying to run.
shutting_downWe are in the process of shutting down and should not allow more DB connections

Procs

QuerySelect
add_log_to_mass_insert_queueThis is a proc to hopefully mitigate the effect of a large influx of queries needing to be created for something like SQL-based game logs. The goal here is to bundle a certain amount of those log entries together (default is 100, but it depends on the SQL_GAME_LOG_MIN_BUNDLE_SIZE config entry) before sending them, so that we can massively reduce the amount of lag associated with logging so many entries to the database.
create_active_queryHelper proc for handling activating queued queries
reset_trackingResets the tracking numbers on the subsystem. Used by SStime_track.

Var Details

all_queries

All the current queries that exist.

all_queries_num

Number of all queries, reset to 0 when logged in SStime_track. Used by SStime_track

failed_connection_timeout

world.time that connection attempts can resume

failed_connection_timeout_count

Total number of times connections have had to be timed out.

failed_connections

Number of failed connection attempts this try. Resets after the timeout or successful connection

max_connection_failures

Max number of consecutive failures before a timeout (here and not a define so it can be vv'ed mid round if needed)

processing_queries

Queries being checked for timeouts.

queries_active

Queries currently being handled by database driver

queries_active_num

Number of active queries, reset to 0 when logged in SStime_track. Used by SStime_track

queries_standby

Queries pending execution, mapped to complete arguments

queries_standby_num

Number of standby queries, reset to 0 when logged in SStime_track. Used by SStime_track

queued_log_entries_by_table

An associative list of list of rows to add to a database table with the name of the target table as a key. Used to queue up log entries for bigger queries that happen less often, to reduce the strain on the server caused by hundreds of additional queries constantly trying to run.

shutting_down

We are in the process of shutting down and should not allow more DB connections

Proc Details

QuerySelect

add_log_to_mass_insert_queue

This is a proc to hopefully mitigate the effect of a large influx of queries needing to be created for something like SQL-based game logs. The goal here is to bundle a certain amount of those log entries together (default is 100, but it depends on the SQL_GAME_LOG_MIN_BUNDLE_SIZE config entry) before sending them, so that we can massively reduce the amount of lag associated with logging so many entries to the database.

Arguments:

create_active_query

Helper proc for handling activating queued queries

reset_tracking

Resets the tracking numbers on the subsystem. Used by SStime_track.