Tag:Utilization Rate
-
Time:2021-1-27
Today, I’d like to talk about the memory management of SQL server,How does SQL server use memory?Only after we know how to use it can we talk about how to manage it. In short,SQL Server database memory use principle is how much memory will occupy how much memory, will not automatically release memory. The reason […]
-
Time:2021-1-15
Share basisLinux performance optimizationNotes of course pictures. preface Experimental environment: Ubuntu 18.04, switch to the root authority operation To view the detailed usage of the command, you can:man xxxWhen it comes to paths, you can generallycat /x/xx/xxxWhen it comes to tools, if they are not installed, you can:apt-get install xxx CPU CPU performance index Find […]
-
Time:2021-1-14
Nethogs is an open sourcecommandLine tool (similar toLinuxTop ofcommand), which is used to count the network bandwidth utilization rate in real time by process or program. Environmental Science:CentOS Linux release 7.4.1708 (Core)ip:172.16.1.16 install Install dependency package [[email protected] ~]# yum install libpcap libpcap-devel epel-release -y Install EPEL source [[email protected] ~]# yum install epel-release -y Install nethogs […]
-
Time:2020-11-29
Background:The game project adopts agile development, version development iteration is very fast, basic 1-2 weekly version Necessity of performance test Number of performance issues in phases throughout the project Performance problems do not occur at the beginning or suddenly appear one day, but accumulate with our development progress;Later, we hope to solve problems for months […]
-
Time:2020-10-31
preface: This article will write a shell script to queryUtilization rate of CPU, memory and disk partition of Linux serverShell script is actually composed of basic shell commands, so when writing shell scripts, you need to know the commonly used commands. If you are not very clear, you can refer to this article: Linux learning […]
-
Time:2020-10-20
1. Query the usage of SGA and PGA; select name,total,round(total-free,2) used, round(free,2) free,round((total-free)/total*100,2) pctused from (select ‘SGA’ name,(select sum(value/1024/1024) from v$sga) total, (select sum(bytes/1024/1024) from v$sgastat where name=’free memory’)free from dual) union select name,total,round(used,2)used,round(total-used,2)free,round(used/total*100,2)pctused from ( select ‘PGA’ name,(select value/1024/1024 total from v$pgastat where name=’aggregate PGA target parameter’)total, (select value/1024/1024 used from v$pgastat where name=’total […]
-
Time:2020-10-15
Zhengcaiyun front end tabloid No.78 For more information on past tabloids, please visit: https://weekly.zoo.team Practice of flying pig micro front end: solution of unified operation platform To solve the pain points and improve the efficiency, the micro front-end practice of flying pig operation platform strives to bring differentiated value to the business with technology. The […]
-
Time:2020-10-14
background A project database disk alarm, disk utilization rate close to 100% $ df -Th Filesystem Type Size Used Avail Use% Mounted on /dev/vda1 ext4 99G 60G 35G 64% / devtmpfs devtmpfs 32G 0 32G 0% /dev tmpfs tmpfs 32G 69M 32G 1% /dev/shm tmpfs tmpfs 32G 7.8M 32G 1% /run tmpfs tmpfs 32G 0 […]
-
Time:2020-10-8
1、 Introduction to graces Grace is a Python based language development, which can provide monitoring and analyzing performance data for Linux or UNIX performance. Grace displays important system information on the user’s terminal and updates it dynamically, so that the administrator can master the usage of system resources in real time. Dynamic monitoring does not […]
-
Time:2020-9-30
Technical editor: mango fruit from the editorial departmentSegmentFault has he reported the official account number: SegmentFault Under pressure from the U.S. government, some U.S. companies are discussing the acquisition of tiktok’s business in some English speaking countries with byte hop, the parent company of tiktok. Both Microsoft and Oracle have shown a strong interest in […]
-
Time:2020-9-29
Write a large number of logs or a large file occupies the disk, which will cause the application to crash. For this problem, we can use a simple shell to realize the function of email alert when the disk utilization rate is close to the threshold. Environmental Science Ubuntu 16.04 mail serve Installing heirloom mailx […]
-
Time:2020-9-9
1、 Table space usage size query 1.1 the data dictionary tables in the database system obtain the relevant information of the table space; select a. A1 table space name, c. C2 type, c. Zone C3 management, b. B2 / 1024 / 1024 table space size m, (b.b2-a.a2) / 1024 / 1024 used m, Utilization of […]