Jump to content

MichaelM

Banned
  • Posts

    70
  • Joined

  • Last visited

  • Days Won

    2
  • Feedback

    0%

MichaelM last won the day on June 15 2017

MichaelM had the most liked content!

About MichaelM

Core X

  • BAN_NOTICE
    Yes

Informations

  • Gender
    Male

Recent Profile Visitors

1196 profile views

MichaelM's Achievements

Contributor

Contributor (5/16)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

40

Reputation

  1. 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
  2. Hey, you can use the same host for 2 servers as long as your servers aren't using the same ports.
  3. ________________________________________________ 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!
  4. The swimming system is insane! Would be nice to see this on private servers! Good job!
  5. Try set gold_expire = NOW() + INTERVAL x DAY instead of: gold_expire=DATE() + "..(get_time() + x*60*60*24).."
  6. $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).
  7. Hi, @FreZzwe! Please contact me if you're still looking for help.
  8. Activate ipv4 & dhcp. Set networking adapter as NAT. Run this: * Note, your network interface might not be em0, you have to change em0 with your interface. Kind regards.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.