MichaelM
-
Posts
70 -
Joined
-
Last visited
-
Days Won
2 -
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Posts posted by MichaelM
-
-
On 5/30/2017 at 7:02 AM, z3imx said:
then how to install gamke to do combile for the source?
cuz i dont know what u say
sry
pkg install gmake
-
On 5/15/2017 at 7:56 PM, markx202 said:
Ahaha have you some screens about What you say? I don't sell anything. Prove what you say.
Contact me!
Kind regards,
Michael!
-
On 5/27/2017 at 6:47 PM, Dragonslayer said:
Nope, Oracle is the number one.
Anyway like ashok said, one metin server compared with one large database is like 0.1%.
I recommend use mariadb with library updates 64 bits.
MySQL is owned by Oracle... so it's kinda the same thing... as long as we're not talking about some kind of enterprise engine
-
Hey, you can use the same host for 2 servers as long as your servers aren't using the same ports.
-
12 hours ago, Mind Rapist said:
Hello community. I've been away for a while... But today I came up with an idea: did you ever think of changing your database protocol? I mean MySQL is convenient for everyone as all of us got used to it over the years. But is it still out best solutions in 2017? This post is about (hopefully) inspiring a great developer for tutorials on how to change MySQL protocols to MS SQL (2016), PostgreSQL, MongoDB or even Cassandra if possible directly from the source. Think about the speed your server could gain from Mongo or how much more smoothly can the massive amount of db requests in international servers be with Cassandra. I don't know about you guys but I think it's time for a system upgrade. I hope I inspired some of you
________________________________________________ GOLANG with MySQL (engine = MyISAM) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 1.195444ms 100 6.075053ms 1000 47.439699ms 10000 483.999809ms 100000 4.707089053s 1000000 49.067407174s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 872.709µs SELECT & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 20.717354746s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 2.309209968s 100000 257.411502ms 10000 26.73954ms 1000 3.483926ms 100 915.17µs 10 650.166µs DELETE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 6.065949ms ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ GOLANG with MongoDB ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 2.067094ms 100 8.841597ms 1000 106.491732ms 10000 998.225023ms 100000 8.98172825s 1000000 1m 29.63203158s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 5.251337439s FIND & DISPLAY (with index declared) ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 21.540603252s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1 1.330954ms ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ PHP5 with MySQL (engine = MyISAM) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 0.0040680000000001s 100 0.011595s 1000 0.049718s 10000 0.457164s 100000 4s 1000000 42s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 <1s SELECT & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 20s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ PHP5 with MongoDB ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 0.065744s 100 0.190966s 1000 0.2163s 10000 1s 100000 8s 1000000 78s FIND ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 <1s FIND & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 7s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 9s
^ source: https://stackoverflow.com/questions/9702643/mysql-vs-mongodb-1000-reads
MySQL is a very good engine, as other GPL-based engines are. MongoDB is a NoSQL engine written especially for Node.JS.
Also, for a Metin2 server, a different database engine would provide little to none additional performance.
Kind regards,
Michael!
- 1
-
-
The swimming system is insane! Would be nice to see this on private servers! Good job!
- 2
-
Try
set gold_expire = NOW() + INTERVAL x DAY
instead of:
gold_expire=DATE() + "..(get_time() + x*60*60*24).."
-
$ip="SERVER IP";
Replace SERVER IP with your game server's ip address.
If your website is hosted on the same machine as the gameserver then you're ip should be 127.0.0.1 (localhost).
-
-
1 hour ago, Abel(Tiger) said:
Way to go!
-
Activate ipv4 & dhcp. Set networking adapter as NAT.
Run this:
Spoilerdhclient em0
* Note, your network interface might not be em0, you have to change em0 with your interface.
Kind regards.
- 1
- 1
-
On 01.10.2016 at 3:01 AM, DarkPhoenix95 said:
Hi,
I purchased a Website/Board PSD from kurlz (here on m2dev).
I'm happy with the design, but his coder is a incompetent person (nicely said) which deleted me from skype after asking for continuation of the work
So right now I have a semi-functional PHP Website ...which would need a expansion (or overall complete recode)
A .psd for a Website, Board & a Patcher
So right now im looking for someone who could do Website & Board.
Also for someone who could code me a patcher with that design.
Skype via Private Message.
Payment Methods: Paypal.Contact me if you still need a service.
-
-
Update your CryptoPP
-
Spoiler
Purpose of this HowTo: Making your Makefile's output look cleaner.
Guide:
Spoiler- Open your Makefile with a text editor like Sublime Text or Notepad++.
Search for:
$(OBJDIR)/%.o: %.cpp
Your code should look like this:
Change
@echo compile $<
with
@echo -e "\033[0;32m [OK] \033[0m \033[0;33m Compiling:\033[0m" $<
It should look like this:
Now, do the same for
$(OBJDIR)/version.o: version.cpp
and
$(OBJDIR)/minilzo.o: minilzo.c
in game's Makefile.
You can do the same thing for database's Makefile.
- 2
- 13
-
pkg install cryptopp
rm -rf /path/to/Extern/include/cryptopp
mv /usr/local/include/cryptopp /path/to/Extern/include/cryptopp
- 2
-
Repair your tables, and post your syserr here.
-
6 hours ago, Seryov said:
Because i want to create effect in specific ocassion, like it:
Exactly! but i want to create only the effect.
Thank you guys for answering!What are those circles exactly? Only map effects or timer-based map aoe damage spawned on random locations?
-
5 minutes ago, .plechito' said:
But why do you want make it so complicated? You can easy put .mse file (via .pre file ofc) with World edtior. I don't understand why do you want to use c++ for positing effect on the map. That doesn't make any sense.
Maybe he needs dynamic object spawns.
-
On 16.09.2016 at 11:26 PM, Crystal™ said:
Thanks master
SpoilerFLUSH PRIVILEGES;
It's not mandatory. You're not granting any kind of privilege to 'root'.
-
You need a specific SpeedTree Modeler to make SRT files. E.g. http://store.speedtree.com/unreal-engine-4/
Answer from Unreal Engine's
.- 4
- 1
- 1
- 2
- 3
-
15 hours ago, OhhDaNips said:15 hours ago, MichaelM said:
CloudFlare is causing problems?! Move to akamai.
What are you talking about?
China, lol
-
comabile source server
in Community Support - Questions & Answers
Posted
Type in your console: pkg install gmake