Building source on Solaris-i386

2001-09-18 Thread Jeff Tanner
compiler path; however, I am getting compiler errors when the make is compiling with /mysql-*/client directory. If not, then I also have a gcc compiler within /usr/local/bin; however, the ./configure --without-server fails because either cc or CC fails. Thanks Jeff Tanner Seattle, WA

FOREIGN KEY ... ON DELETE CASCADE

2001-09-11 Thread Jeff Tanner
Is FOREIGN KEY ... ON DELETE CASCADE operational in mysql? If so, I am not observing such. Here is how I am using it: CREATE TABLE scheduled_task_list ( schedule_id CHAR(28) NOT NULL, /* keys */ PRIMARY KEY (schedule_id) ); CREATE TABLE

segmentation fault post mysql server binary install for solaris-i386

2001-09-10 Thread Jeff Tanner
-i386). The uname -X output for my target machine is: System=SunOS Release=5.8 Kernel=Generic_108529-06 Machine=i86pc NumCPU=2 I have done a binary install before of MySQL onto a solaris-sparc. Did I get the wrong binary? Thanks Jeff Tanner Seattle, WA

Update question

2001-09-07 Thread Jeff Tanner
UPDATE returns the number of rows that were actually changed. How is the returned number of rows formatted for SQLFetch/SQLGet? Thanks Jeff Tanner Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php

SQLDriverConnect

2001-08-27 Thread Jeff Tanner
with Specified driver could not be loaded, SQLSTATE IM003 What is wrong with my DRIVER value? Thanks Jeff Tanner Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: MySQL server for Sun Solaris i386?

2001-08-09 Thread Jeff Tanner
, the mysql build fails when it trys to make files with suffixes of *.cc. What am I missing? Jeff Tanner Viathan Seattle, WA 98177 -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 4:53 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

Fatal warning in MySQL build Sun Solaris x86

2001-08-09 Thread Jeff Tanner
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown linkage type in dependency graph 1 fatal error Ideas? Thanks Jeff Tanner Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php

MySQL server for Sun Solaris i386?

2001-08-08 Thread Jeff Tanner
I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL server for Sun Solaris i386? Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? Thanks Jeff Tanner Viathan Seattle, WA - Before

LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
Thanks Tim for your reply But I am unfamiliar with DELAY_KEY_WRITE. I looked at both Tuning Server Parameters and LOAD DATA INFILE sections. Jeff Tanner Viathan Seattle, WA -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
the file into a table sans primary key was very much faster, but adding back the primary key negated any performance improvement than if just loading the file into a table with a primary key. Jeff Tanner Viathan Seattle, WA -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
DELAY_KEY_WRITE=ON by default Jeff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM

64-bit build of mysql's libiodbc?

2001-06-07 Thread Jeff Tanner
Currently the shared library object made within ../mysql/libiodbc* is 32-bit. Is there a way to modify the configuration for automake to create a 64-bit shared library object instead? Thanks Jeff Tanner Viathan - Before