openstack usage show --project <project_name>

admin

openstack usage show --project <project_name>
' W$ ]/ t6 e# R9 G. l
openstack usage show --project   项目管理信息系统      
6 |7 l1 d  _) uUsage from 2023-08-21 to 2023-09-19 on project a4364bb7d2de4e2ca9b4ffbd37053951:
+---------------+-------------+
4 [: C" f! {2 p6 I( H+ M" C| Field         | Value       |
0 G. |8 I  }- T: Y+---------------+-------------+
! A3 {1 Y/ a: j' h3 k3 T| CPU Hours     | 10752.01    |
| Disk GB-Hours | 67200.06    |
$ K- ]  l6 K; Q| RAM MB-Hours  | 44040233.89 |
$ s4 Z$ c) T( |% p| Servers       | 2           |
  H9 j8 {3 o! }" ?' A6 B1 l+---------------+-------------+

) n( c  a4 G! E6 i( b, t  |易陆发现

admin

在数据库里清理（nova库）
[root@nova-node1 ~]# mysql -p
# _: F. W" h8 h, B9 ~Enter password:
. A1 v" C3 [9 f! a. ]Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 230863
Server version: 5.5.50-MariaDB MariaDB Server

2 z% ^5 @8 j3 B2 d+ TCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
, k4 W* n8 Z5 z1 X. C3 O9 y& x
MariaDB [(none)]> use nova;
Database changed
# T  L1 G! S0 V; p6 Y& lMariaDB [nova]> delete from nova.services where host="nova-node2.openstack";
Query OK, 1 row affected (0.00 sec)
, \$ H& R4 ~4 h% P/ fMariaDB [nova]> delete from compute_nodes where hypervisor_hostname="nova-node2.openstack";
Query OK, 1 row affected (0.00 sec)