Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Take cloud MySQL resource quickly is normal? #11491

Closed
ashesofdream opened this issue Dec 21, 2024 · 1 comment
Closed

Take cloud MySQL resource quickly is normal? #11491

ashesofdream opened this issue Dec 21, 2024 · 1 comment

Comments

@ashesofdream
Copy link

Environmental Info:
K3s Version:
1.31

Cluster Configuration:

2 server deployment with a cloud mysql from TiDB , 1 agent , 2 work pod, use ingress-nginx instead of pacifik.
Describe the bug:

CloudSql show that, mysql are executed about 15 times queries per second and take request unit ( a way to count consumption of resources
) quickly. Is that normal?

Actual behavior:

For example:

SELECT
  (
    SELECT
      max (`rkv`.`id`) AS `id`
    FROM
      `kine` AS `rkv`
  ),
  (
    SELECT
      max (`crkv`.`prev_revision`) AS `prev_revision`
    FROM
      `kine` AS `crkv`
    WHERE
      `crkv`.`name` = ?
  ),
  `kv`.`id` AS `theid`,
  `kv`.`name` AS `thename`,
  `kv`.`created`,
  `kv`.`deleted`,
  `kv`.`create_revision`,
  `kv`.`prev_revision`,
  `kv`.`lease`,
  `kv`.`value`,
  `kv`.`old_value`
FROM
  `kine` AS `kv`
WHERE
  `kv`.`name` LIKE ?
  AND `kv`.`id` > ?
ORDER BY
  `kv`.`id` ASC
LIMIT
  ?

are executed 74.9 k times in 4 hour.
in the mean while ,

INSERT INTO
  `kine` (
    `name`,
    `created`,
    `deleted`,
    `create_revision`,
    `prev_revision`,
    `lease`,
    value,
    `old_value`
  )
VALUES
  (...)

are executed 40.09k times.

Is this normal ?may be deployment a local mysql is more suitable?

Additional context / logs:

@brandond
Copy link
Member

This is normal. The datastore is constantly accessed in order to support reads and writes from clients and the control plane.

@github-project-automation github-project-automation bot moved this from New to Done Issue in K3s Development Dec 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Done Issue
Development

No branches or pull requests

2 participants