evo ga mysql (na zalost drupal nema foru da prebaci sadrzaj u drugu bazu pa sam za mysql kreirao nove strane ... isti djavo samo su strane u mysql-u nesto sitno vece (oko kilobajt))
1 MyISAM (kreten pravi tabele kao MyISAM tek sam sad skonto, sad cu da ih prebacim u InnoDB)
Code:
[root@gedora10 mysql]# ab -c1 -n1000 http://localhost/drupal/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking localhost (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests
Server Software: Apache/2.2.14
Server Hostname: localhost
Server Port: 80
Document Path: /drupal/
Document Length: 9034 bytes
Concurrency Level: 1
Time taken for tests: 15.914 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 9507000 bytes
HTML transferred: 9034000 bytes
Requests per second: 62.84 [#/sec] (mean)
Time per request: 15.914 [ms] (mean)
Time per request: 15.914 [ms] (mean, across all concurrent requests)
Transfer rate: 583.41 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 15 16 0.4 16 18
Waiting: 9 15 0.5 15 17
Total: 15 16 0.4 16 18
Percentage of the requests served within a certain time (ms)
50% 16
66% 16
75% 16
80% 16
90% 16
95% 16
98% 17
99% 17
100% 18 (longest request)
20 (myisam)
Code:
[root@gedora10 mysql]# ab -c20 -n1000 http://localhost/drupal/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking localhost (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests
Server Software: Apache/2.2.14
Server Hostname: localhost
Server Port: 80
Document Path: /drupal/
Document Length: 9034 bytes
Concurrency Level: 20
Time taken for tests: 9.079 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 9507000 bytes
HTML transferred: 9034000 bytes
Requests per second: 110.15 [#/sec] (mean)
Time per request: 181.575 [ms] (mean)
Time per request: 9.079 [ms] (mean, across all concurrent requests)
Transfer rate: 1022.63 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 1 5.6 0 70
Processing: 38 179 54.0 173 588
Waiting: 13 169 50.3 166 565
Total: 39 180 53.6 173 588
Percentage of the requests served within a certain time (ms)
50% 173
66% 191
75% 204
80% 215
90% 243
95% 271
98% 299
99% 334
100% 588 (longest request)
Code:
alter table access engine=innodb;
alter table actions engine=innodb;
alter table actions_aid engine=innodb;
alter table authmap engine=innodb;
alter table batch engine=innodb;
alter table blocks engine=innodb;
alter table blocks_roles engine=innodb;
alter table boxes engine=innodb;
alter table cache engine=innodb;
alter table cache_block engine=innodb;
alter table cache_filter engine=innodb;
alter table cache_form engine=innodb;
alter table cache_menu engine=innodb;
alter table cache_page engine=innodb;
alter table comments engine=innodb;
alter table files engine=innodb;
alter table filter_formats engine=innodb;
alter table filters engine=innodb;
alter table flood engine=innodb;
alter table history engine=innodb;
alter table menu_custom engine=innodb;
alter table menu_links engine=innodb;
alter table menu_router engine=innodb;
alter table node engine=innodb;
alter table node_access engine=innodb;
alter table node_comment_statistics engine=innodb;
alter table node_counter engine=innodb;
alter table node_revisions engine=innodb;
alter table node_type engine=innodb;
alter table permission engine=innodb;
alter table role engine=innodb;
alter table sessions engine=innodb;
alter table system engine=innodb;
alter table term_data engine=innodb;
alter table term_hierarchy engine=innodb;
alter table term_node engine=innodb;
alter table term_relation engine=innodb;
alter table term_synonym engine=innodb;
alter table url_alias engine=innodb;
alter table users engine=innodb;
alter table users_roles engine=innodb;
alter table variable engine=innodb;
alter table vocabulary engine=innodb;
alter table vocabulary_node_types engine=innodb;
alter table watchdog engine=innodb;
INNODB
1
Code:
[root@gedora10 mysql]# ab -c1 -n1000 http://localhost/drupal/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking localhost (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests
Server Software: Apache/2.2.14
Server Hostname: localhost
Server Port: 80
Document Path: /drupal/
Document Length: 9034 bytes
Concurrency Level: 1
Time taken for tests: 15.959 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 9507000 bytes
HTML transferred: 9034000 bytes
Requests per second: 62.66 [#/sec] (mean)
Time per request: 15.959 [ms] (mean)
Time per request: 15.959 [ms] (mean, across all concurrent requests)
Transfer rate: 581.76 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 15 16 0.6 16 29
Waiting: 0 15 0.9 15 28
Total: 15 16 0.6 16 29
Percentage of the requests served within a certain time (ms)
50% 16
66% 16
75% 16
80% 16
90% 16
95% 16
98% 17
99% 17
100% 29 (longest request)
5 InnoDB
Code:
[root@gedora10 mysql]# ab -c5 -n1000 http://localhost/drupal/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking localhost (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests
Server Software: Apache/2.2.14
Server Hostname: localhost
Server Port: 80
Document Path: /drupal/
Document Length: 9034 bytes
Concurrency Level: 5
Time taken for tests: 8.918 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 9507000 bytes
HTML transferred: 9034000 bytes
Requests per second: 112.13 [#/sec] (mean)
Time per request: 44.591 [ms] (mean)
Time per request: 8.918 [ms] (mean, across all concurrent requests)
Transfer rate: 1041.04 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 1.3 0 33
Processing: 16 44 24.0 39 165
Waiting: 0 35 20.6 31 146
Total: 16 45 24.1 40 165
Percentage of the requests served within a certain time (ms)
50% 40
66% 51
75% 57
80% 62
90% 75
95% 91
98% 104
99% 128
100% 165 (longest request)
20 InnoDB
Code:
[root@gedora10 mysql]# ab -c20 -n1000 http://localhost/drupal/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking localhost (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests
Server Software: Apache/2.2.14
Server Hostname: localhost
Server Port: 80
Document Path: /drupal/
Document Length: 9034 bytes
Concurrency Level: 20
Time taken for tests: 9.078 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 9507000 bytes
HTML transferred: 9034000 bytes
Requests per second: 110.15 [#/sec] (mean)
Time per request: 181.570 [ms] (mean)
Time per request: 9.078 [ms] (mean, across all concurrent requests)
Transfer rate: 1022.66 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 2.4 0 48
Processing: 51 180 48.7 170 393
Waiting: 48 169 44.0 162 378
Total: 53 180 48.7 171 396
Percentage of the requests served within a certain time (ms)
50% 171
66% 191
75% 204
80% 216
90% 248
95% 273
98% 301
99% 319
100% 396 (longest request)
toliko od mene .... obrati paznju da je MySQL sa default configom, sa
ugasenim query cache-om (posto ne znam kako se nesto slicno pali na pgsql-u pa reko da budu ravnopravni) ... ja mogu sigurno da ubrzam mysql za ovo min 20% a najverovatnije jedno 60% u odnosu na ove rezultate ... pgsql verovatno isto moze dodatno da se optimizuje ... al ovo su dakle i za jedan i za drugi neke default vrednosti (osim sto je mysql-u ugasen query cache koji ne bi napravio test validnim posto bi mysql iskesirao sve rezultate i nista ne bi ni pitao tabele)