2270 - Informix：检测和避免与存储和多节点系统相关的性能问题.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session code-2270Informix RDBMS Performance TuningVladimir KolobrodovActian Division of HCLSoftwareInformix Performance Architectvladimir.kolobrodovhcl-Informix Detecting and Avoiding Performance Issues Related to Storage and Multinode Systems010203040IntroInf

2、ormix and hardwareProcessorConcurrencyDiskNUMAIBM TechXchange|2025 IBM Corporation IntroductionPerformance of the Informix RDBS is a topic that is always relevant,especially now with faster processors having increasingly more cores.With faster processors,it is very easy to run into performance limit

3、s of the storage subsystem.Methods to detect and address storage related performance issues when deploying Informix will be discussed.3IBM TechXchange|2025 IBM Corporation This presentation aims to give generic recommendations about environments where Informix could be deployed,with the hope that it

4、 would be useful in a sense that one would be able look at the forest first,and only then,if needed,concentrate on individual trees of the technical specifics.Just like any software,Informix does not run in a vacuum.Any environment where Informix is running or is planned to be deployed,will have a p

5、rocessor,memory(RAM),and some sort of persistent storage.4IBM TechXchange|2025 IBM CorporationIBM TechXchange|2025 IBM Corporation ProcessorOver the past years,processors from various hardware vendors have become significantly faster,with single-thread execution speeds increasing by at least an orde

6、r of magnitude:Furthermore,the prevalence of multi-core processors,with 32 to 64 cores becoming increasingly common,and,systems having multiple processors,has dramatically enhanced processing capabilities.Overall,the systems performance potential grew over two orders of magnitude in the past years.5