Older setup:
RT 3.4.5 with mysql 4.0.24 and Perl 5.8.6 on V20z with 2 1.8Ghz and 4G mem
mysql select count(*) from Tickets;
+--+
| count(*) |
+--+
| 406311 |
+--+
1 row in set (0.25 sec)
Newer setup:
RT 3.8.2 with mysql 5.0.75 and Perl 5.8.8 on T1000 with 24 1Ghz cpu
I think you find more help on mysql performance lists. It can be
kernel (io scheduler), mysql (changes in options, degradations),
innodb (concurency issues), finally it can be cold cache.
On Tue, Apr 28, 2009 at 7:01 PM, Asif Iqbal vad...@gmail.com wrote:
Older setup:
RT 3.4.5 with mysql