qsfp28 100g

= "Heiyeluren";Insert Data-1 (innodb_flush_log_at_trx_commit=1)MyISAM 1w:3/sInnoDB 1w:219/s MyISAM 10w:29/sInnoDB 10w:2092/s MyISAM 100w:287/sInnoDB 100W: not daring to test Insert Data-2 (innodb_flush_log_at_trx_commit=0)MyISAM 1w:3/sInnoDB 1w:3/s MyISAM 10w:30/sInnoDB 10w:29/s MyISAM 100w:273/sInnoDB 100w:423/s Insert Data 3 (innodb_buffer_pool_size=1024m)InnoDB 1w:3/sInnoDB 10w:33/sInnoDB 100w:607/s Insert Data-4 (innodb_buffer_pool_size=256m, Innodb_flush_log_at_trx_commit=1,Se

)MyISAM 1w:3/sInnoDB 1w:3/sMyISAM 10w:30/sInnoDB 10w:29/sMyISAM 100w:273/sInnoDB 100w:423/s[Insert Data 3] (innodb_buffer_pool_size=1024m)InnoDB 1w:3/sInnoDB 10w:33/sInnoDB 100w:607/s[Insert Data 4] (innodb_buffer_pool_size=256m, Innodb_flush_log_at_trx_commit=1, set autocommit=0)InnoDB 1w:3/sInnoDB 10w:26/sInnoDB 100w:379/s [MySQL configuration file] (Default configuration) code is as follows copy code # MySQL Server Instance Configuration File [clien

, which records the current position of Binlog for InnoDB, and Xtrabackup_binlog_ Info records the current binlog of the entire instance position Scenario, the two locations are the same, but when both engines are present at the time of the backup, Xtrabackup_binlog_info.pos > Xtrabackup_binlog_pos_innodb.pos may appear. So we usually use the Binlog in xtrabackup_binlog_info position Ⅴ, other related issues 5.1 incremental backups--incremental-history-name=name can be used to make i

uploaded to the/USR2 directory.Note: The binary version of the compressed package has more than 200m+ size.2. Planning Data Storage DirectoryHere the system is managed using LVM, VG name vg00, add a lv named Lvdata, size set 100G, and then in the system to create/data directory, the new Lvdata mounted to the/data directory. Here's how: --创建lvdata lvcreate -L 100g -n lvdata vg00 --格式化为ext4文件系统 mkfs.ext4 /d

Author:skateTime:2014/09/28How MySQL removes temporary tables that begin with "#sql-"Symptom: After rebuilding the index, it is found that the MySQL server's disk space is almost full.Rebuild the index with the following commandMysql> ALTER TABLE Skatetab add unique index (ID, UID), drop primary key, add primary key (UID, id);In the process of rebuilding the index, because of insufficient space, the MySQL server reboot, after the restart found that the space is less than

Tags: target href data space not enough space to view replication table server throughAuthor:skateTime:2014/09/28 How MySQL removes temporary tables that begin with "#sql-" Symptom: After rebuilding the index, it is found that the MySQL server's disk space is almost full. Rebuild the index with the following command Mysql> ALTER TABLE Skatetab add unique index (ID, UID), drop primary key, add primary key (UID, id); In the process of rebuilding the index, because of insufficient space, the MySQL

Tags: system ubuntu 51cto for set meaning Sha mat automaticSystem Requirements1. Do RAID5, and install ubuntu16.04 system, partition/100g,/boot 512mb,data remaining, all use XFS files.2. Set root can be directly remote system.Specific implementation processDue to environmental limitations this system installation tutorial is implemented under virtual machinesAfter loading Ubuntu 16.04iso under a virtual machineThe default choice is Chinese installatio

The company uses the Ucloud cloud host, the database is also set up on the cloud host. As data is getting more and more slow, I decided to move to UDB. The reasons for consideration at that time were as follows:(1) Cloud host on the bottom of the virtual machine on the performance of the IO is impaired, and the UDB bottom is directly the physical machine cluster IO performance is guaranteed.(2) UDB is easy to maintain, directly can see the performance indicators and the current real-time status.

are also a challenge to memory. If you have a low level of access at a certain point in your application scenario, doing the compact and split at this time will not only complete split and compaction, but also ensure smooth read and write performance for most of the time. Compaction is unavoidable, split can be adjusted from auto to manual. By turning this parameter value to a hard-to-reach value, such as 100G, you can indirectly disable automatic sp

script content#!/bin/bash# checkEcho-e "\033[;37;34mcheck Memory size...\033[0m"If [' Free-g|grep ^mem|awk ' {print $} ' '! = 125]ThenRead-p "Memory size is ' Free-g|grep ^mem|awk ' {print $} ' G, enter innodb_buffer_pool_size (default 20G):" PoolElseEcho-e "\033[;37;32mmemory Size is 125G, Innodb_buffer_pool_size set 100g\033[0m"FiEcho-e "\033[;37;34mcheck network...\033[0m"#if! Ping-c 1-w 1 www.baidu.com >/dev/null;then echo-e "\033[;37;31mplease C

, query program RunLevel and modify RunLevel. Answer:Post power-on self-test-"MBR boot-" grub--"Loading kernel-" Start the init process-"read/etc/inittab file,/etc/init/*.conf file--" Use/etc/rc.d/ Rc.sysinit init Script-"Execute/ETC/RC.D/RC script (load/etc/rc3.d/all scripts)-" Execute/etc/rc.d/rc.local--"execute/bin/login Login ProgramQuery program Run Level: RunLevelModify RunLevel: init [0123456]6. describe the differences between soft links and hard links. Answer:Soft link refers to the c

superior management performance.2) Ext system Inode is pre-allocated and fixed size, for example, 100G partition, Inode table can only hold 131,072 inode, which means it is impossible to create 131,072 files, at the same time, the inode allocation is too small, easy to cause disk space is not fully utilized, too large , it is easy to waste disk space; Btrfs to solve this problem, using the dynamic allocation of inode, for example, each inode is only

to the first line of the fileGD jumps to the declaration of the variable at which the cursor is currently located[n]g jumps to Nth row, such as 0G, which is equivalent to gg,100g is the 100th lineFX finds the X character in the current line and jumps to; Repeat the previous F command without repeating the input FXTX is similar to FX, but only jumps to the previous word of X promptFX and FX are in the opposite direction), (jump to Upper/Next Statement

% jumps to the parentheses that match the current bracket, as currently in {, jumps to the matching}W Jump to the next word, split by punctuation or wordW jumps to the next word, long jump, as end-of-line is considered a worde jumps to the end of the next wordE jump to the end of the next word, long jumpb jumps to the previous wordB jump to the last word, long jump0 jumps to the beginning of the line, whether or not indented, jumps to the No. 0 character^ Jumps to the first character of the begi

There are four troubles in life: under the software, find the crack, install the system, with the environment.Bloggers in this week experienced a virtual machine system crashes and unfortunately played a bad host system, coincided with the Linux job inspection, it is "the leakage of the overnight rain, the ship late and the beginning of the wind." However, in desperation, bloggers found that their Windows 8.1 system is still well (the bad is Ubuntu 14.04), so under the guidance of a glimmer of h

Transferred from: http://www.cnblogs.com/benio/archive/2010/10/13/1849946.htmlWhen the size of the disk exceeds the standard, there will be alarm prompts, if you know the DF and du command is a very wise choice.DF can view the first-level folder size, usage scale, file system and its hang-in points, but there is nothing to file.Du can view the size of files and folders.It works well with both. For example, use DF to see which level of directory is too large, and then use DF to see the size of th

to the parentheses that match the current bracket, as currently in {, jumps to the matching}W Jump to the next word, split by punctuation or wordW jumps to the next word, long jump, as end-of-line is considered a worde jumps to the end of the next wordE jump to the end of the next word, long jumpb jumps to the previous wordB jump to the last word, long jump0 jumps to the beginning of the line, whether or not indented, jumps to the No. 0 character^ Jumps to the first character of the beginning o

When the size of the disk exceeds the standard, there will be alarm prompts, if you know the DF and du command is a very wise choice.DF can view the first-level folder size, usage scale, file system and its hang-in points, but there is nothing to file.Du can view the size of files and folders.It works well with both. For example, use DF to see which level of directory is too large, and then use DF to see the size of the folder or file, so you can quickly determine the crux of the problem.The fol

, down, left, right. Ctrl-f up a page Ctrl-b down one page % jumps to the parentheses that match the current bracket, as currently in {, jumps to the matching} W Jump to the next word, split by punctuation or word W jumps to the next word, long jump, as end-of-line is considered a word e jumps to the end of the next word E jump to the end of the next word, long jump b jumps to the previous word B jump to the last word, long jump 0 jumps to the beginning of the line, whether or not indented, jump

the designated hard disk, prompts the user next action will delete all hard disk data, and ask the user to confirm, if the user chooses Y or y to continue, n or N or exit exit; otherwise, let the user re-select;3. Erase all partitions on the hard drive (prompt, erase all partitions after the Sync command, and let the script sleep for 5 seconds before partitioning), and create three primary partitions for it, the first one is 200M, the second is 100G,