When migrating a database to a multi-database server, in order to save time, we may directly detach a database and then directly use the MDF file to attach the database to another server. In this case, all cache plans will be cleared out of the buffer zone. As a result, the CPU usage will remain high for a period of time.
Apart from separation, the cache will be
Top:Top-16:41:04 up 184 days, 2 users, load average: 19.97, 18.38, 18.36Task: 584 total, 1 running, 583 sleeping, 0 stopped, 0 zombieCpu (s): 0.0% us, 0.0% sy, 41.2% ni, 58.7% id, 0.0% wa, 0.0% hi, 0.0% si, 0.0% stMem: 65923008 k total, 34622724 k used, 31300284 k free, 315684 k buffersSwap: 33030136 k total, 0 k used, 33030136 k free, 24200968 k cachedPid user pr ni virt res shr s % CPU % mem time + COMMAND28518 root 20 0 1652 m 62 m 1172 S 2014.5 0.
method One: Reduce the computer to start the service item. Click the "Start" menu in the lower left corner of the computer desktop, and enter Msconfig in the run, as shown:
After you enter, press ENTER to enter the startup settings item, where you will find the startup and cancel unwanted startup items, as shown in figure:
Method Two: End the corresponding process in Task Manager. At the same time, press the Ctrl+alt+del key combination, open Task Manager, in which to f
not be reduced. A server with a large memory can be set to 0 or a large number. Servers with small memory can be set to 30, 50, or 100 to prevent memory overflow.Another solutionIf you have no problem before, and suddenly there is a problem and the server has installed Kingsoft drug overlord, this may be because Kingsoft drug overlord or the upgrade Genie has modified WINSOCK.SolutionRun the following command in Windows cmd: The code is as follows:Copy code Netsh winsock reset There may al
Transfer from http://www.cnblogs.com/jiqiubo/archive/2012/02/25/2367791.html
Example one: Using the command line Sar-u T nFor example, sampling every 60 seconds, sampling 5 times in a row, observing CPU usage, # Sar-uScreen display:SCO_SV scosysv 3.2v5.0.5 i80386 10/01/200114:43:50%usr%sys%wio%idle (-u)14:44:50 0 1 4 9414:45:50 0 2 4 9314:46:50 0 2 2 9614:47:50 0 2 5 9314:48:50 0 2 2 96Avera
How to deal with the high usage of win10cpu common processing method, win10cpu Processing Method
Microsoft's Windows 10 system does not have high hardware requirements, but many users find that their CPU resources are fully occupied by the system, and they cannot check whether anything is occupied, the following descr
preceding statistics. 1 and 2 represent the data of the first and second rows respectively. Total1: total physical memory. Used1: indicates the total quantity allocated to the cache (including buffers and cache), but some of the caches are not actually used. Free1: unallocated memory. Shared1: shared memory, which is not used by the general system and is not discussed here. Buffers1: Number of buffers allocated by the system but not used. Cached1: Number of cache allocated by the system but not
What is memory usage
Memory usage is the percentage of physical memory that systems and applications occupy. When the computer is in standby memory will not increase, but if the more open program, memory usage will rise correspondingly, which is caused by high memory usage.
On a multi-core or multiprocessor computer, especially on a computer that supports dynamic CPU frequency tuning, QueryPerformanceFrequency () under Windows system gets Hpet(if present), while the QueryPerformanceCounter () gets Hpet (if there is a high precision event timer (hiPrecision event timer)) The number of clock cycles since power-on, independent of CPU f
Recently, I was working on the benchmark of DB2 and found that the memory usage of the database was very high. Because the benchmark test was performed, there were not many tables, and the test was mainly performed on one of the tables.
Recently, I was working on the benchmark of DB2 and found that the memory usage of the database was very
1, first of all, how do we judge the memory usage rate is too high? According to some software standards, one is to look at the CPU utilization rate. If the CPU usage is greater than 15%, it is normal for the memory usage rate to
Use MySQLSlowLog to solve the problem of high usage of MySQLCPU bitsCN.com
Use MySQL Slow Log to solve the high CPU usage problem of MySQL
In a Linux VPS system, sometimes MySQL occupies a high
Today, someone told me that the memory on the Linux server is not fast enough, 128G of memory, will be used up immediately. I was startled, the application on this server is now very small, ah, how the utilization will be very high. First use Zabbix to see the next, memory remaining space is still very big, there is 117G of spare ah. Then log on to the server again and look at:[[Email protected] ~]$ toptop- One: A:GenevaUp415Days1: .,2Users, load aver
The resource usage of the server has been high. Please analyze it for a moment. Thank you-general Linux technology-Linux technology and application information. For more information, see the following. Cpu % men %
44 75.8
40 75.6
25 75.4
17 75.1
15 73.1
4 73.4
This is the percentage of cpu and memory
are only taking up less memory2. When the request arrives, the thread pool allocates an idle thread to the request and processes the request into the thread3. When the thread pool pre-sets the number of threads that do not meet the requirements too much or too little, you can manually adjustBenefits of the ③ thread pool1. Reduces the number of times a thread is created and destroyed, and each worker thread can be reused to perform multiple tasks.2. You can adjust the number of threads in the th
Recently discovered that Svhost always consumes a lot of resources (memory, CPU) when it is powered on. After some Baidu, take its essence to its dross, a simple summary of the general how to solve the problem:
Open Task Manager and find the PID of the resource-intensive svhost process, assuming it is 123
Run cmd (Windows function key +r, enter CMD and return), enter command: TASKLIST/SVC | Findstr "123". Returns the result for the correspond
Original link: DB2 Memory usage optimization
Recently in doing DB2 benchmark, found that the memory of the database is particularly high, because it is done benchmark test, so the table is not much, and mainly for one of the tables to do the test, when the data of this table is fast to 100 million, with the top query system status as follows
# top
top-20:06:34 up to 5 days, 22:20, users, Load average:18.53
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.