An update - it also occurs in 4.1.19
Bug filed here:
http://bugs.mysql.com/bug.php?id=19978
Cheers,
Richard.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables
I have a table called which has a (combined) primary key of assetid and
date plus several data fields (open, high, low, close - all doubles, and
voume - a bigint). See the bottom of the email for the table definition.
is neither inserted nor updated? Right now it
appears to returns '2'. I think it should return '0'.
Cheers,
Richard.
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 May 2006 11:23 a.m.
To: mysql@lists.mysql.com
Subject: INESRT ... ON DUPLICATE KEY - rows
to file a bug report.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]
Sent
MySql v3.23 is part of the Fedore Core 3 distribution. MySQL v4.1 only
became standard in Fedora Core 4.
I suspect it's one of the non-Fedora repositories you're using. Check your
logs and also check /etc/yum.repos.d
grep enabled /etc/yum/repos.d/*
Best regards,
Richard Dale.
Norgate
,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
libraries - it appears that they are no
provided on mysql.com
As an alternative, consider using Fedora Core 4 which has Mysql 4.1 in there
natively.
The following might also be helpful (not all info in there is
Opteron-specific):
http://hashmysql.org/index.php?title=Opteron_HOWTO
Best regards,
Richard
. You will need to install a package
called mysqlclient10-3.23.58-6.x86_64.rpm - I found such a package at my
local mirror here:
http://mirror.pacific.net.au/linux/redhat/fedora/test/3.92/x86_64/os/Fedora/
RPMS/mysqlclient10-3.23.58-6.x86_64.rpm
Best regards,
Richard Dale.
Norgate Investor Services
:
http://hashmysql.org/index.php?title=Opteron_HOWTO
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives
if there are queries going on.
It's like the unix top command.
http://jeremy.zawodny.com/mysql/mytop/
Also try:
SHOW PROCESSLIST;
If you use InnoDB:
show innodb status;
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets
=10829
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
, 4GB
RAM, 8x15K RPM RAID 10 drive system.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http
to be quite often NULL, so I
guess it's not implemented in InnoDB.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
-Original Message-
From
, and writeback
caching increased the speed by about 15% although I don't think I was really
able to max out the IO anyway.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA
and I'll do some performance testing
on RAID5 (8 disks) versus RAID 10 (8 disks, 2 channels). I'll also do some
performance tests with 128MB cache and 512MB cache on the SCSI card to let
you know if that makes a difference.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock
/Hardware_order_May_2004
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
) then I think we'll find SATA will take
a much bigger lead in database performance.
Really nice work from tweakers.net - would have been interesting to see the
Linux performance too though.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange
.
Swapping: WinXP reporting commit charge 800MB
Note: I'll be moving to a Linux-based development server soon and will be
able to tell whether the above is specific to Windows or Linux.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data
18 matches
Mail list logo