Jump to content

Recommended Posts

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 :)

  • Love 1
Link to comment
Share on other sites

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!

  • Love 1
Link to comment
Share on other sites

  • Premium

MariaDB remains the best for Metin2, but overall, what Michael said.

 

"Nothing's free in this life.

Ignorant people have an obligation to make up for their ignorance by paying those who help them.

Either you got the brains or cash, if you lack both you're useless."

Syreldar

Link to comment
Share on other sites

What the hell. Stop saying that mysql is bad, mysql is the number one most popular database server in the world. I do not understand why all the kids come here and talk about changing mysql, if you read somewhere that mariadb is better than mysql, it does not mean it's better for metin. It's useless.
 

Wikipedia is built on MySQL, that's good enough for me :) And you say it's old?  (wikipedia is the seventh most popular website in the world; has over two million articles and over 15 million pages in total)  Even google , eBay , yahoo use it.

Leave mysql as it is, do not touch it .. it will scare and run away.  MySql DOES THE JOB JUST FINE.

Do you think that you server have more query than wikipedia or yahoo or google? When i saw the title i was just frustrated " QUTE:  Mysql is ooooo 2010's "

 

Link to comment
Share on other sites

hace 2 horas, Ashok.N dijo:

What the hell. Stop saying that mysql is bad, mysql is the number one most popular database server in the world. I do not understand why all the kids come here and talk about changing mysql, if you read somewhere that mariadb is better than mysql, it does not mean it's better for metin. It's useless.
 

Wikipedia is built on MySQL, that's good enough for me :) And you say it's old?  (wikipedia is the seventh most popular website in the world; has over two million articles and over 15 million pages in total)  Even google , eBay , yahoo use it.

Leave mysql as it is, do not touch it .. it will scare and run away.  MySql DOES THE JOB JUST FINE.

Do you think that you server have more query than wikipedia or yahoo or google? When i saw the title i was just frustrated " QUTE:  Mysql is ooooo 2010's "

 

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.

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • 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.