Created
April 9, 2011 17:59
-
-
Save aaronpk/911614 to your computer and use it in GitHub Desktop.
SQL Benchmark Tests
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Linode 1 -> itself over 127.0.0.1: | |
| Finished in 5136 ms | |
| avg connect: 564 microseconds | |
| avg prepare: 71 microseconds | |
| avg execute: 176 microseconds | |
| avg fetch: 4 microseconds | |
| ---- | |
| Linode 1 -> Linode 2 over the private network: | |
| Finished in 5668 ms | |
| avg connect: 1368 microseconds | |
| avg prepare: 56 microseconds | |
| avg execute: 305 microseconds | |
| avg fetch: 4 microseconds | |
| ---- | |
| Physical Server 1 -> itself over 127.0.0.1: | |
| Finished in 5414 ms | |
| avg connect: 821 microseconds | |
| avg prepare: 167 microseconds | |
| avg execute: 315 microseconds | |
| avg fetch: 8 microseconds | |
| ---- | |
| Physical Server 1 -> Physical Server 2 over crossover gigabit link: | |
| Finished in 12135 ms | |
| avg connect: 65748 microseconds // !!!!! | |
| avg prepare: 95 microseconds | |
| avg execute: 209 microseconds | |
| avg fetch: 7 microseconds | |
| ---- | |
| Physical Server 1 -> Physical Server 2 (with skip-name-resolve in my.cnf) | |
| Finished in 5821 ms | |
| avg connect: 889 microseconds // much better!!! | |
| avg prepare: 85 microseconds | |
| avg execute: 199 microseconds | |
| avg fetch: 7 microseconds | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment