Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Exiled Hero
Added.
Just so you know, I wouldn't recommend Navicat. SQLYog is better due to the fact it seperates Stored Procedures and Functions.
Gunz uses Functions and Stored Procedures but Navicat will store both together when it shouldn't.
I'm home tonight and I almost done a fix for you. =)
Millitary, if you are reading this, I'll send it to you as well.
Thank god.
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Lambda
Search a bit on the internet and you will find that actually SQL Server is one of the best database engines for games, the 99% of the game servers are written to use SQL Server and its for a reason.
I have ran GunZ on MySQL, at a first i was surprised for the speed of the select querys and the server in general, but when the user count increases (600 exactly), MySQL was claiming mercy, also you need to count with the fact that each matchserver instance makes 7 connections to the database.
I am using MySQL for my Team Fortress 2 community to handle all the ranking, subscriptions and user stuff and im seriously thinking to change into SQL Server because sometimes MySQL just hangs and i need to restart the whole MySQL process.
Definitively MySQL is not good for a database-intensive process like a Game server, for things like website that most of the time does selects its very good (its for what MySQL has been designed for).
If you want a database engine that performs like SQL Server you should look at PostgreSQL or Oracle.
To add on this, MySQL was never designed to work with games. MySQL was designed as a small, fast, database engine for web purposes.
Plus, none the less, MySQL was officially written for UNIX systems, so was Apache. Hence Apache running way and way better on UNIX systems than Windows systems.
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
phoenix_147
Ragnarok works great with MySQL. :O
Posted via Mobile Device
Ragnarok is designed for MySQL's purpose, opening only a few connections. MatchServer opens a shitload of 'em, and MySQL isn't designed for a lot of connections. MySQL was designed for:
1) Open connection
2) Execute multiple query's
3) Close connection after a few seconds
Not to have hundreds of connections open all day long.
Re: MySQL Server with RoA's Locator
well i have no other choice since MSSQL won't install.
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Military
well i have no other choice since MSSQL won't install.
Maybe I can help you?:) Add me on Msn Eele_mailadres@hotmail.com
I only do it by Teamviewer and if I have lagg on it I simple dont do it:P
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
eele
Maybe I can help you?:) Add me on Msn
Eele_mailadres@hotmail.com
I only do it by Teamviewer and if I have lagg on it I simple dont do it:P
i don't think you can help...i get fatal system error in my installation and i have to reinstall windows.
