[SOLVED] mysql config

[Xele]

i have running TC on linux os (ubuntu server 14.04),

is this mysql config is good enough to support 200 players ?

[client]
port   = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice   = 0

[mysqld]
user               = mysql
pid-file           = /var/run/mysqld/mysqld.pid
socket             = /var/run/mysqld/mysqld.sock
port               = 3306
basedir            = /usr
datadir            = /var/lib/mysql
tmpdir             = /tmp
lc-messages-dir    = /usr/share/mysql
key_buffer_size    = 16M
max_allowed_packet = 16M
thread_stack       = 192K
thread_cache_size  = 8
myisam-recover     = BACKUP
max_connections    = 100
query_cache_limit  = 1M
query_cache_size   = 16M
log_error          = /var/log/mysql/error.log
expire_logs_days   = 10
max_binlog_size    = 100M
skip-external-locking

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]

[isamchk]
key_buffer_size = 16M

!includedir /etc/mysql/conf.d/

 

[Tommy]

Should be fine until you run into a MySQL related issue. I'd be more worried about server/internet specs than how my MySQL config is setup.

 

[Medic25]

If the SQL server is on the same computer then you will be fine, like tommie said its more on you up/down speeds the handle the client load

 

[Xele]

its on local, so there is no worry about this, thank you