MongoDB VS Mysql 簡單測試.
廢話不多說.
MongoDB 使用 MongoDB Object Document Mapper測試.
Mysql 使用 Object Relational Mapper測試.
MongoDB部分:
config.php
register();
$classLoader = new ClassLoader('Doctrine\ODM\MongoDB', __DIR__ . '/../../lib');
$classLoader->register();
$classLoader = new ClassLoader('Doctrine\MongoDB', __DIR__ . '/../../lib/vendor/doctrine-mongodb/lib');
$classLoader->register();
$classLoader = new ClassLoader('Symfony', __DIR__ . '/../../lib/vendor');
$classLoader->register();
$classLoader = new ClassLoader('Documents', __DIR__);
$classLoader->register();
$config = new Configuration();
$config->setProxyDir(__DIR__ . '/Proxies');
$config->setProxyNamespace('Proxies');
$config->setHydratorDir(__DIR__ . '/Hydrators');
$config->setHydratorNamespace('Hydrators');
$config->setDefaultDB('doctrine_odm_sandbox');
//使用safe模式
$con = new Connection('localhost',array('safe'=>true, 'w' => 2,'wtimeoutMS' => 2000));
//使用一般模式
//$con = new Connection('localhost');
$reader = new AnnotationReader();
$reader->setDefaultAnnotationNamespace('Doctrine\ODM\MongoDB\Mapping\\');
$config->setMetadataDriverImpl(new AnnotationDriver($reader, __DIR__ . '/Documents'));
$dm = DocumentManager::create($con, $config);
測試新增用index.php
persist($Account);
$dm->flush();
}
$mtime = explode(' ', microtime());
$times=number_format(($mtime[1] + $mtime[0] - $starttime), 8);
echo "saft Inster time $times \n";
測試一般寫入1000筆:
$php index.php
Normal Inster time 14.19290113
測試saft寫入1000筆:
$ php index.php
saft Inster time 14.25004005
更新測試index.php:
更新七筆資料．
getRepository('Documents\Account')->find('4e382626e08239cbcf000027');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000026');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000025');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000024');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000023');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000022');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$Account_old = $dm->getRepository('Documents\Account')->find('4e382626e08239cbcf000021');
$Account_old->setName('Test Account'.rand(1,99999));
$dm->persist($Account_old);
$dm->flush();
$mtime = explode(' ', microtime());
$times=number_format(($mtime[1] + $mtime[0] - $starttime), 8);
echo "Update time $times \n";
使用apache ab做測試表示每個連線都對此7筆資料做更新.**
saft寫入:
$ ab -k -c 20 -n 1000 http://localhost/mongodb_odm/tools/sandbox/
....
Server Software: nginx
Server Hostname: localhost
Server Port: 80
Document Path: /mongodb_odm/tools/sandbox/
Document Length: 24 bytes
Concurrency Level: 20
Time taken for tests: 15.655 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 0
Total transferred: 187000 bytes
HTML transferred: 24000 bytes
Requests per second: 63.88 [#/sec] (mean)
Time per request: 313.110 [ms] (mean)
Time per request: 15.655 [ms] (mean, across all concurrent requests)
Transfer rate: 11.66 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 2 9.2 0 165
Processing: 28 307 312.6 238 3510
Waiting: 28 306 312.7 236 3510
Total: 29 309 313.2 240 3510
saft更新:
$ ab -k -c 100 -n 2000 http://localhost/mongodb_odm/tools/sandbox/
........
Server Software: nginx
Server Hostname: localhost
Server Port: 80
Document Path: /mongodb_odm/tools/sandbox/
Document Length: 24 bytes
Concurrency Level: 100
Time taken for tests: 32.222 seconds
Complete requests: 2000
Failed requests: 345
(Connect: 0, Receive: 0, Length: 345, Exceptions: 0)
Write errors: 0
Keep-Alive requests: 0
Total transferred: 439550 bytes
HTML transferred: 113550 bytes
Requests per second: 62.07 [#/sec] (mean)
Time per request: 1611.098 [ms] (mean)
Time per request: 16.111 [ms] (mean, across all concurrent requests)
Transfer rate: 13.32 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 3 10.6 0 101
Processing: 502 1580 525.6 1512 10122
Waiting: 502 1579 525.5 1512 10122
Total: 504 1583 525.7 1515 10122
saft暴力更新:
$ ab -k -c 100 -n 2000 http://localhost/mongodb_odm/tools/sandbox/
........
Server Software: nginx
Server Hostname: localhost
Server Port: 80
Document Path: /mongodb_odm/tools/sandbox/
Document Length: 24 bytes
Concurrency Level: 200
Time taken for tests: 166.432 seconds
Complete requests: 10000
Failed requests: 2029
(Connect: 0, Receive: 0, Length: 2029, Exceptions: 0)
Write errors: 0
Keep-Alive requests: 0
Total transferred: 2254187 bytes
HTML transferred: 624187 bytes
Requests per second: 60.08 [#/sec] (mean)
Time per request: 3328.646 [ms] (mean)
Time per request: 16.643 [ms] (mean, across all concurrent requests)
Transfer rate: 13.23 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 8 42.5 0 472
Processing: 471 3295 693.5 3211 17451
Waiting: 471 3292 693.4 3208 17451
Total: 475 3303 687.6 3216 17451
Mysql部分:
// Create EntityManager
$em = EntityManager::create($connectionOptions, $config);
## PUT YOUR TEST CODE BELOW
$mtime = explode(' ', microtime());
$starttime = $mtime[1] + $mtime[0];
for($i=1; $i<=10; $i++) {
$user = new User;
$user->setName('Test Account'.rand(1,99999));
$em->persist($user);
$em->flush();
}
$mtime = explode(' ', microtime());
$times=number_format(($mtime[1] + $mtime[0] - $starttime), 8);
echo "Inster time $times \n";
新增測試:
$ ab -k -c 20 -n 1000 http://localhost/doctrine2-orm/tools/sandbox/
........
Server Software: nginx
Server Hostname: localhost
Server Port: 80
Document Path: /doctrine2-orm/tools/sandbox/
Document Length: 24 bytes
Concurrency Level: 20
Time taken for tests: 30.952 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 0
Total transferred: 187000 bytes
HTML transferred: 24000 bytes
Requests per second: 32.31 [#/sec] (mean)
Time per request: 619.045 [ms] (mean)
Time per request: 30.952 [ms] (mean, across all concurrent requests)
Transfer rate: 5.90 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 1 1.6 0 21
Processing: 62 617 247.8 576 2659
Waiting: 62 617 247.8 576 2659
Total: 62 617 248.0 577 2665
對不起我很懶… mysql新增部分就輸一倍了.
接下去就不測了．
結論:NoSQL粉快
看一下mongodb的log
Wed Aug 3 01:04:30 [conn12232] update doctrine_odm_sandbox.accounts query: { _id: ObjectId(‘4e382626e08239cbcf000022’) } byid 142ms
Wed Aug 3 01:04:27 [conn12035] update doctrine_odm_sandbox.accounts query: { _id: ObjectId(‘4e382626e08239cbcf000023’) } byid 629ms
這竟然是slow query!!!!!! WTF