On Monday 27 October 2003 06:43, Andreas Jaeger wrote:
I would like to see those results with our current version (GCC 3.3 which is faster than 3.2, current glibc) on SuSE Linux 9.0. Do you have access to it? Or can you give us some testcase to reproduce?
Unfortunatly I don't have SuSE Linux 9.0, neither can I find a reseller in the Netherlands, and I have no idea which store would sell the AMD64 version of it. I can try to compile it on beta-9 which has gcc 3.3 also, but every time I compiled MySQL it was unstable under heavy load. but I can try :). I only used select queries on the database, no inserts because more than 90% of our queries are selects. Maybe i can try to use turn on the binlog and run that over a recent snapshot, but I haven't done that before so I have to find out how that works. On Monday 27 October 2003 08:14, Mark Horton wrote:
I'm not sure how large your dataset is but if you want I could run the same tests on my system to see if they come out with simular results.
I'm only running selects, the script i'm using is simulating a user visiting our website, basicly running random selects. The dataset I use is 960MB when dumped with MySQLDump, MySQL reports that the dataset is approx 1.4GB large with 6.518.269 rows. On Monday 27 October 2003 08:18, Andreas Jaeger wrote:
One further note: You might want to compare these 3 scenarios:
- 64-bit mysql under 64-bit kernel - 32-bit mysql under 64-bit kernel - 32-bit mysql under 32-bit kernel
I'v already done the first two scenarios, I will try to do the third one if I have fysical access to the server again (soon). Furthermore, i will try to play with the key_buffer setting (btw, I do use a lot of innodb, will innodb be affected by the keybuffer?) thank you all for the suggestions so far -kees