Hi!

I have tested a bit today.
Various logfiles are at :

http://www.dassic.dk/~jfn/mysql/

I found that after compiling with full debugging, I got the error that one
of the my.cnf parameters was too little and should be increased on the
server.
The default is 1 MB. I tried to increase it to 16 M, then 32 MB, then 512
MB, then 5 GB. No go at all. I tried both slave & server (I have 6 GB on the
machine and a unlimited ulimit and full access to all memory (no
sysconfigtab limitations), so I'm not low on memory).

The configure and make options for this crashing debug version is in the
make_bad.sh, and the error in O4_error.txt and the mysqld.trace in
mysqld.trace.txt

I then decided to strip down the compiler options to what you find in
make_good.sh. Did a recompile (output from this in make_good.log.txt
(stdout) and make_good.typescript.txt (stderr)).
As the name say, this version works.

I compiled with no optimization, and arch set to generic since the machine I
compile on is a EV67 and the machine I test on is EV56, and I don't want any
EV67 instructions to be emulated by the kernel.
I deleted master.info and let the slave update about 1 GB of data. This
worked without problems and I got no errors.

So it appears that the recommended optimization settings from INSTALL-SOURCE
does something bad to MySQL in my environment.
I've tried -O3 and -O2. No go, only -O0 works. Haven't tried playing with
some of the other parameters.
--  
Un saludo / Venlig hilsen / Regards

Jesper Frank Nemholt
Unix System Manager
Compaq Computer Corporation

Phone : +34 699 419 171
E-Mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to