Finding configure command after installation

2004-04-13 Thread Walter Andreas
Hi there, I just recompiled mysql and I am wondering if there is something like in php (phpinfo();) where you can see the configure command after the db is installed. It would just be nice to have that in a later time, or even to make sure that the new version has replaced the old one. thanx

turning off binary logging

2004-04-13 Thread Walter Andreas
Hi there, I just found that mysql 4.0.18 is doing binary logging. How can I turn this off? I outcommented the line in my.cnf and restarted the server, but it is still creating those binary loggs inside the data dir. I do not see a nead for this, plus I fear that it might fill up the file system,

How to replace a installed mysql version?

2004-04-13 Thread Walter Andreas
Hi there, I am a bit confused. It is not clear to me that the version I am currently running is the one I compiled last. How can I check the date of compiling? In order to get more performance I did try to install mysql 4.0.18 with different configure commands, now I am not sure if the make

Re: compiling mysql with intel icc

2004-04-12 Thread Walter Andreas
Problem description: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static

sql-bench - wrong socket error

2004-04-12 Thread Walter Andreas
Hi there, I am trying to benchmark a mysql installation. After running: /usr/local/mysql/sql-bench # ./run-all-tests it throws the error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Thats ok, since the socket is /tmp/mysql.sock as configured in my.cnf I

compiling mysql on a pentium

2004-04-12 Thread Walter Andreas
Hi there, how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already catched up with pgcc?).

Re: compiling mysql on a pentium

2004-04-12 Thread Walter Andreas
on the net? Andy Daniel Kasak [EMAIL PROTECTED] schrieb am 13.04.04 05:31:35: Walter Andreas wrote: Hi there, how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc

stressing mysql - configuration advice

2004-04-11 Thread Walter Andreas
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP; Sun, 11 Apr 2004 12:47:20 +0200 Date: Sun, 11 Apr 2004 12:47:20 +0200 Message-Id: [EMAIL PROTECTED] --- END HEADERS --- Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x

compiling mysql with intel icc

2004-04-11 Thread Walter Andreas
Hi there, I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that following line will squese more performance out of mysql: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict