模板
教程
環境
性能
功能
管理
MySQL 單表插入 10w+ TPS達成
裝B留念:
MySQL服務端機器配置和操作系統信息,沒有使用FlashCache哦:
|
1
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
|
# Aspersa System Summary Report ##############################
Uptime | 84 days, 19:00, 3 users, load average: 0.00, 0.21, 0.16 Platform | Linux Release | Red Hat Enterprise Linux Server release 5.4 (Tikanga) Kernel | 2.6.18-164.el5 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.5 Compiler | GNU CC version 4.1.2 20080704 (Red Hat 4.1.2-44). SELinux | Disabled Virtualized | No virtualization detected # Processor ################################################## Processors | physical = 2, cores = 8, virtual = 16, hyperthreading = yes Speeds | 16x2261.058 Models | 16xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz Caches | 16x8192 KB # Memory ##################################################### Total | 23.53G Free | 2.16G Used | physical = 21.38G, swap = 240.00k, virtual = 21.38G Buffers | 1.03G Caches | 13.60G Dirty | 156 kB UsedRSS | 6.1G Swappiness | vm.swappiness = 60 DirtyPolicy | vm.dirty_ratio = 40, vm.dirty_background_ratio = 10 # Mounted Filesystems ######################################## Filesystem Size Used Type Opts Mountpoint /dev/sda10 766G 11% ext3 rw /uxx /dev/sda1 122M 16% ext3 rw /boot /dev/sda2 15G 67% ext3 rw / /dev/sda3 15G 76% ext3 rw /usr /dev/sda5 8.6G 2% ext3 rw /tmp tmpfs 12G 0% tmpfs rw /dev/shm # Disk Schedulers And Queue Size ############################# sda | [cfq] 128 # Disk Partioning ############################################ Device Type Start End Size ============ ==== ========== ========== ================== # Kernel Inode State ######################################### dentry-state | 297447 276749 45 0 0 0 file-nr | 3570 0 2390094 inode-nr | 220730 32 # LVM Volumes ################################################ WARNING: Running as a non-root user. Functionality may be unavailable. # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | , interface, ports Cache | Memory, BBU BBU | % Charged, Temperature C, isSOHGood=
VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= =========
PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== # Network Config ############################################# Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) Controller | Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet (rev 20) FIN Timeout | net.ipv4.tcp_fin_timeout = 60 Port Range | net.ipv4.ip_local_port_range = 32768 61000 # Interface Statistics ####################################### interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors ========= ========= ========== ========== ========== ========== ========== lo 600000000 500000 0 600000000 500000 0 eth0 0 0 0 0 0 0 eth1 0 0 0 0 0 0 eth2 0 0 0 0 0 0 eth3 0 0 0 0 0 0 eth4 1000000000 600000000 0 2000000000 450000000 0 eth5 0 0 0 0 0 0 eth6 1250000000 15000000 0 0 0 0 eth7 0 0 0 0 0 0 sit0 0 0 0 0 0 0 bond0 2500000000 600000000 0 2000000000 450000000 0 # The End #################################################### |
原文轉自：http://blogread.cn/it/article/5070
