Re: compiling mysql and mysql crashing
Michael Stassen wrote: Christine Ross wrote: I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti" ---8>< It's not a CERO, it's an letter O, the correct syntax is: CXXFLAGS="-O3 -felide-constructors -fno-exceptions-fno-rtti" If you are using a recent intel processor you can even add: "-march=i686 -mcpu=i686" You don't even have to add the "-O3" since it will be automatically added by the mysql configure script. Just export CXXFLAGS with the other optional optims flags, you can check out what they mean by reading them in the gcc man: man gcc When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). I"m using CXX=gcc. --8>< What distro are you using? What mysql server are you trying to compile? Also when I included it in the build, my statement about --localstatedir=/usr/local/mysql/data It's irrelevant, the localstatedir is where mysql, once compiled and configured will look for data by default, this default can _ALWAYS_ be overriden by changing the configuration file. It's just a default. Once compiled, you must run a script that will create the default databases and tables, _BUT_ once compiled and _INSTALLED_, not before. The script is called: mysql_install_db and it should be (normally i mean) in /usr/bin Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql and mysql crashing
Christine Ross wrote: I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti" because of some instances of mysql crashing. When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). I"m using CXX=gcc. It would be helpful if you would tell us what OS you have and which version of mysql you are building, as well as pasting in the message you got from gcc. 1) Has anyone had instances if it crashing without those parameters? I can't have mysql crashing but if the gcc indicates it doesn't support it, do those flags get built in? Also when I included it in the build, my statement about --localstatedir=/usr/local/mysql/data was ignored because it never built the data directory. 2) I just built it with --prefix and --localstatedir. Has anyone had problems with this? That depends on what you mean by build (out of `configure`, `make`, or `make install`). The data directory is created when you install mysql with `make install`. Are you saying that didn't happen when you installed? 3) If I want to recompile mysql, do I also have to recompile all apache, php and mod_ssl? That depends. Did you build php against your build of mysql, or did you keep php's built-in mysql support? Thanks for any suggestions. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compiling mysql and mysql crashing
I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti" because of some instances of mysql crashing. When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). I"m using CXX=gcc. 1) Has anyone had instances if it crashing without those parameters? I can't have mysql crashing but if the gcc indicates it doesn't support it, do those flags get built in? Also when I included it in the build, my statement about --localstatedir=/usr/local/mysql/data was ignored because it never built the data directory. 2) I just built it with --prefix and --localstatedir. Has anyone had problems with this? 3) If I want to recompile mysql, do I also have to recompile all apache, php and mod_ssl? Thanks for any suggestions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]