I would like to thank whoever will take time to read/reply this topic. English isn't my native langage so please apologize the medium English level.
Running into global FPS issues, we were told that using a remote database to store the objects table can greatly increase server performance. I would like to know if there is any documentation about the [ObjectDB] section of the HiveExt.ini file, couldn't find any on the forum nor on the wiki.
If there isn't such information source, your help would be precious.
The server is running properly using local only database. When using the remote database (for the objects table), the Hive window crashes randomly after loading successfuly from 1200 up to 2200 table lines (out of 6300), without any error in the window : it stops on the green line describing the latest loaded item and a Windows error pops up "arma2oaserver.exe has stopped working".
However, the RPT file does indicate an error message (sorry, couldn't find any Spoiler feature) :
Googling the RPT errors gave poor results. However there is a list of what I tried :
set arama2oaserver.exe as Win XP SP3 compatible and gave it administrator privileges -> same issue
created new admin account and launched server from it -> same issue
increased the remote mySQL server caches in the my.conf file, however it roughly takes 3% of the CPU and 42MB of RAM -> same issue
deleted the DLL folder and DLL files located in the root ArmA II installation folder then redownloaded them using Steam's file check -> same issue
added latest C and C++ connectors for mySQL (libmysql.dll and mysqlcppconn.dll) in the root game directory -> same issue
installed test DayZ server on my home computer -> same issue (this test tends to prove that the virtualized os has not to be incriminated)
Here are the specs :
Dedicated server with DayZ
CPU : Intel Xeon E3-1225 V2 @3.2GHz with 8MB cache
RAM : 4x 4GB
Disks : two 1TB disks, with main mounting point using raid1 for 100GB, then raid0 for the rest
Host OS : Debian 7.2 64bits, installed on raid1
Invited OS : Windows 7 Pro 64bits, using VMWare Workstation 10, virtual disk on raid0
MySQL database : MySQL Workbench 6.0
Bandwidth : 100Mbps
VPS with Mumble, the website and the remote database
CPU : vCore 2GHz
RAM : 512Mo
OS : Ubuntu Server 12.04 32bits
MySQL database : standalone MySQL 5.5.22
Bandwidth : 100 Mbps
Testing home server :
CPU : Intel i7-930 @2.8GHz with 8MB cache
RAM : 3x 2GB
Disk : Seagate Barracuda 2TB @7200rpm with 64MB cache
OS : Windows 7 Home Premium 64bits
MySQL database : MySQL 5.6.12 from the latest WAMP 64bits package
Bandwidth : 50Mbps down, 5Mbps up
Any help or link to documentation would be helpful.
Question
Alucard88
Hello,
I would like to thank whoever will take time to read/reply this topic. English isn't my native langage so please apologize the medium English level.
Running into global FPS issues, we were told that using a remote database to store the objects table can greatly increase server performance. I would like to know if there is any documentation about the [ObjectDB] section of the HiveExt.ini file, couldn't find any on the forum nor on the wiki.
If there isn't such information source, your help would be precious.
The server is running properly using local only database. When using the remote database (for the objects table), the Hive window crashes randomly after loading successfuly from 1200 up to 2200 table lines (out of 6300), without any error in the window : it stops on the green line describing the latest loaded item and a Windows error pops up "arma2oaserver.exe has stopped working".
However, the RPT file does indicate an error message (sorry, couldn't find any Spoiler feature) :
Here is the beginning of the HiveExt.log, the only thing that could be incriminated (to my eyes) is the mySQL versions not matching
Googling the RPT errors gave poor results. However there is a list of what I tried :
Here are the specs :
Any help or link to documentation would be helpful.
Kind regards,
Arnaud
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now