search

tarantool / tarantool

Get your data in RAM. Get compute close to data. Enjoy the performance.
https://www.tarantool.io
Other
3.42k stars 379 forks source link

Account SQL statements in box.stat #4024

Open locker opened 5 years ago

locker commented 5 years ago

The number of processed SQL statements is not reported anywhere. We should add a new field to box.stat for them (STATEMENT?), otherwise it's difficult to figure out what's going on with the database.

Also, all basic write operations executed by an SQL statement are accounted in box.stat (see DELETE, INSERT, REPLACE, UPDATE), but read operations (SELECT) are not. We should account those too, for consistency.

kostja commented 5 years ago

Accounting the total number of SQL statements is not of much use. DML, queries and DDL statements should be accounted separately at least. Let's add box.stat.sql() with a separate table of SQL stats.