Project on-line less than one months, Zabbix data incredibly fast 100G, too many monitoring items, too large data volume, Zabbix load, temporarily do not want to upgrade hardware, had to dig inside, clear the historical data; generally retain 1 months of data, Zabbix this project is only to do monitoring alarm, Data retention too much not much reference significance;Generally these tables are too big, history, History_uint,history_log, and some direct
allocated from the D disk's compressed volume (that is, the F disk) is part of the back of the d disk, which is not sequential with the c disk space, therefore, it cannot be merged with drive C. Therefore, I want to first split a GB F disk from disk D, then back up the data on disk D and save it to another partition (Disk e) on the computer ).
To back up hard disk data, we must first install a PE System in the USB flash drive (I installed the cabbage USB flash drive system Thunder: // handler =
initialization parameter file. You can also use the STARTUP command to specify a text file to start the database. In this case, the server parameter file does not work.
Default initialization parameter file name and default pathDefault platform name default pathWindows init % ORACLE_SID %. ora % ORACLE_HOME % \ database
Initialize the parameter file template (unix platform)Control_files = (/u0d/lcg03/control.001.dbf,/U0d/lcg03/control.002.dbf,/U0d/lcg03/control.003.dbf)Db_name = lcg03Db_domain
In my opinion, there are two advantages of using LVM: it is convenient to dynamically expand/shrink partition size; it is not limited by the number of partitions.There is a very good LVM usage Introduction At the howtoforge Website: http://www.howtoforge.com/linux_lvmHere we record our operation process:
1. Create physical volumn using pvcreate[Root @ jcwkyl ~] # Fdisk-l
Disk/dev/SDA: 320.0 GB, 320072933376 bytes255 heads, 63 sectors/track, 38913 CylindersUnits = cylinders of 16065*512 = 8225280
communication technology and large-capacity data centers. To cope with the challenges of big data, the application of cloud computing virtualization network technology is an inevitable technological development trend, facing massive data storage and data processing, to improve resource utilization efficiency and data analysis and computing capabilities, data centers will use a large number of virtualized cloud computing technologies, including server virtualization technology, network virtualiz
In Linux, when the middleware log file is deleted, df shows that the disk space is still not released. When the disk size exceeds the standard, an alarm is triggered. In this case, it is wise to master the df and du commands. Df allows you to view the size, usage ratio, file system, and its mount point of a level-1 folder, but there is nothing to do with files. Du allows you to view the file and folder size. They are very effective when used in combination. For example, you can use df to check w
remotehost-I .5-0 2
Run the test for 2 seconds before collecting results, to allow for TCP slowstart to finish. (Omit mode)
Iperf3-Z-c remotehost
UseSendfile() System call for "Zero Copy" mode. This uses much less CPU.
Iperf3-c 192.168.12.12-T s1 iperf3-c 192.168.12.13-T s2
Run tests to multiple interfaces at once, and label the lines to indicate which test is which
Iperf3-c remotehost-J
Output the results in JSON format for easy parsing.
Iperf3-
based on data and performance requirements.
② Server Load balancer (such as LVS)
Partition:/boot100-200M, 1-2 times of swap memory ,/,
Advantage: it is simple and convenient. Only a small amount of data is forwarded.
RAID solution: large data volume and high importance. RAID 1 can be used.
③ RSserver under Server Load balancer
Partition:/boot100-200M, 1-2 times of swap memory ,/
Advantage: it is simple and convenient, because there are multiple machines and there are low data requirements.
RAID
diskGenerally, the disk structure of a virtual machine adds a data disk to the system disk. When the system fails, you can create a new system disk without losing the data disk.Add disk operation:Cd/var/lib/libvirt/images/enter the disk storage directory qemu-img create-f raw test_add.img 100G to create a G disk virsh attach-disk tomcat_01/var/lib/libvirt /images/test_add.img vdb -- cache none Dynamic Disk AdditionThis method dynamically adds disks,
partition
Move number start end move Partition
Name number name name the partition NUMBER with the specified NAME
Print [free | NUMBER | all]: Display partition tables, specified partitions, or all devices
Quit exits the parted program.
Rescue start end repairs lost partitions
Resize number start end change partition size
Rm NUMBER Delete Partition
Select DEVICE select the DEVICE to be changed
Set number flag state Change partition FLAG
Toggle [NUMBER [FLAG] sets or removes the partition tag
Un
.
Stored procedures and data to be processed are stored on the same computer running SQL Server. Using Stored Procedures to query local data is naturally very efficient.
Generally, a stored procedure is called by the client through the name of the stored procedure, reducing the amount of network transmission and adding the system speed.
Stored Procedures also have convenient features like C-language subfunctions that are called and return values.
Question 2:Common VI comman
Document directory
4. Performance Tuning
The purpose of this platform is to facilitate log query During O M and R D. Kibana is a free web shell. logstash integrates various log collection plug-ins and is also an excellent regular-cut log tool. elasticsearch is an open-source search engine framework (supporting cluster architecture ).
1 installation requirement 1.1 theoretical Topology
1.2 installation environment 1.2.1 hardware environment
192.168.50.62 (hp dl 385 G7, Ram: 12g, CPU: AMD
).Thread_cache_size = 8 # maximum number of cached threads. When the client connection is disconnected, if the total number of client connections is less than this value, the thread that processes the client task is put back into the cache. In the case of high concurrency, if this value is set too small, many threads will be created frequently, the thread creation overhead will increase, and the query efficiency will also decrease. In general, if the application side has a good multi-threaded p
100g or even g databases, however, hardware cannot meet the requirements. Especially in a mobile network environment like today, mobile phones are a relatively simple and confusing small software. Therefore, it is impossible to implement many complex functions and must be powerful in the server field, in this way, powerful functions can be provided. For example, voice recognition is implemented on the server. It can be seen that the development of se
Tags: vmkfstools one of the snapshot disks it depends on Snapshot VM hard disk resizing
One virtual machine with a hard disk of only 60 GB requires more disk space allocated. Know vmkfstools-x 100g win2k8. vmdk. Otherwise, shut down, back up, and run the command in SSH. Then you are dumpfounded. the following error occurs when the VM is started:
Error message for win2k8: cannot open the disk '/vmfs/volumes/54391d67-a6a907a0-e7b9-1c6f6-5aa6275/win2k8/
is insufficient. Observe the value of the Processor \ Interrupts/sec counter. The measurement of this counter comes from the input.How to analyze LoadRunner results
Page 1st: Analysis gathering point page 2nd: identifying Application Problems text Tag: Test tool performance test LoadRunner [IT168 technical documentation] 1. the most important and difficult part of LoadRunner is the analysis of test results. the remaining recording and pressurization test settings can be easily mastered through
overqualified ......) : When installing, be aware that: After the installation is complete (EXT2FSD did not create a shortcut icon, I was mapped to the desktop in the folder):(Note: UAC and 360 Please close, if there is a problem please check whether it is UAC and 3,602 Cow Meng caused!) ) Then using partition Assistant to separate the EXT3 format partition for the installation files, I separated the 20G: The remaining 100G I am going to use to i
habitual use of Win7, today's whim wants to try the gpt+win7 modeLab Environment:1, machine for Thinkpad e4502, Winpe for it free Sky PE 3. Mirror the ghost image for the earth ghost Download After you modify the streamlined Win7The steps are as follows: 1, uefi Mode enters winpe diskgen Delete the original partition, look at the disk mode, if mbr gpt mode, then click on Create partition, remove msr partition tick, as long as esp partition is good, size default 100 2, establish the pri
My notebook has 2 HDD, disk 0:120g SSD, disk 1:1t machine.Originally only in the SSD installed WIN10, and then the mechanical division of 2 to save data, a compression of the expansion of the disk 1 into a dynamic disk, then did not notice, then want to install Ubuntu, and Disk 1 on the compressed 100g of free space, but the installation of Ubuntu can not actually choose this space, There is no way to put Win10 also reload, SSD divided into several pa
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.