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.
INSERT
what happens if the row 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
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]
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]
sing mytop to see 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, Futur
Opteron (x86_64) HOWTO:
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 Ma
tle=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: http://lists.mysq
ting area. 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
OK.
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 unsubsc
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 Dal
d Queueing) 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 F
/meta.wikimedia.org/wiki/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:
y 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
- Premiu
e seems 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
-Origina
, 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
d it took around 2 hours to load on an Opteron 250, 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
--
My
://bugs.mysql.com/bug.php?id=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: ht
tabase on its own hard drive.
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
18 matches
Mail list logo
