openstack usage show --project <project_name>

admin

openstack usage show --project <project_name>
& ^+ s) N" k$ J" f
1 Y* u4 A* ]4 O: bopenstack usage show --project   项目管理信息系统      
3 f  r: v, X! [/ d  x$ d# pUsage from 2023-08-21 to 2023-09-19 on project a4364bb7d2de4e2ca9b4ffbd37053951:
+---------------+-------------+
| Field         | Value       |
  }5 x6 n6 P' I+---------------+-------------+
6 g- s0 m. @/ Y2 a9 u4 n. ]* L| CPU Hours     | 10752.01    |
| Disk GB-Hours | 67200.06    |
2 X) c) s: @& Z5 Q8 i3 r| RAM MB-Hours  | 44040233.89 |
| Servers       | 2           |
* E# {$ s  y4 s9 V. H1 n. G+---------------+-------------+

3 @4 o  T4 F9 `; F易陆发现

admin

在数据库里清理（nova库）
[root@nova-node1 ~]# mysql -p
Enter password:
, W: J6 U) h! V# @* |- EWelcome to the MariaDB monitor.  Commands end with ; or g.
/ V/ E& Q: U2 jYour MariaDB connection id is 230863
& V2 J  M' o$ X% f' }- J; P: `Server version: 5.5.50-MariaDB MariaDB Server

# N8 S; n* d1 K/ ?: R/ ~Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

3 d0 V+ z/ @/ n( x2 tMariaDB [(none)]> use nova;
0 T7 ^$ z, j- H5 i. \! \8 D* @9 cDatabase changed
MariaDB [nova]> delete from nova.services where host="nova-node2.openstack";
% c# X( z" y1 W; I! n- TQuery OK, 1 row affected (0.00 sec)
9 F3 ~! J' P0 mMariaDB [nova]> delete from compute_nodes where hypervisor_hostname="nova-node2.openstack";
Query OK, 1 row affected (0.00 sec)