Performance Tuning

Hi, We started up a new DB that has 50plus tables. Each table may have 10-100's of Gigabytes of data. So the tables are huge. When I join two tables, the query never returns the data - even hours of waiting. I do have indexes on the tables for the fields in my where clause.

In the configuration file, we have set innodb_buffer_pool_size to 128G, innodb_flush_mtheod=O_DIRECT and the tmp-table-size =16G. Are there other parameters in the config file that should be looked at?

How does one determine if the issue is due to hardware, configuration (page swapping, buffer size and etc) or anything else for that matter? What is the best way to try to troubleshoot the performance issue?

Any advice on how to go about tuning our database is greatly appreciated.

Thanks in advance.


Answer Answered by Ian Gilfillan in this comment.

EXPLAIN can help in understanding how your indexes are used in a particular query.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.