how to tune the huge memory system?
Hi experts, I have a one question.
Recently, I am migrated Database from Oracle to Mariadb 10.2.26 on Huge memory system(780GB) with innodb_buffer_pool_size is 128GB. However I met the big problem. It is the MariaDB Hang. Every DB queries were slow queries from the WAS systems and all DB connection pools of WAS systems were full. I had no choice, So I did to restart all system(DB and WAS).
Most queries of my DB System is insert or update. I don't have experience of mariadb.
My question is the best tuning point for huge memory system.
I can not sleep for a week.
Plz, Help me...
Answer Answered by Daniel Black in this comment.
I'm not sure why you migrated if you don't have the experience.
I can't tell what is WAS or DB.
Oracle queries sometime don't perform well on MariaDB and vice-verse. Start with the slow query log. Use `EXPLAIN` and start analyzing them.
With a large amount of writes ensure `innodb_log_file_size`/ `innodb_log_files_in_group` are increased. `SHOW GLOBAL STATUS` along with your configuration will be useful. MariaDB's error log may also be useful.
Regarding hanging check table cache variables and ensure they are sufficient for you active workload.
Perhaps seeking help from a consultant would be a prudent investment.
