2

There are some queries in my MySQL DB that seems to take a bit of time to execute. As the data is somewhat sensitive, it is not possible for me to share it with outsiders. However, I do need assistance trying to pinpoint what's slowing down the queries.

Can this be done by me only sharing the DB structure? And perhaps the queries that I find to be slow? Or do I also need to present the data?

migrated from dba.stackexchange.com Mar 7 '16 at 2:36

This question came from our site for database professionals who wish to improve their database skills and learn from others in the community.

  • 2
    You can always hash your sensitive data. – Vérace Mar 7 '16 at 6:11
6

Questions about improving performance should include:

  • The full text of the query.
  • SQL CREATE statements for the tables and indexes involved
    Use SHOW CREATE TABLE\G
  • The version of the product you are using.
  • Number of rows in each table.
  • Query plan/explain output.
  • Brief server hardware details including:
    • The amount of RAM
    • CPU info
    • Disk configuration; and
    • Network details (if applicable).
  • Other important system/database configuration details
    Including SHOW VARIABLES LIKE '%buffer%';
  • Expected results, and ideally, some sample data (it's OK to obfuscate).
    Sample data should be in the form:
    INSERT INTO My_Table VALUES(A, B, C,...);
    ...so it can be easily copied and pasted.
  • Where possible, a SQL Fiddle*, or other off-site hosted runnable code.
  • Any constraints on answers (e.g. no new indexes).
  • Current and desired performance.

The first two are vital; the more of the rest that you can provide, the more likely your question is to attract high-quality answers.

* When it's working


MySQL experts: Please edit this Community Wiki answer to improve it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .