Hercules Elf Bot - Mar 22, 2012 13:22
Originally posted by [b]Siberian[/b]
I just tested in 2 ways:
1 - 300k chars in table chars in my server, without any NPC rathena ... When I enter the map-server in a locked 2 secs and enter the map.
3 - Database clean test server. Come quick without lock (delay).
The problem in the table ta char ... if you have more than 5000 chars of this delay to login ... I have a 400k with chars of the delay and the same db with the 5k users ... Now I put the other with 30 chars ... is immediate ...
Hexed Version: 2012-03-07f
Hercules Elf Bot - Mar 22, 2012 16:36
Originally posted by [b]Siberian[/b]
The problem is the char table. I created a new table and now the delay is occurring when you enter the map-server, however the other with 27 chars is coming fast, without delay
Hercules Elf Bot - Mar 22, 2012 20:07
Originally posted by [b]Epoque[/b]
Either this is a performance issue of your machine, or it could be an issue with using MyISAM as the default engine for the table. MyISAM has a particularly important feature called table-level locking, which locks an entire table when performing updates. This prevents anything else from accessing the table until the operation is over, you might be experiencing delay from using MyISAM. This is almost certainly not an rAthena issue.
You could consider converting your table to InnoDB format (which only applies row-level locking) or invest in a faster machine (maybe a solid-state drive, which I would especially recommend for an InnoDB engine.)