1. Chris Zakrewsky
  2. as Valentina DB Server
  3. Friday, June 23 2017, 11:00 AM
  4.  Subscribe via email
If I want to quickly find the worst performance bottle-necks occurring during some extended period of time, does the Valentina Server provide any kind of time-lapsed counters for any given VDB database? Or some statistics on which (cached) query has taken the longest time to complete? Or some other performance tuning clues/statistics?

Cheers,
/Chris
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Chris,

as far as I remember - there is no slow query - feature.
I think can be easy enough added.

please place mantis feature request.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Chris Zakrewsky Accepted Answer
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
Ruslan Zasukhin Accepted Answer
There is hope that we will do something on this issue next week.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 3
Ruslan Zasukhin Accepted Answer
Hi Chris,

You can get this feature now in 7.3.3 build.
You need use Valentina Server and may be Valentina Studio.

VStudio for VDatabase now has property (in the Inspector) -- IsMonitored

You can also set this property ON/OFF using SQL command
set property isMonitored of database to 1
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 4
Chris Zakrewsky Accepted Answer
Yes, I can set this property all right, but... what's next?

How to use it?

What does it accomplish?

How can I acquire any results?

Best!
/Chris
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 5
Lynn Fredricks Accepted Answer
Chris, have you checked 7.3.3?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 6
Ivan Smahin Accepted Answer
After turn "IsMonitoring" property on you will see a new system table "__QueryStatistic__".
Now, you can get data from there as using API so via SQL.
Turning that property OFF leads to drop that table.
Comment
http://www.valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:vcomponents:vsql:reference:properties:db_props#ismonitored
  1. Ivan Smahin
  2. 2 years ago
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 7
Chris Zakrewsky Accepted Answer
Hi Ivan,

Thanks!
Now I see the actual name of the table in "Valentina Database Properties" wiki page (updated today).
This was the part I was missing.

The table has some columns I am not entirely sure I am interpreting correctly:

fld_QueryDigest - what is it?
fld_Count - is it accumulated number of invocations since the table __QueryStatistic__ was created or from some other event?

And finally, how to get the accumulated time in addition to min/max times?

Best!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 8
Ivan Smahin Accepted Answer
fld_QueryDigest - it is an internal thing (some hash from query string to find the query string effectively).
fld_Count - yes, the number of invocations.

vKernel collects statistics only if __QueryStatistic__ table exists.

"accumulated time" - no problem - we will add such a field in the next build.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 9
Chris Zakrewsky Accepted Answer
> some hash from query string

Is your hash something openly available like murmur hash or something secret?

I am asking because if I could produce the same hash on the client side it would be very handy for pairing your results from __QueryStatistic__ with actual calls in my program (assuming I can manage to beautify the actual formatting of my SQL strings to exactly match with yours).
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 10
Ivan Smahin Accepted Answer
Strictly speaking, it is internal things which might be changed in the feature.

But currently, it is murmur hash from trimmed low-case string.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 11
Chris Zakrewsky Accepted Answer
Big thanks!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 12
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.