You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1.8 KiB
1.8 KiB
name | about | labels |
---|---|---|
🥇 Ask a Database Performance Question | I want to ask a database performance question. | type/question, type/performance |
Performance Questions
- What version of TiDB are you using?
-
What's the observed and your expected performance respectively?
-
Have you compared TiDB with other databases? If yes, what's their difference?
-
For a specific slow SQL query, please provide the following information:
- Whether you analyzed the tables involved in the query and how long it is after you ran the last
ANALYZE
. - Whether this SQL query always or occasionally runs slowly.
- The
EXPLAIN ANALYZE
result of this query if your TiDB version is higher than 2.1, or you can just provide theEXPLAIN
result. - The plain text of the SQL query and table schema so we can test it locally. It would be better if you can provide the dumped statistics information.
- The
EXPLAIN
result of the compared database. For MySQL,EXPLAIN format=json
's result will be more helpful. - Other information that is useful from your perspective.
- Whether you analyzed the tables involved in the query and how long it is after you ran the last
-
For a general performance question, e.g. the benchmark result you got by yourself is not expected, please provide the following information:
- Your cluster's topology architecture.
- A simple description of you workload.
- The metrics PDF generated from Grafana monitor. Remember to set the time range to the performance issue duration.