<commit_before># Default values for octavia.
# This is a YAML-formatted file.
# Declare variables to be passed into your templates.

replicaCount: 3

api_port_internal: 9876
api_backdoor: false

global:
  imageNamespace: monsoon
  dbUser: octavia
  rpc_response_timeout: 60

db_name: octavia

mariadb:
  enabled: true
  name: octavia
  initdb_configmap: octavia-initdb
  persistence_claim:
    name: db-octavia-pvclaim

ingress:
  annotations:
    vice-president: "true"
    disco: "true"

mysql_metrics:
  db_name: octavia
  db_user: octavia
  customMetrics:
    - help: Total Load Balancer count
      labels:
      - "status"
      - "host"
      name: octavia_loadbalancers_count_gauge
      query: |
        SELECT
          COUNT(*) AS count_gauge,
          provisioning_status AS status,

        FROM load_balancer
        GROUP BY load_balancer.provisioning_status;
      values:
      - "count_gauge"
    - help: Worker agent seconds since the last heartbeat
      labels:
      - "host"
      name: octavia_monitor_agents_heartbeat_seconds
      query: |
        SELECT
          compute_flavor AS host,
          (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(MAX(updated_at))) AS heartbeat_seconds
        FROM amphora
        WHERE status = 'READY'
        GROUP BY compute_flavor;
      values:<commit_msg>[octavia] fix sql metric<commit_after># Default values for octavia.
# This is a YAML-formatted file.
# Declare variables to be passed into your templates.

replicaCount: 3

api_port_internal: 9876
api_backdoor: false

global:
  imageNamespace: monsoon
  dbUser: octavia
  rpc_response_timeout: 60

db_name: octavia

mariadb:
  enabled: true
  name: octavia
  initdb_configmap: octavia-initdb
  persistence_claim:
    name: db-octavia-pvclaim

ingress:
  annotations:
    vice-president: "true"
    disco: "true"

mysql_metrics:
  db_name: octavia
  db_user: octavia
  customMetrics:
    - help: Total Load Balancer count
      labels:
      - "status"
      - "host"
      name: octavia_loadbalancers_count_gauge
      query: |
        SELECT
          COUNT(*) AS count_gauge,
          provisioning_status AS status,
          server_group_id as host
        FROM load_balancer
        GROUP BY load_balancer.provisioning_status;
      values:
      - "count_gauge"
    - help: Worker agent seconds since the last heartbeat
      labels:
      - "host"
      name: octavia_monitor_agents_heartbeat_seconds
      query: |
        SELECT
          compute_flavor AS host,
          (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(MAX(updated_at))) AS heartbeat_seconds
        FROM amphora
        WHERE status = 'READY'
        GROUP BY compute_flavor;
      values:
{'fraction_non_alphanumeric': 0.06731488406881077, 'fraction_numerical': 0.005235602094240838, 'mean_word_length': 2.684573002754821, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2203684', 'n_tokens_mistral': 893, 'n_tokens_neox': 846, 'n_words': 225}