MongoDB and MySQL

Purpose   Test the read and write performance of mysql and mongodb illustrate 1. mongodb uses the latest version 2.4 2. Mysql uses 5.0.95, and the storage engine uses MYISAM (the measured read and write performance of INNODB is only a fraction of that of MYISAM) 3. The test data has only two fields, id: Integer (index field) increasing from 0 data: data field, tested the performance of data 1KB and 24KB respectively 4. When testing read performance, the query id is a random value in the inserted id 5. There are 50 concurrent read and write processes 6. Pressing machine: 4 cores/8G, DB machines were tested and deployed on ordinary machines (4 cores/8G memory) and high-end machines (24 cores/132G memory), and the hard disk is an ordinary mechanical hard disk 7. The pressing machine and the DB machine are directly connected through a 1000M network card 1. DB is deployed on a common machine 1. The data size is 1KB, and the number of reads and writes is 400W a) mongodb the Total Data Size QPS iowait net Read 11G 14600 <1% 20Mb/s Write 11G 10630 ~100% <17Mb/s b) mysql the Total Data Size QPS iowait net Read 4G…