06.02.2013, 09:36
(
Последний раз редактировалось Gamer_Z; 06.02.2013 в 10:10.
)
Mysql sucks, it has been discussed thousands of times here and a million of times on the world. Looking for better alternatives? I suggest someone creates a PostgreSQL plugin, much better than MySQL.
And knowing the size of the playerbase a server could have max, let's say 32k (deleting inactive accounts for x time etc), then you only need premature optimizations, while in MySQL you need to bang your head to the ceiling until you fine-tune everything yourself.
I have no server (so no need for it) and (probbly) not the time to create one so I just suggest it here.
Looking at different types of usage, like here: http://www.wikivs.com/wiki/MySQL_vs_...eSQL#Raw_Speed
And thousands of other results, for sa-mp you use InnoDB, MyIsam would be a real fail with MySQL + SA-MP. And sa-mp servers using PostgreSQL would really benefit because there is one engine, one community, one big open source project which is greatly improved.
I do not intend to participate in a discussion "which is better" or "why is mysql wrong". Server owners which are a bit more advanced in coding and managing servers and databases will understand me.
But just to support my post here are a few links:
http://stackoverflow.com/questions/8...ql-5-6-innodb/
http://dba.stackexchange.com/questio...nd-postgresql/
http://www.openlogic.com/wazi/bid/18...urce-Database/
http://stackoverflow.com/questions/1...s-environment/
Also: Mysql's default memory usage is set higher (256 mb of ram, but you can lower that) than the PostgreSQL's one (32 mb) which is more usefull on MANY VPS's which sa-mp server owners, own.
And knowing the size of the playerbase a server could have max, let's say 32k (deleting inactive accounts for x time etc), then you only need premature optimizations, while in MySQL you need to bang your head to the ceiling until you fine-tune everything yourself.
I have no server (so no need for it) and (probbly) not the time to create one so I just suggest it here.
Looking at different types of usage, like here: http://www.wikivs.com/wiki/MySQL_vs_...eSQL#Raw_Speed
And thousands of other results, for sa-mp you use InnoDB, MyIsam would be a real fail with MySQL + SA-MP. And sa-mp servers using PostgreSQL would really benefit because there is one engine, one community, one big open source project which is greatly improved.
I do not intend to participate in a discussion "which is better" or "why is mysql wrong". Server owners which are a bit more advanced in coding and managing servers and databases will understand me.
But just to support my post here are a few links:
http://stackoverflow.com/questions/8...ql-5-6-innodb/
http://dba.stackexchange.com/questio...nd-postgresql/
http://www.openlogic.com/wazi/bid/18...urce-Database/
http://stackoverflow.com/questions/1...s-environment/
Also: Mysql's default memory usage is set higher (256 mb of ram, but you can lower that) than the PostgreSQL's one (32 mb) which is more usefull on MANY VPS's which sa-mp server owners, own.