Building source on Solaris-i386
Can MySQL client be built from source using the Sun Forte compiler (i.e. /usr/SUNWspro/bin/cc)? If so, then what are the proper ./configure settings (in addition to --without-server) for using this compiler? Calling ./configure --without-server succeeds with /usr/SUNWspro/bin as my default 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FOREIGN KEY ... ON DELETE CASCADE
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 scheduled_task_instances ( task_instance_idCHAR(28) NOT NULL, schedule_id CHAR(28) NOT NULL, /* keys */ PRIMARY KEY (task_instance_id), /* constraints */ FOREIGN KEY (schedule_id) REFERENCES scheduled_task_list (schedule_id) ON DELETECASCADE ); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
segmentation fault post mysql server binary install for solaris-i386
I am getting a segmentation fault on a solaris i86pc when executing either with: ./bin/safe_mysqld ./bin/mysql -h active_mysql_host On this solaris i86pc, I got the following binary install: mysql-3.23.39-pc-solaris2.8-i386.tar.gz Then untarred it with GNU tar (gtar-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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update question
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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQLDriverConnect
If the connection string for SQLDriverConnect is DSN=foo, and DSN foo is defined within the odbc.ini file, then connection succeeds. However, if the connection string for SQLDriverConnect is DRIVER={MySQL};SERVER=foo_host;USER=foo;PWD=bar;DATABASE=foo_db, then error condition is returns 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/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL server for Sun Solaris i386?
I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris (Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine. Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not compatible for Sun Solaris (x86)? Mr. Smith, after building on a Sun Solaris x86 machine, 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] Subject: Re: MySQL server for Sun Solaris i386? Jeff Tanner writes: 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 Hi! Either build it from source or download some older contributed binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fatal warning in MySQL build Sun Solaris x86
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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL server for Sun Solaris i386?
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE performance testing
I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( value CHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique values time in seconds 10 0.05 100 0.05 1K 0.10 10K 0.75 100K 10 500K 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOAD DATA INFILE performance testing
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 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 -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOAD DATA INFILE performance testing
Thanks Sinisa for your reply, Interesting alterative. I tried: a) ALTER TABLE foo DROP PRIMARY KEY b) LOAD DATA INFILE file INTO TABLE foo c) ALTER TABLE foo ADD PRIMARY KEY (value) However, there was no noticable improvement in performance. Even though loading 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 PROTECTED]] Sent: Monday, August 06, 2001 8:33 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: LOAD DATA INFILE performance testing Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 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 No, but you could crate a table without index and add primary key after loading of data. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOAD DATA INFILE performance testing
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 -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
64-bit build of mysql's libiodbc?
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php