Skip to content

Instantly share code, notes, and snippets.

@kennyj
Created September 16, 2012 02:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kennyj/3730759 to your computer and use it in GitHub Desktop.
Save kennyj/3730759 to your computer and use it in GitHub Desktop.
test result 1
■mysql
1. without my fix
3.18user 0.41system 0:04.01elapsed 89%CPU
3.19user 0.41system 0:04.02elapsed 89%CPU
3.15user 0.41system 0:03.98elapsed 89%CPU
3.16user 0.44system 0:04.03elapsed 89%CPU
3.17user 0.43system 0:04.02elapsed 89%CPU
2. with my fix
2.91user 0.38system 0:03.32elapsed 99%CPU
2.92user 0.40system 0:03.34elapsed 99%CPU
2.90user 0.41system 0:03.33elapsed 99%CPU
2.89user 0.40system 0:03.32elapsed 99%CPU
2.88user 0.40system 0:03.30elapsed 99%CPU
=> 17.1%
■postgresql
1. without my fix
3.04user 0.40system 0:04.31elapsed 80%CPU
3.02user 0.41system 0:04.17elapsed 82%CPU
3.04user 0.42system 0:04.20elapsed 82%CPU
3.08user 0.42system 0:04.23elapsed 82%CPU
3.01user 0.46system 0:04.20elapsed 82%CPU
2. with my fix
2.92user 0.39system 0:03.35elapsed 98%CPU
2.90user 0.41system 0:03.35elapsed 98%CPU
2.89user 0.41system 0:03.35elapsed 98%CPU
2.90user 0.38system 0:03.32elapsed 98%CPU
2.97user 0.38system 0:03.39elapsed 98%CPU
=> 20.6%
■oracle
1. without my fix
3.67user 0.47system 0:07.51elapsed 55%CPU
3.65user 0.49system 0:07.46elapsed 55%CPU
3.65user 0.46system 0:07.49elapsed 54%CPU
3.70user 0.49system 0:07.74elapsed 54%CPU
3.65user 0.48system 0:07.48elapsed 55%CPU
2. with my fix
2.84user 0.42system 0:03.34elapsed 97%CPU
3.10user 0.41system 0:03.59elapsed 97%CPU
3.00user 0.42system 0:03.50elapsed 97%CPU
3.15user 0.41system 0:03.63elapsed 98%CPU
3.20user 0.40system 0:03.67elapsed 98%CPU
=> 52.9%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment