inst/app/assets/statements.md

In INWT/MariaDB_Monitor: Monitor for MariaDB or MySQL

title: "Untitled" output: html_document

Optimizing SQL Statements

Long runtimes or table scans are a danger sign that a query can be speeded up significantly. For tables with more than a few rows, consider redesigning the query by adding an index for one or more of the columns tested in the WHERE clause. Put extra effort into avoiding table scans for queries that perform joins or reference foreign keys. If the nature of the data means there is no way to avoid reading all the rows, then it might not be practical to make the query faster, or making it faster might involve extensive restructuring of your tables. The following chapters link to the MySQL Reference Manual with information to optimize sql statements:

• Optimizing SELECT Statements
• Optimizing DML Statements
• Optimizing Database Privileges
• Optimizing INFORMATION_SCHEMA Queries
• Other Optimization Tips

INWT/MariaDB_Monitor documentation built on March 6, 2020, 7:12 p.m.