A
A
Azazel PW2015-07-02 06:25:28
linux
Azazel PW, 2015-07-02 06:25:28

How to check the performance of the 1C server?

Dear colleagues, tell me how to test the performance of a 1C server?
Gilev shows parrots, which are difficult to evaluate.
How else can you test the server?
Databases over 100GB and over 100 users.
Can you advise on the setup.
Hardware:
CPU: E3-1240 v3 @ 3.40GHz
RAM: 32Gb 1600Mhz
Drives: Plextor M6Pro


postgresql.conf
shared_buffers = 8GB
work_mem = 128MB
maintenance_work_mem = 2GB
fsync = on
synchronous_commit = off
wal_sync_method = fdatasync
checkpoint_segments = 64
seq_page_cost = 1.0
random_page_cost = 6.0
cpu_tuple_cost = 0.01
cpu_index_tuple_cost = 0.0005
cpu_operator_cost

With this config, it gives out 40 Parrots.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
F
Fixid, 2015-07-02
@azazelpw

I would enable query logging to the database, put one user and let him do several standard procedures (create/delete, postings, reports)
Then queries in a loop and in several threads until the server bogs down
. So you can calculate the approximate load to failure

M
Michael, 2015-07-02
@id194695811

Possibly ApacheBench.

S
Sergey, 2015-07-09
@CHEBURASHKA87

As already mentioned, you can check it either with the help of load testing, or in real work. Iron can and will pull out a load of 100 users in a 100 GB database, but if managed locks are not imposed in the configuration, then PostgreSQL imposes locks on the entire table. There may be waits on locks, because of which you think that the process is hanging due to bad hardware, but in fact the problem is in the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question