mymail sec

Iperf is a pure bandwidth test software based on the C/S model. It can test the network card throughput. The advantage of iperf is to simply send and receive packets, to prevent hard disks from dragging down and affecting the test results. This document uses a gigabit Nic Bcom 5720 as a test environment CentOS 6.4x64 Install iperf on both machinesYuminstalliperf -- enablerepo = epel Start one of them as a server and open the firewall port 5001.Iperf-s-I 1-w 448 k The startup result is as fo

index values, 0 for uniqueness, 1 for non-unique Key_name The name of the index Seq_in_index The serial number in the index starts from 1 column_name Column Name Experiment 1: Create an indexed method create a normal index command format ceate index Prepared a database (student information) inside has created inside (class student information Form) Mysql> Show databases;+--------------------+| Database |+-

Mysql learning notes: basic operations on tables and mysql learning notes Create a table Create table Name Create table if not exists table name mysql> create database company;Query OK, 1 row affected (0.00 sec)mysql> use company;Database changedmysql> create table if not exists t_dept( -> deptno int, -> dname varchar(20), -> loc varchar(40));Query OK, 0 rows affected (0.20 sec)mysql> show tables;+------

@linwaterbin ~]# [root@linwaterbin ~]# [root@linwaterbin ~]# [root@linwaterbin ~]# echo 3 > /proc/sys/vm/drop_caches[root@linwaterbin ~]# dd if=/dev/zero of=/home/oracle/disktest bs=1M count=512 conv=fdatasync512+0 records in512+0 records out536870912 bytes (537 MB) copied, 14.9991 seconds, 35.8 MB/s[root@linwaterbin ~]# [root@linwaterbin ~]# [root@linwaterbin ~]# [root@linwaterbin ~]# echo 3 > /proc/sys/vm/drop_caches[root@linwaterbin ~]# dd if=/dev/zero of=/home/oracle/disktest bs=1M count=512

Is Global active flushed entries is the cache file handle. This handle will be closed after the current transfer is complete. IIS global object. Number of anonymous connections by web anonymous users/sec users through Web Services. Number of Blob cache refreshes after IIS global blob Cache Flushes is started on the server. Total number of successful searches in IIS global blob cache hits blob cache. Percentage of IIS global blob cache hits % blob cach

MySQL replace into and on duplicate key update test notesMysql> CREATE TABLE tbl_insert_tmp (ID int (5), Addr_number Int (ten), name varchar, primary key (ID), unique key Udx_add R_number (Addr_number));Query OK, 0 rows affected (0.05 sec)Mysql> Show CREATE TABLE Tbl_insert_tmp\g1. Row ***************************Table:tbl_insert_tmpCreate table:create Table ' tbl_insert_tmp ' (' ID ' int (5) Not NULL DEFAULT ' 0 ',' Addr_number ' int (ten) is DEFAULT

------Sequential Output--------Sequential input---random--per chr---block---rewrite--per chr---block-- --seeks--machine Size k/sec%cp k/sec%cp k/sec%cp k/sec%cp k/sec%cp/sec%cpbilling 4G 9915 87 30319 56 11685 38 9999 47326 177.6

[Arrangement] MySQL autocommit bitsCN.com [Arrangement] MySQL autocommit By default, mysql enables auto commit. You can run the following command to view the settings at the session level and global level: 01mysql> select @@session.autocommit;02+----------------------+03| @@session.autocommit |04+----------------------+05| 1 |06+----------------------+071 row in set (0.00 sec)0809mysql> select @@global.autocommit; 10+-------

============================================ ==================================== installing: sysstat i386 7.0.2-11.el5 base 182 k Transaction summary =============================================================================== = install 1 package (s) upgrade 0 Package (s) Total download size:182 k was this ok [y/n]: y downloading packages: sysstat-7.0.2-11.el5.i386.rpm | 182 kb 00:01 Running rpm_check_debug Running Transaction test finished Transaction test Transaction

tablespace;mysql> SET foreign_key_checks = 1;The following demonstration is slightly more complex, primarily to restore the entire scene, and to do a test for the 2,4 in the above steps.First, create the test dataCreate two tables here. Two identical tables are created to facilitate subsequent testing.mysql> CREATE TABLE t1 (ID int,hiredate datetime); Query OK, 0 rows affected (0.14 sec) mysql> CREATE TABLE t2 (ID int,hiredate datetime); Query OK, 0

Tag: cal. com specifies a numeric localhost character string local operationList of simple examples of functional usage Function Function Usage Example Left () Returns a substring of the corresponding length from the left edge of the string Left (str, length) Mysql> Select Left (' VSSF ', 3); +----------------+| Left (' VSSF ', 3) |+----------------+| VSS |+----------------+1 row in Set (0.00 sec