2009/9/8 Iñaki Baz Castillo <[email protected]>:
> It reduces the CPU used by MySQL in high load environments (tested
> with some benchmarks).

Prepared statement with 3 variables. 10000 requests with concurrency level 10.

- Original mysql.rb:   ~ 20.40 secs
 30378 root      20   0 94316  26m 4248 R   69  1.3   0:06.91 ruby1.8
  9606 mysql     20   0  230m  39m 6004 S   27  2.0   1:15.42 mysqld

- Patched mysql.rb:  ~ 19.50 secs
30333 root      20   0 94132  26m 4248 R   72  1.3   0:10.69 ruby1.8
 9606 mysql     20   0  230m  39m 6004 S   23  2.0   1:11.63 mysqld


-- 
Iñaki Baz Castillo
<[email protected]>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to