Lucifer Li

All generations.

linuxWed, 31 Jan 2024

查询CPU信息

linux bash command that: 查询内存信息 # free -m total used free shared buffers cached Mem: 3.9G 1.4G 2.4G 0B 0B 0B 0B -/+ buffers/cache: 1.4G 2.4G Swap

linuxWed, 31 Jan 2024

获取docker进程

linux bash command that: 获取docker进程 docker ps -a | grep -v '^$' | awk '{print $1}' | xargs kill -9 2. 获取docker容器id docker ps -a | grep -v '^$' | awk '{print $1}' | xargs docker inspect -f '{{range .State.Running}}{{

text to sql syntaxWed, 31 Jan 2024

根据app_id来分组统计数量 CREATE TABLE aiops_cost ( `app_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `app_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `costCenter` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `serviceType` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `productCatalog` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `id` bigint NOT NULL AUTO_INCREMENT )

You can use the following query to get the count of app_id for each month: SELECT MONTH(created_at) AS month, COUNT(*) AS count FROM app GROUP BY MONTH(created_at) ORDER BY MONTH(created_at);

linuxWed, 31 Jan 2024

获取前10进程

linux bash command that: 获取前10进程,并获取每个进程占用的内存大小,并输出到文件。 代码如下: #!/bin/bash #获取前10进程,并获取每个进程占用的内存大小,并输出到文件。 ps -ef | grep -v grep | awk '{print $2}' | sort -nr

linuxThu, 01 Feb 2024

获取前10进程

linux bash command that: 获取前10进程,并获取每个进程占用的内存大小,并输出到文件。 代码如下: #!/bin/bash #获取前10进程,并获取每个进程占用的内存大小,并输出到文件。 ps -ef | grep -v grep | awk '{print $2}' | sort -nr

linuxWed, 31 Jan 2024

CPU高如何排查

op -n 1 | grep "Cpu" | awk '{print $2}' | sort -nr | head -n 1 } # Get the current CPU usage get_cpu_usage() { # Get the current CPU usage # # Returns the current CPU usage as a percentage # # Example: # # get_cpu_usage # # Returns

linuxWed, 31 Jan 2024

获取docker进程

linux bash command that: 获取docker进程 docker ps -a | grep -v '^$' | awk '{print $1}' | xargs kill -9 2. 获取docker容器id docker ps -a | grep -v '^$' | awk '{print $1}' | xargs docker inspect -f '{{range .State.Running}}{{

Want to kickstart your project?Use the new AI Studio to create your code