Mailinglist Archive: opensuse-amd64 (79 mails)

[Kees Hoekzema <kees@xxxxxxxxxxxx>]

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