#!/bin/sh # # Copyright (c) 2005 MySQL AB # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA echo "######################################################################" echo "#" echo "# Test BUG#12166 - Unable to index very large tables" echo "#" ####################################################################### # # Settings. CAUTION: Paths are not space safe. # # BASEDIR="install directory" # DATADIR="databases directory e.g. $BASEDIR/var" MYSQLD="$BASEDIR/libexec/mysqld" MYSQLC="$BASEDIR/bin/mysql" MYSQLA="$BASEDIR/bin/mysqladmin" MYSQLT="$BASEDIR/bin/mysqltest" PORT_1="${MYSQL_TCP_PORT:+--port=$MYSQL_TCP_PORT}" SOCK_1="${MYSQL_UNIX_PORT:+--socket=$MYSQL_UNIX_PORT}" USER_1="-u root -D test" CLNT_1="-v -f" DATA_1="--basedir=$BASEDIR --datadir=$DATADIR" SERV_1="--log-error --core" DBUG_1= #"--debug=t:d:i:O,$DATADIR/mysqld.trace" cd $DATADIR || exit $? rm -f *.trace *.err core* test/#sql* echo "#######################################################################" echo "#" echo "# Special for this test case: Use a small tmpdir." echo "#" echo "# This is not portable. Find a way to implement it on your machine." echo "#" # # Mounting /mnt/tmpfs1, a file system with 1 MB of space only # The corresponding line in /etc/fstab looks like: # tmpfs /mnt/tmpfs1 tmpfs user,size=1m 0 0 # umount /mnt/tmpfs1 2>/dev/null ||: # unmount if mounted, ignore errors mount /mnt/tmpfs1 || exit $? # mount, stop if error # # Add the new temdir to the server flags. # SERV_1="$SERV_1 --tmpdir=/mnt/tmpfs1" # # echo "# tmpdir is successfully set up." echo sleep 1 echo "######################################################################" echo "#" echo "# Starting database server." "$MYSQLD" $PORT_1 $SOCK_1 $DATA_1 $SERV_1 $DBUG_1 & SERV_1_PID=$! echo "Process_id $SERV_1_PID" echo sleep 3 echo "######################################################################" echo "#" echo "# Starting client." "$MYSQLC" $PORT_1 $SOCK_1 $USER_1 $CLNT_1 <