How to replace a installed mysql version?

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 insta

turning off binary logging

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, p

Finding configure command after installation

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 fo

Re: compiling mysql on a pentium

ich I found somewhere else 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 da

compiling mysql on a pentium

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?). Sett

sql-bench - wrong socket error

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

Re: compiling mysql with intel icc

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 > > --with-mysqld-ldflags

compiling mysql with intel icc

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" ./c

stressing mysql - configuration advice

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