Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
eele
Damn, I executed the query for the database in Navicat now, but if I click on the Functions it's still empty.
I had issues with the fnGetMin function. You will have to insert it manually like I did.
Code:
DELIMITER $$
CREATE FUNCTION fnGetMin(v_n1 INT, v_n2 INT) RETURNS int(11)
BEGIN
RETURN(CASE WHEN v_n1 < v_n2 THEN v_n1 ELSE v_n2 END);
END
$$
DELIMITER ;
select fnGetMin(1,2);
And the same for fnGetMax.
Code:
DELIMITER $$
CREATE FUNCTION fnGetMax(v_n1 INT, v_n2 INT) RETURNS int(11)
BEGIN
RETURN(CASE WHEN v_n1 > v_n2 THEN v_n1 ELSE v_n2 END);
END
$$
DELIMITER ;
select fnGetMax(1,2);
Re: MySQL Server with RoA's Locator
I don't miss that 2. I miss all:S Could you add me on Msn? eele_mailadres@hotmail.com
But thanks;)
Re: MySQL Server with RoA's Locator
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.
Re: MySQL Server with RoA's Locator
mysql takes a lot more memory than mssql .it canot the the load as compared to mssql . Look at your memory used in procceses you will know
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Asaki
mysql takes a lot more memory than mssql .it canot the the load as compared to mssql . Look at your memory used in procceses you will know
Correct yourself.
1) MySQL runs smoother and faster
2) Just does as much as MsSQL
3) Isn't a resource or space hog like MsSQL
3) Doesn't require .NET framework
List goes on.
And it's a fact that MySQL is used a lot more than any other databases that exists on the internet apart from MS Access.
Re: MySQL Server with RoA's Locator
no . correct yourself pls . I have another server which is using mysql server . Its been tested that mysql does not run smoother than mssql . Check your mysql usage of the memory you will know . mysql takes more memory than expected , when it comes to mssql server and load usage , pls compare the difference.
And like what lambda said , it cant even hold more than 300 players . mssql is able to hold more than a thousands, what do you think
Re: MySQL Server with RoA's Locator
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.
Re: MySQL Server with RoA's Locator
just to add on to this , mysql usage isnt any better .I used to run a maplestory server with mysql .I only had 100 over players online and the usage of the memory usage by mysql already hit up to 750+mb . so what do you think ? i dont think mssql will even hit that much , or rather hit 1/4 of it
Re: MySQL Server with RoA's Locator
Arguing about the memory that a database engine takes is rather stupid, the more memory it eats the more faster it will run.
If you run any database engine in a PC with, for example, 1GB of ram, it will need to do alot of I/O operations, slowing down the querys ALOT, i have seen SQL Server taking 4GB of ram on a 8GB computer, and if you put more in your server, it will take even more, but of course it will run MUCH faster because is using alot of memory caching.
Re: MySQL Server with RoA's Locator
i ran with 8gb still mysql is not the ideal choice for gaming
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.
