Help me optimize my.cnf for 2000 players

[scr3ative]

I had couple ideas, want to see how you would design it.

OS: Ubuntu 12.04

Should support players: 2000

default engine: innoDB

RAM: 32 GB

cpu: 2xl5520

hdd: 250GB SAS

mysql: 5.5

default configs:

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#
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
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

 

Thanks!

[scr3ative]

Where did the developers go?  :LOL:

[Tryskell]

As if a developer would know that, ask directly to an admin who successfully launched a 2k players server.

 

PS : gl to find him.

[scr3ative]

what should they know? in your mind developer = tell someone that they typed wrong IP in config?, then we all are developers

PS. don't spam my topic for your post count with nonsense comments

[SweeTs]

what should they know? in your mind developer = tell someone that they typed wrong IP in config?, then we all are developers

PS. don't spam my topic for your post count with nonsense comments

 

Lmao, you're totally wrong. Did you saw Tryskell posting for 'nothing't? :o Cuz I don't..

 

I think not so many ppl have experience with those configs, that why "ask an admin who successfully launched a 2k players server". Would be best option, but..

[Tryskell]

what should they know? in your mind developer = tell someone that they typed wrong IP in config?, then we all are developers

PS. don't spam my topic for your post count with nonsense comments

I never spoke about "wrong IP", and a developer (aka someone who develop) got no reason to know what a server admin knows, until he is, himself, a server admin. So what you ask is a server admin, not a developer. In my case, I'm a developer but never launched a real server with heavy players numbers. Finally, stop your nonsense rage before I lock your post due to my nonsense limited patience. My answer was all except agressive and it is aswell perfectly logical.

 

Go directly on L2 servers websites/forums, mail/PM admins and speak with them about configs.

 

I can also randomly tell you values for your mySQL, hoping it will crash and you have to reinstall it.

 

PS : in case you were refering to an answer who has been deleted meanwhile (because I don't understand the "wrong IP" stuff), just read the yellow line. In case you weren't, care about your next answers.

 

PS2 : if you manage to find infos, consider to reply with infos you found, in order people who will search and go on that topic will find infos.

[scr3ative]

I can also randomly tell you values for your mySQL, hoping it will crash and you have to reinstall it.

If you do that what you just posted, you would just make fun out of yourself.

 

Well if you have read my topic I clearly stated I already have couple ideas, as in already configured my.cnf, just wanted other people to post theirs and make a discussion as to why they chose those options.

[scr3ative]

Lmao, you're totally wrong. Did you saw Tryskell posting for 'nothing't? :o Cuz I don't..

 

I think not so many ppl have experience with those configs, that why "ask an admin who successfully launched a 2k players server". Would be best option, but..

 

Who are you?!?! His father ?!? there is no need to go retard mode friend

[Tryskell]

I lock the topic as it exists on another section. At least I won't have to bother with you.

 

Even on the other topic you're insulting (first reply on the other topic > "No answer ? Pathetic". Your behavior doesn't deserve you, and won't help you getting any answer in future. At least, from me, I won't bother about your threads anymore, no matter the subject.

 

If you don't want answer, don't post questions. People takes time to reply, get the decence to listen them and understand what they say.

 

And I prefer to warn you, next time you got such attitude on dev help section (my lair), I wouldn't spare you a -1 karma.