Hi,
I have two tables- books and copies
every book has an id in the books table
every copy of a book has the books id and a copy id in the copies table
(1 row per copy)
I want a list of all the books that don't have any copies meaning all
the book id's in books that don't match any book id's in
=NULL;
this didn't work even though without the where clause I got exactly what
I wanted- the left join filled in the entries that didn't have copies
with a null copyid.
what did I do wrong?
thanks
yonah
Yonah Russ wrote:
Hi,
I have two tables- books and copies
every book has an id in the books
There does seem to be a bug in icc- I've posted on intel's message
boards and they've confirmed a problem. There is a work around - here is
the post:
Hi Yonah,
I can see the same problem on my system.
I will create a support issue for you and will let you when
this get fixed.
I found that if
I've been trying to compile a mysql server optimized for a zeon
processor and a specific application- I'm compiling with icc.
the problem is with the sql benchmarks- the perl regexp for making the
detailed report of the benchmark doesn't match the output from the
benchmarks so it doesn't
are you sure that the icc binary is in your path?
have you sourced the script in the icc directory which sets the
environment variables for you?
yonah
Walter Andreas wrote:
Hi there,
I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that
Can anyone explain what the raid configure option does? Is this for use
when storing mysql on hardware raid? if so, what type(s)- ie. striping,
mirroring?
Thanks
yonah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
: compiling with icc
Date: Thu, 1 Apr 2004 22:23:02 +0200 (CEST)
From: Lenz Grimmer [EMAIL PROTECTED]
To: Yonah Russ [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Yonah,
sorry for the late reply. I have now
sorry- typo- the gcc binary was 4.0.18
yonah
Yonah Russ wrote:
Hi all- Here is more info on compiling mysql with icc 8 from the mysql
packagers list-
As for my attempts, I compiled successfully a couple times and the
first benchmark I did was faster than the gcc compiled server by about
10
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
including my last configuration for compiling and how it died- I've
tried about a million other ways- this seems to come the closest to
compiling normally but dies with an internal error(looks like intel's
fault not yours).
Victor Medina wrote:
8
must probably no one here uses the Intel compiler since it is paid =(
actually there is a free non-commercial license version here:
http://www.intel.com/software/products/compilers/clin/noncom.htm
which is how I happen to have it
yonah
it dies with this error:
IPO
what they used) but not with 4.0.18
yonah
Chris Nolan wrote:
Victor Medina wrote:
Hi!
On Wed, 2004-03-24 at 09:51, Yonah Russ wrote:
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
8
GUAO! nice!, let us know how faster it is with the Intel compiler, just
curious
Victor Medina wrote:
it dies with this error:
IPO Warning: unresolved : rl_attempted_completion_function
Referenced in ipo_icc5X7oE4.o
IPO Warning: unresolved : rl_completion_entry_function
8
Ncurses devel and the readline libriries must be installed for the
client to compile
/local/mysql/lib/mysql
/usr/local/lib
/usr/local/intel/lib
.
thanks
yonah
Victor Medina wrote:
On Wed, 2004-03-24 at 10:57, Yonah Russ wrote:
8
make[2]: Leaving directory `/moat-files/mysql-4.0.18/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/moat-files/mysql-4.0.18
Great! Thanks for the help.
Here is some more info, in case it's helpful- these are all the compile
warnings from the make:
my_thr_init.c(67): warning #266: function declared implicitly
pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP);
^
...
icc: Command line
I'm not a big mysql expert but I think mysql has some buffers which it
keeps per connection
here are some examples (from mysql website):
/
/If you have complex queries |sort_buffer_size| and |tmp_table_size| are
likely to be very important. Values will depend on the query complexity
and
News-
I have compiled mysql 4.1.1-alpha with the icc compiler using the
options intel reported in their case study pdf.
specifically '-O3 -ip -unroll2'
The compilation was pretty ugly and threw up a lot of warnings.
I'm benchmarking now and I'll let you know what comes out of it.
yonah
Yonah
16 matches
Mail list logo