All geek questions in one place

How efficient is a large MySQL database?

Are really really big (say, 100 million rows) databases crashing? I am completely unfamiliar with scaling - after all, but I thought that maybe one database can act as a key to larger pieces of factual data, becoming an index that would say: “Oh yes, this query needs a block of 20,000 000-25 000 000 "and sends a request to this block, skipping the rest. This is not what I need to implement, but I thought that I would ask here to indicate resources pointing me in the right direction. Regards.

+3
source share
3 answers

They certainly can be. I know, for example, that large systems often have several data centers that contain parts of their database and load balance between them.

In my opinion, the key concept for dividing a large database, as you say, is the outline of the database. This article should help you better understand how fragments divide the database to facilitate access and reduce the load on individual servers.

I somehow thought that I needed this type of technique for a database of about a million rows, but when I found out 3NF and the correct database structure, I repaired my badly implemented database. Thanks for reminding me of this! I will be interested to know what other answers you will receive.

+3
source

, . LIMIT 1 ( , , , , ).

LIMIT MySQL , .

0

MySQL 5.1 , ( ). MySQL , , .

0

Source: https://habr.com/ru/post/1711958/

More articles:


All Articles