H
H
Hosting Yaroslavl2018-12-05 13:41:34
MySQL
Hosting Yaroslavl, 2018-12-05 13:41:34

Does the size of an adjacent table in a MySQL database affect the performance of queries against a single small table?

Does the size of an adjacent table in a MySQL database affect the performance of queries against a single small table?
Does it make sense to split the project into 3 databases:

  • Working base
  • Logs
  • Static Big Data (References)

Will this give a performance boost or is each table individually independent of its neighbors in the database?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
F
Fixid, 2018-12-05
@yarhosting

The influence is not direct. The tables are independent of each other. They are even physically stored usually in different files, like indexes. (depending on the type of storage)
Parallel queries to other tables will rather be affected by the consumption of shared resources.
Since a certain place in RAM is allocated for the entire instance for the query cache and indexes.

O
Oleg, 2018-12-05
@402d

- Do you have your own physical server?
- VPS? What is virtualization? How greedy is the host? Approximate overseled?
- Shared?
In general, everything comes down to this. Whether the desired data will actually be in physical RAM at the time of the request.
The meaning of shamanism with the database structure is only in the case of Dedik. But it's easier to deliver RAM there.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question