Config My.ini

[PoRnosJH]

Hello...im trying to config myini but i have sirius problem every time im trying...

so im stopping 1st the mysql via mysqlworkbench

then i edit and save the my.ini

then i cannot start mysql again...and has error "cannot connect to the server" :SS

any thought?

[antons007]

post your lines which u are modifying

[PoRnosJH]

ok i ll post all my sets (to have an opinion too)

Machine:
AMD Phenom x6 2.8Ghz
DDR3 8GB RAMM
2HHD 7,2RPM SATAII 64MB Cache 150gb / 100gb
(1 runs windows - The Other InnoDB)
70mb/s Upload

Threads Pool Manager :

Code: Select all

 # ---------------------------------------------------------------------------# Thread Configuration# ---------------------------------------------------------------------------# Extreme caution should be here, set to defaults if you do not know what you are doing.# These could possibly hurt your servers performance or improve it depending on your server's configuration, size, and other factors.# Default: 10ThreadPoolSizeEffects = 20# Default: 13ThreadPoolSizeGeneral = 26 # Default: 2UrgentPacketThreadCoreSize = 6 # Default: 4GeneralPacketThreadCoreSize = 12 # Default: 4GeneralThreadCoreSize = 12 # Default: 6AiMaxThread = 18 # Dead Lock Detector (a separate thread for detecting deadlocks).# For improved crash logs and automatic restart in deadlock case if enabled.# Check interval is in seconds.# Default: FalseDeadLockDetector = False # Default: 20DeadLockCheckInterval = 20 # Default: FalseRestartOnDeadlock = False 

Gs.bat:

Code: Select all

 java -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -server -Xms4096m -Xmx6144m -Xmn1024m -Xss256k -XX:ParallelGCThreads=8 -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:SurvivorRatio=8 -XX:TargetSurvivorRatio=90 -XX:MaxTenuringThreshold=31 -XX:+AggressiveOpts -XX:MaxPermSize=512m -XX:+UseCompressedOops -cp ./../libs/*;l2jserver.jar com.l2jserver.gameserver.GameServer 

my.ini (DeFault (Server Machine-TransactionalDB-Online Procc OLTP)


Changes i want to Done :

query_cache_size=0
tmp_table_size=256M
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=16M
innodb_buffer_pool_size=1024M
innodb_log_file_size=512M
innodb_thread_concurrency=60
memlock
innodb_file_per_table

I Find this Changes in a Guide...

I want to tell me Opinion about Changes...

How you think i must set my configs for better Performance

Why when i stop the server and do that changes...mysql will not start again ever...and i have to complete uninstall and re-instal it...


Server Rev Freya Last
Online Ppl 150-200
more than 160 starts a much lagg...

[Stake]

Hi!

innodb_thread_concurrency=60
I think, this is too big, since your amd cpu has 6 true cores. Set it to 8.
If you can't start mysql, then check your ini, if it's really correct, and you don't have a typo.

About performance, please provide us performance stats about when the server starts lagging. I mean usage of memory, cpu, hdd, etc.

[antons007]

innodb_log_file_size=512M <-- there is your error
this should be done before 1st time mysql launch.
1. Install mysql
2. Dont automatically start server
3. Edit my.ini
4. launc mysql

[PoRnosJH]

innodb_log_file_size=512M <-- there is your error
this should be done before 1st time mysql launch.
1. Install mysql
2. Dont automatically start server
3. Edit my.ini
4. launc mysql

ty i didnt knew that!!
what about my setting antons007?
are correct? you have something to set for better performance?

Hi!

innodb_thread_concurrency=60
I think, this is too big, since your amd cpu has 6 true cores. Set it to 8.
If you can't start mysql, then check your ini, if it's really correct, and you don't have a typo.

About performance, please provide us performance stats about when the server starts lagging. I mean usage of memory, cpu, hdd, etc.

i read on the guide that you have to set it as higher you can this...
he setted to 60 with an quad procc 2 years old...so i thought that i can seted to 60 too..

[Stake]

i read on the guide that you have to set it as higher you can this...
he setted to 60 with an quad procc 2 years old...so i thought that i can seted to 60 too..

I don't know what guide is that, but you know that there were some bugs with that parameter over mysql versions. Now, the default value is 8, and not recommended to set it higher than 20, if you don't have that many cpu's.

http://dev.mysql.com/doc/refman/5.0/en/ ... oncurrency
"A recommended value is 2 times the number of CPUs plus the number of disks. The range of this variable is 0 to 1000. A value of 20 or higher is interpreted as infinite concurrency before MySQL 5.0.19. From 5.0.19 on, you can disable thread concurrency checking by setting the value to 0. Disabling thread concurrency checking enables InnoDB to create as many threads as it needs."

[PoRnosJH]

i read on the guide that you have to set it as higher you can this...
he setted to 60 with an quad procc 2 years old...so i thought that i can seted to 60 too..

I don't know what guide is that, but you know that there were some bugs with that parameter over mysql versions. Now, the default value is 8, and not recommended to set it higher than 20, if you don't have that many cpu's.

http://dev.mysql.com/doc/refman/5.0/en/ ... oncurrency
"A recommended value is 2 times the number of CPUs plus the number of disks. The range of this variable is 0 to 1000. A value of 20 or higher is interpreted as infinite concurrency before MySQL 5.0.19. From 5.0.19 on, you can disable thread concurrency checking by setting the value to 0. Disabling thread concurrency checking enables InnoDB to create as many threads as it needs."

i have mysql 5.5.10 (last ver)
so if i put it to 0...is the best choice right?

[MELERIX]

5.0 manual is too old xD

try use manual for 5.5 version

http://dev.mysql.com/doc/refman/5.5/en/ ... oncurrency

MySQL 5.5 Reference Manual: http://dev.mysql.com/doc/refman/5.5/en/index.html

http://blogs.innodb.com/wp/2010/09/mysq ... n-windows/

[Bani]

If you change innodb_log_size number you just need to delete the old logs and mysql will auto make new ones. Really simple to fix

[chicken]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:
I need set my.ini for 1000+ Online. Can anyone help me about it? How cofirm the best for Server. My Server Xeon Quad Core (8 Chip, Ram 16G).

Code: Select all

max_connections=600query_cache_size=0table_cache=122tmp_table_size=256Mthread_cache_size=200innodb_additional_mem_pool_size=8Minnodb_flush_log_at_trx_commit=2innodb_log_buffer_size=16Minnodb_buffer_pool_size=1024Minnodb_log_file_size=512Minnodb_thread_concurrency=24memlockinnodb_file_per_table