A
A
alexdora2016-06-13 05:22:31
JavaScript
alexdora, 2016-06-13 05:22:31

What type of table should I choose for 200-400 concurrent connections?

I'm trying to figure out what type of table to choose for such conditions:

  1. 200-400 persistent connections with every second bombing 3 requests
  2. Only 4 tables: data is constantly read from one (it is updated separately), and in the remaining 3, the keys are updated (in fact, each connection has its own separate row without massive data a la application status, etc.)

Questions:
  1. What type of tables to choose?
  2. How time consuming task is this for mysql?
  3. What else is worth knowing so that mysql does not collapse?

I look towards Innodb. I know little about mysql

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexey Lazutin, 2015-10-23
@exelens

And is it set up correctly?
This is how it works for me
7cc6f7c01df5437392e84efca2d075cd.png

S
safenoob, 2016-06-13
@alexdora

You wrote a bit of nonsense, but after your question on SSL, you are forgiven ))
Why keep them open? Open connections every 3 requests. If for writing, then I recorded 1200 requests per second without any tuning, if for reading, then even more.
Increase simply the number of concurrent connections available in my.cnf

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question