yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
main
doc-exports/docs/opengauss/umn/opengauss_opti_0020.html
Ru, Li Yi 0b0c254b4c gaussdb_umn_1128 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2025-01-13 14:51:57 +00:00

2.5 KiB
Raw Permalink Blame History

Performance Tuning Process

To fine-tune GaussDB performance, you need to identify performance bottlenecks, adjust key parameters, and optimize SQL statements. During the tuning, factors such as system resources, throughput, and loads can be used to locate and analyze performance problems to ensure that the system performance is acceptable.

Various factors must be considered during GaussDB performance tuning. Therefore, relevant personnel must know well about knowledge, such as system software architecture, hardware and software configuration, database parameter configuration, concurrency control, query processing, and database applications.

Performance tuning may need to reboot the instance and interrupt services. Therefore, after the service goes live and when the instance needs to be rebooted, you must send the request to related management department about the operation window time for approval.

Tuning Process

Figure 1 shows the tuning process.

Figure 1 GaussDB performance tuning process
Parent topic: Performance Tuning
<script language="JavaScript"> </script>