Tag - Threads_Running

How MySQL ‘queries’ and ‘questions’ are measured

MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand:

Shell

Queries

The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does […]

Read more

Why do we care about MySQL Performance at High Concurrency?

In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries.
The question is how common is it in production ? The typical metrics to use […]

Read more