From: Mariella Petrini (mariellapetriniyahoo.com)
Date: Thu Feb 14 2008 - 12:36:39 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi ALL,

I have compiled MySLQ 5.1.23-rc for Linux 64bit

./configure CC=gcc CFLAGS="-DBIG_JOINS=1 -O3" CXX=g++
CXXFLAGS="-DBIG_JOINS=1 -felide-constructors
-fno-exceptions -fno-rtti -O3"
--prefix=/app/mysql-5.1.23-rc
--localstatedir=/app/mysql-5.1.23-rc/data
--libexecdir=/app/mysql-5.1.23-rc/bin
--datadir=/app/mysql-5.1.23-rc/data
-with-comment="Debian x86_64"
--with-server-suffix="Debian x86_64" --enable-shared
--enable-static --enable-thread-safe-client
--enable-assembler --enable-local-infile
--with-big-tables --with-raid --with-mysqld-user=mysql
--with-libwrap --with-mysqld-ldflags=-all-static
--with-vio --with-bench --with-readline
--with-extra-charsets=all --with-innodb --with-isam
--with-archive-storage-engine
--with-csv-storage-engine
--with-federated-storage-engine
--with-embedded-privilege-control
--with-zlib-dir=bundled --with-ssl=bundled
--with-partition

1)
While trying to run the
sudo bin/mysql_install_db
it failed (even though I specified the src directory)

sudo bin/mysql_install_db --user=mysql
--builddir=/src/mysql-5.1.23-rc
--srcdir=/src/mysql-5.1.23-rc --ldata=/app/mysql/data
Installing MySQL system tables...

Installation of system tables failed! Examine the
logs in
/app/mysql/data for more information.

The logs did not get created; only the test database
directory got created (only the directory)

I did copy over the mysql-5.1.22-rc/data/mysql table
files and after that the MySQL server was able to
start.

2)
I have tried to specify to mysqld (in the same way of
MySQL 5.1.22-rc) to use more open files than limit
using
mysqld_safe --defaults-file=/app/mysql/etc/my.cnf
--open-files-limit=200000
and it says

[Warning] option 'open_files_limit': unsigned value
200000 adjusted to 65535

Is there any way to get around that, please ?

Thanks in advance for your help,

Mariella

      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]