New answers tagged

1 vote

MySql Aurora - how often to run ANALYZE TABLE?

It's rare for ANALYZE TABLE to make any significant improvement on query optimization. You can run this command pretty freely. It's pretty low-impact. All it does is read a few pages of InnoDB ...
Bill Karwin's user avatar
  • 14.3k
-1 votes

MySQL Amazon Aurora - a few slow queries causing extreme performance issues

Your 3 questions, answers Yes Yes max_execution_time Yes View my profile.
Wilson Hauck's user avatar
  • 1,728
1 vote

How to determine if it is necessary to increase the sga and the pga in Oracle database

This query will show you what the database would like for the SGA. A similar query is possible for the PGA. SELECT TO_CHAR( al.execution_start, 'dd Mon yyyy HH24:MI:SS') AS finding_time aa....
Strider's user avatar
  • 11

Top 50 recent answers are included