The reporting of two rows thing is to do with how MySQL handles
INSERT ... ON DUPLICATE KEY UPDATE ... statements; it will report 1 row
if it inserts, and 2 rows if it finds a duplicate key and has to update
as well.
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Just after the f
At 01:08 PM 1/20/2009, you wrote:
While specing out a new server, I was wondering if there is any limit to
how much memory can be allocated to mysql 5.1. If a server has 16GB of
ram, can mysql take advantage of that much ram (minus a reserved amount
for the OS obviously)? Is there any limit s
This doesn't work the same way as system RAM though. You can't extend your
innodb buffer pool onto a block device or filesystem. Though this
technology would be good for segregating things like InnoDB logs and mysql
binary logs.
-Aaron
On Thu, Jan 22, 2009 at 7:40 AM, mos wrote:
> At 01:08 PM
Hi,
I have the following table:
CREATE TABLE DATA (
TARGET_TIME datetime NOT NULL,
SCENARIONAMEvarchar(20) NOT NULL,
TOOLNAME varchar(20) NOT NULL,
STATNAME varchar(100) NOT NULL,
STATVALUE int(10) NOT NULL,
PRIMARY KEY (TARGET_TIME, SCENARIONAME, SIMTOOLNAME, STATNAME)
);
I am t
At 09:57 AM 1/22/2009, you wrote:
This doesn't work the same way as system RAM though. You can't extend
your innodb buffer pool onto a block device or filesystem. Though this
technology would be good for segregating things like InnoDB logs and mysql
binary logs.
Of course. This device is to
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ... but the requirements call for MySQL.
Is the above q
At 02:19 PM 1/22/2009, Weston, Craig (OFT) wrote:
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ...
