Geek Answers Handbook

Maximum MySQL features

How do I know when a project is just big for MySQL and I have to use something with a better reputation for scalability?

Is there a maximum database size for MySQL before performance degradation? What factors contribute to the fact that MySQL is not a viable option compared to a commercial DBMS such as Oracle or SQL Server?

+5
source share
6 answers

This is basically the size of the table.

, Oracle innoDB mysql . , , , infiniDB, InfoBright Tokutek, .

InnoDB . , , . , ( ) ram, , , ram. .

MySQL 5.1, , , , . , ram, , .

, ( , ), .

(, , ), , NULL 99,99% , ), ram, .

, ram (, , ).

. , .

Infobright Infinidb ​​ mysql , .

Tokutek - .

, . (,) 10G, .

+1

Google MySQL. , Google?

Smart-alec , MySQL - . MySQL, , .

+2

:

+2

-. MySQL , , .

, , , 4 . , MySQL, , : , .

, , . Sphinx: http://www.sphinxsearch.com/

, Craig List, , : http://blog.zawodny.com/

, , , MySQL. , MySQL , .

+2

MySQL - , /, Oracle Microsoft. .

+1

, , - . :

  • ?
  • . : SQL Server Enterprise , OLD ONE ISAILABLE - . .
  • ( 5000gb, ) - , "" ().

, Oracle RAC ( ) - , , "" ( ). SQL Server, , , ( "RAC" ), , ( "RAC", , ). " " Terra Server (http://msdn.microsoft.com/en-us/library/aa226316(SQL.70).aspx)

10gb - .

2 . , MySQL .

+1

More articles:


All Articles