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 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 how is this better than xampp not trying to be a dick just asking Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 how is this better than xampp not trying to be a dick just asking Because it offers a better performance when having multiple servers connecting to one sql instance. Also the connecting and pulling data from the mysql server is a lot faster then xampp is. It uses more resources though. Plus workbench is really good to use. Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 good answer , im looking for some thing to help me out , my sql skills are very very weak , i need to read a few things , watch a few videos , do you know any thing about the Config file ,and did you do any tweaks to it? so far what i have done to my sql xampp server is just edit a few lines to allow more memory and stuff because the default my.ini is pretty weak how does this come out of the box? TNT 1 Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 good answer , im looking for some thing to help me out , my sql skills are very very weak , i need to read a few things , watch a few videos , do you know any thing about the Config file ,and did you do any tweaks to it? There is no need for tweaking. the config type will set your mysql server based on weather it's a dedicated server or a just a regular server machine. If you have a dedicated server and the resources then use the dedicated server config as it will help even more. Xampp has a really bad storage-engine.... Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 Really no tweaking required that sounds to good to be true lol , are you sure about that? and im currnently hosting on a VDS server with 4x 3Ghz cores , 4 gigs of ram and an SDD drive , do u think i should give this a shot , today i had a problem on restart with 2 people losing gear , this hasnt happened to much but im pretty sure its to do with my poor sql skills today is the first day since the update that any one has told me about this , so it was sort of a shock Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 Really no tweaking required that sounds to good to be true lol , are you sure about that? Positive, the mysql will is set based on what your computer has available for resources. The config option is what will set how much the server can use and how well. Take a look at this http://www.mysql.com/why-mysql/ http://www.mysql.com/why-mysql/topreasons.html TNT 1 Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 Positive, the mysql will is set based on what your computer has available for resources. The config option is what will set how much the server can use and how well. Take a look at this http://www.mysql.com/why-mysql/ http://www.mysql.com/why-mysql/topreasons.html thats cool i will give this a try , thanks for the post! and reply's Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 Really no tweaking required that sounds to good to be true lol , are you sure about that? and im currnently hosting on a VDS server with 4x 3Ghz cores , 4 gigs of ram and an SDD drive , do u think i should give this a shot , today i had a problem on restart with 2 people losing gear , this hasnt happened to much but im pretty sure its to do with my poor sql skills today is the first day since the update that any one has told me about this , so it was sort of a shock Player losing their gear after restarts is generally a bug with epoch. Best way to stop this from happening if having them disconnect before the restart. Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 Player losing their gear after restarts is generally a bug with epoch. Best way to stop this from happening if having them disconnect before the restart. Yeah i have BEC send warnings from 5 mins b4 restart to disconect , the user said they disconected 6 mins prior to restart , like i said this does not happen often and i have changed bandwidth settings and such and it really did help stop this by at least 98% , only weird thing was that the server was not even busy at the time when this happen , and yeah i understand bugs will happen , they were ok with it , it doesn't happen much thank god lol thats y i also have a feeling it could be my sql , i could make it better and that is never a bad thing what are you using for your restart time, like in mins after restart that ur server starts back up? Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 Yeah i have BEC send warnings from 5 mins b4 restart to disconect , the user said they disconected 6 mins prior to restart , like i said this does not happen often and i have changed bandwidth settings and such and it really did help stop this by at least 98% , only weird thing was that the server was not even busy at the time when this happen , and yeah i understand bugs will happen , they were ok with it , it doesn't happen much thank god lol thats y i also have a feeling it could be my sql , i could make it better and that is never a bad thing what are you using for your restart time, like in mins after restart that ur server starts back up? <Scheduler> <!-- Schedular to be shown all days in the week. --> <!-- show text ingame every 20 min --> <job id="0"> <time>001000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>1</loop> <cmd>say -1 Join us at our website: pursuegaming.com or TS3: ts.pursuegaming.com:9987. </cmd> <cmdtype>0</cmdtype> </job> <job id="1"> <time>010000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 Server uptime is one hour. In two hours this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="2"> <time>020000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 Server uptime is two hours. In one hour this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="3"> <time>023000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 30 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="4"> <time>024500</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 15 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="5"> <time>025000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 10 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="6"> <time>025500</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 5 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="7"> <time>025700</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 3 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="8"> <time>025800</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 2 minutes this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="9"> <time>025900</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>say -1 In 1 minute this server will restart</cmd> <cmdtype>0</cmdtype> </job> <job id="10"> <time>030000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>#shutdown</cmd> <cmdtype>0</cmdtype> </job> <job id="11"> <time>030000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>C:\Program Files (x86)\Steam\SteamApps\common\Arma 2 Operation Arrowhead\_DayZ_Overpoch.bat</cmd> <cmdtype>1</cmdtype> </job> </Scheduler> I am using an older BEC 1.5 Link to comment Share on other sites More sharing options...
0 Defent Posted July 29, 2014 Report Share Posted July 29, 2014 I use the xampp database. I will attempt to use this on the next restart. Will post info when I get back. Link to comment Share on other sites More sharing options...
0 TayTayTheKiller Posted July 29, 2014 Report Share Posted July 29, 2014 heh used this form day one Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 29, 2014 Report Share Posted July 29, 2014 One of my servers has over 8000 objects in its database. Typically means that it takes about 20-30mins before anybody's ingame after a restart. Anyway to fix this? Or can an epoch server just not have that many objects? Link to comment Share on other sites More sharing options...
0 RC_Robio Posted July 29, 2014 Report Share Posted July 29, 2014 One of my servers has over 8000 objects in its database. Typically means that it takes about 20-30mins before anybody's ingame after a restart. Anyway to fix this? Or can an epoch server just not have that many objects? Something is wrong. I have had 13,000 objects and back in game in a minute after restart. What are you using to run your restarts? Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 29, 2014 Report Share Posted July 29, 2014 BEC: #shutdown in the Scheduler. The server is started again with a script that runs the DayZ_Epoch_instance_11_Chernarus.bat file & BEC. Link to comment Share on other sites More sharing options...
0 hambeast Posted July 29, 2014 Report Share Posted July 29, 2014 BEC: #shutdown in the Scheduler. The server is started again with a script that runs the DayZ_Epoch_instance_11_Chernarus.bat file & BEC. I would suggest not using be shutdown and instead shutting down the server with a batch file that stops the service manually. Give it about 15 seconds and start the server again with the service. If you are not running your servers as services, you should be. Makes managing them and restarting after crashes (rare these days) a lot easier. I have found that battleye shutdowns are unreliable at best. also make sure all of your tables in your db are running the same engine. I use innodb, won't argue the merrits of innodb vs myisam here but for row locking vs table locking alone, I think innodb is worth it. edit: here's an example of how to restart a server with services net stop DayZEpochSSD timeout /T 15 net start DayZEpochSSD Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 I use the xampp database. I will attempt to use this on the next restart. Will post info when I get back. how did it go? Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 29, 2014 Report Share Posted July 29, 2014 here's an example of how to restart a server with services How do I make the server run as a service in the first place? Link to comment Share on other sites More sharing options...
0 TNT Posted July 29, 2014 Report Share Posted July 29, 2014 can any one let me know how to allow my self to connect to the sql data base on my Dedi from my home pc , it allows me to connect to it when i turn off the firewall , so it has some thing to do with windows firewall, i installed Mysql , going to give it a shot set up was pretty simple Link to comment Share on other sites More sharing options...
0 RC_Robio Posted July 29, 2014 Report Share Posted July 29, 2014 I've been using BEC for over a year managing shutdowns without a problem in the scheduler. The end of my scheduler,xml <job id="8"> <time>030000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>0</loop> <cmd>#shutdown</cmd> <cmdtype>0</cmdtype> </job> <job id="9"> <time>030000</time> <delay>000000</delay> <day>1,2,3,4,5,6,7</day> <loop>1</loop> <cmd>D:\Dayz\Epoch\DayZ_Epoch_instance_11_Chernarus.bat</cmd> <cmdtype>1</cmdtype> </job> </Scheduler> Also my startup bat : @echo off :initialize cls echo Killing current running server ... taskkill /IM arma2oaserver.exe /F taskkill /IM bec_epoch.exe /F echo Done! timeout 20 echo. goto start :start cd D:\Dayz\Epoch echo Starting server again ... start "arma2" /REALTIME "arma2oaserver.exe" -cpuCount=2 -maxMem=2047 -noSound -port=2302 "-config=instance_11_Chernarus\config.cfg" "-cfg=instance_11_Chernarus\basic.cfg" "-profiles=instance_11_Chernarus" -name=instance_11_Chernarus "-mod=@DayzOverwatch;@DayZ_Epoch;@DayZ_Epoch_Server;" echo. :start_bec timeout 35 echo. cd D:\Dayz\Epoch\BattlEye Extended Controls echo Starting BEC again ... @start bec_epoch.exe -f config.cfg exit Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 29, 2014 Report Share Posted July 29, 2014 I've been using BEC for over a year managing shutdowns without a problem in the scheduler. Same here (although for 7 months). I'm not sure if mysql is running slowly or what. It definitely is the no. of objects because with an empty table the restarts are very quick. This program made no difference. Link to comment Share on other sites More sharing options...
0 Storm Posted July 29, 2014 Author Report Share Posted July 29, 2014 Same here (although for 7 months). I'm not sure if mysql is running slowly or what. It definitely is the no. of objects because with an empty table the restarts are very quick. This program made no difference. Works a lot better for me. You need to clean up those objects or get a better machine. I have over 12k objects loading on the server and it only takes me about 2 minutes for the server to load all of the objects. Link to comment Share on other sites More sharing options...
0 Millasaurus Posted July 29, 2014 Report Share Posted July 29, 2014 Works a lot better for me. You need to clean up those objects or get a better machine. I have over 12k objects loading on the server and it only takes me about 2 minutes for the server to load all of the objects. Surely the machine isn't the issue? http://www.online.net/en/dedicated-server/dedibox-pro2k14 Link to comment Share on other sites More sharing options...
0 TayTayTheKiller Posted July 30, 2014 Report Share Posted July 30, 2014 Surely the machine isn't the issue? http://www.online.net/en/dedicated-server/dedibox-pro2k14 I would say no. :lol: Link to comment Share on other sites More sharing options...
0 Storm Posted July 30, 2014 Author Report Share Posted July 30, 2014 Surely the machine isn't the issue? http://www.online.net/en/dedicated-server/dedibox-pro2k14 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. This is what I am running 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