MySQL Configuration

Here are some MySQL config options important to LB with explanations. Replace or add if not present:

#All in head is mostly irrelevant, the interesting things start here:
[mysqld]



#Should be obviously
port=25935

#Choose MYISAM or INNODB, INNODB is recommended for faster inserting
#The chat table will explicitly use MYISAM for faster text searching

default-storage-engine=INNODB

#Increase this, if you are getting "Too many connection errors"
max_connections=100

#Waste of memory, LogBlock updates all tables very frequently, so caching query results may cause a slowdown instead of a performance improvement
query_cache_size=0

#Buffer, how much RAM MySQL should consume. First is MyISAM index buffer, second InnoDB index and row buffer. Increase with growing database size, the indicies should be kept in RAM, otherwise inserts and selects can take a while due to reading from hard drive.
key_buffer_size=128M
innodb_buffer_pool_size=256M

#Must be disable to allow LB to connect to the database.
#skip-networking

#Remote access
bind-address 127.0.0.1        # only localhost
bind-address 192.168.0.100 # only from that ip (and localhost)
bind-address example.org  # only from that domain
bind-address 0.0.0.0            # from every ip in the world

#This will reduce the DNS lookups, and so speed some things up. Note you can't use domains in bind-address then.
skip-name-resolve