[bug] The EnsureMysqlConf function calculates mysql parameters incorrectly.

[runkecheng]

Describe the problem

The cpu is calculated with PodSpec.Resources, but PodSpec.Resources is not set as the resource quota of the pod.

https://github.com/radondb/radondb-mysql-kubernetes/blob/main/cluster/cluster.go#L282

To Reproduce

Expected behavior

Environment:

[runkecheng]

This will cause the buffer_pool_instances parameter to not be set correctly.

[runkecheng]

case1

• innodb_buffer_pool_instances should be 1. √
• innodb_buffer_pool_size should be 128mb. √

Pod Spec:
...
    Resources:
      Limits:
        Cpu:     500m
        Memory:  1Gi
      Requests:
        Cpu:        100m
        Memory:     256Mi
...

mysql> SHOW VARIABLES LIKE 'innodb_buffer_pool_%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_instances        | 1              |
| innodb_buffer_pool_size             | 134217728      |
+-------------------------------------+----------------+
11 rows in set (0.01 sec)

case2

-innodb_buffer_pool_instances should be 2.×
-innodb_buffer_pool_size should be 2.5Gi but its 128m. ×

Pod Spec:
...
    Resources:
      Limits:
        Cpu:     4000m
        Memory:  8Gi
      Requests:
        Cpu:        2000m
        Memory:     4Gi
...

mysql> SHOW VARIABLES LIKE 'innodb_buffer_pool_%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_instances        | 1              |
| innodb_buffer_pool_size             | 134217728      |
+-------------------------------------+----------------+
11 rows in set (0.01 sec)

[runkecheng]

after modification:

    Resources:
      Limits:
        Cpu:     4000m
        Memory:  8Gi
      Requests:
        Cpu:        2000m
        Memory:     4Gi

• innodb_buffer_pool_instances should be 2. √
• innodb_buffer_pool_size should be 2.5G(it must be an integer multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances). √

mysql> SHOW VARIABLES LIKE 'innodb_buffer_pool_%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_instances        | 2              |
| innodb_buffer_pool_size             | 2684354560     |
+-------------------------------------+----------------+
11 rows in set (0.01 sec)