Storm Posted July 29, 2014 Report Share Posted July 29, 2014 I believe, I have found a better way to for the server to pool and load faster when using MYSQL. This is a lot better then using xampp. Download Here: https://edelivery.oracle.com/ This is mysql downloaded from http://www.mysql.com/ this will allow for better connection when using mysql. http://www.mysql.com/why-mysql/topreasons.html Please note you will need a good server to use, its best if you are using a dedicated server when trying to use this mysql. Run the download and configure based on these pictures Installation tab, execute, don't worry if connector/ODBC fails Configure your server based on this if you are using a dedicated server, other wise just select Server Machine Check advanced Options *Note Make sure you have a good dedicated server! Make a password for the root user of the mysql, then add a user. Make the user look like this or whatever you want your user to be. This user will be used to connect to the database. Set the host to localhost. Keep role as DB Admin. Start workbench. --Configuring the workbench and importing files-- Connect to the database Change username to your dayz username Import the data into the database Check "Import from self-contained File" and import the sql file Click New for the target schema Put the database name for the new target schema. Start the import You are finished and ready to connect. You can use any mysql client to connect and edit the tables. I have noticed better performance when trying to retrieve the data from the mysql server. Link to comment Share on other sites More sharing options...
0 Defent Posted July 30, 2014 Report Share Posted July 30, 2014 how did it go? I believe it helped a bit. I think some stuff are faster. I've yet to fully test it since I have some other problems causing the server to not always fill up. Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 30, 2014 Report Share Posted July 30, 2014 Then you need to do a little more optimizing.. As I stated, I have over 12k objects and it loads up pretty fast. check your server's startup batch commands. The server gets shutdown with the #shutdown command, but 5 secs before that, this is called: @echo off timeout 20 echo. echo Starting DayZ Server :: start the server.. set dayzpath="C:\DayZServers" cd /d %dayzpath% start "" "DayZ_Epoch_instance_11_Chernarus.bat" echo. echo Starting Bec timeout 20 :: start bec set becpath="C:\DayZServers\BecChern" cd /d %becpath% start "" "Bec.exe" -f Config.cfg echo. echo Server Started 100% cls @exit Link to comment Share on other sites More sharing options...
0 Storm Posted July 30, 2014 Author Report Share Posted July 30, 2014 Here's mine @echo off cd "C:\Program Files (x86)\Steam\SteamApps\common\Arma 2 Operation Arrowhead\" start becOver.bat start "arma2" /REALTIME "arma2oaserver.exe" -port=2302 "-config=instance_1_Overpoch\config.cfg" "-cfg=instance_1_Overpoch\basic.cfg" "-profiles=instance_1_Overpoch" -name=instance_1_Overpoch "-mod=@DayZOverwatch;@DayZ_Epoch;@Hive;" -noPause -noSound -noCB -cpuCount=1 -exThreads=8 -maxMem=10000 exit Link to comment Share on other sites More sharing options...
0 MGT Posted July 30, 2014 Report Share Posted July 30, 2014 How do I make the server run as a service in the first place? Firedaemon or serviceex cen 1 Link to comment Share on other sites More sharing options...
0 cen Posted July 30, 2014 Report Share Posted July 30, 2014 +1 FireDaemon Link to comment Share on other sites More sharing options...
0 Defent Posted July 30, 2014 Report Share Posted July 30, 2014 MySQL installs itself as a service afaik so you don't really need a program to monitor it. Not sure if it auto restarts upon crash or similar though. Link to comment Share on other sites More sharing options...
0 hambeast Posted July 30, 2014 Report Share Posted July 30, 2014 How do I make the server run as a service in the first place? I suggest purchasing a copy of firedaemon. It is a great piece of software and will come in handy when running multiple servers. There's a free 30 day trial to see if you like it. My favorite features are post/pre script options, so you can run a batch file on restart to do whatever maint you need to do (refresh vendors, rotate logs, etc) http://www.firedaemon.com/ Link to comment Share on other sites More sharing options...
0 Defent Posted July 30, 2014 Report Share Posted July 30, 2014 There is also a free webinterface which connects to firedaemon and allows you to start, install, stop etc services from the web. Some of my admins have the ability to start and stop the servers if they crash or go haywire. hambeast 1 Link to comment Share on other sites More sharing options...
0 fr1nk Posted July 30, 2014 Report Share Posted July 30, 2014 I keep procrastinating on this but will be picking up Firedaemon <---- like the 10th time I've said this lol Link to comment Share on other sites More sharing options...
0 hambeast Posted July 30, 2014 Report Share Posted July 30, 2014 There is also a free webinterface which connects to firedaemon and allows you to start, install, stop etc services from the web. Some of my admins have the ability to start and stop the servers if they crash or go haywire. Yes! this is a great tool for allowing admins to restart services. For those who don't know, it also allows you finite granularity on permissions from fire daemon services as well as system services (like MySQL!) I keep procrastinating on this but will be picking up Firedaemon <---- like the 10th time I've said this lol do it! It's a short download and is well worth it. Link to comment Share on other sites More sharing options...
0 RC_Robio Posted July 31, 2014 Report Share Posted July 31, 2014 Ohh Firedaemon looks like just what i need. Anybody have any good tips or tricks? Link to comment Share on other sites More sharing options...
0 hambeast Posted July 31, 2014 Report Share Posted July 31, 2014 Ohh Firedaemon looks like just what i need. Anybody have any good tips or tricks? Tip 1: Name your short name, description, and display name all the same thing and keep it short and descriptive. This will make accessing your service for stop/starts through batch files easier. Pre-Post tab is great for running maint scripts or rotating log files. Another tip is don't forget to set your working directory to the a2oa install path. I think it does it by default but it may cause problems if you don't. Another thing is you can easily clone one service if you plan on having multiple servers. Easy as changing the startup params on the new one. Don't forget to rename the service short name, desc, and display name as mentioned above. The built in scheduler is great for server restarts. Just make sure you have a script running to show a warning either thru bec or thru your windows task scheduler. I'll be releasing a restart tool shortly that I think is better than BEC. You can see the WIP source here https://gist.github.com/deadfred666/036ee8ddddf72c3b4f40 Link to comment Share on other sites More sharing options...
Question
Storm
I believe, I have found a better way to for the server to pool and load faster when using MYSQL.
This is a lot better then using xampp.
Download Here: https://edelivery.oracle.com/
This is mysql downloaded from http://www.mysql.com/ this will allow for better connection when using mysql.
http://www.mysql.com/why-mysql/topreasons.html
Please note you will need a good server to use, its best if you are using a dedicated server when trying to use this mysql.
Run the download and configure based on these pictures
Installation tab, execute, don't worry if connector/ODBC fails
Configure your server based on this if you are using a dedicated server, other wise just select Server Machine
Check advanced Options
*Note Make sure you have a good dedicated server!
Make a password for the root user of the mysql, then add a user.
Make the user look like this or whatever you want your user to be. This user will be used to connect to the database.
Set the host to localhost. Keep role as DB Admin.
Start workbench.
--Configuring the workbench and importing files--
Connect to the database
Change username to your dayz username
Import the data into the database
Check "Import from self-contained File" and import the sql file
Click New for the target schema
Put the database name for the new target schema.
Start the import
You are finished and ready to connect.
You can use any mysql client to connect and edit the tables.
I have noticed better performance when trying to retrieve the data from the mysql server.
Link to comment
Share on other sites
37 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