Mysql cluster so slow...

2006-07-15 Thread Xueron Nee
Hi all, I am running a mysql cluster like this: ndb_mgm show Connected to Management Server at: localhost:1186 Cluster Configuration - [ndbd(NDB)] 2 node(s) id=3@10.0.0.1 (Version: 5.0.22, Nodegroup: 0, Master) id=4@10.0.0.2 (Version: 5.0.22, Nodegroup: 0)

mysql's mysql db in one place, other db's in another???

2006-07-15 Thread Les Schaffer
Using Innodb under Windows XP, MySQL server installed to default location: is it possible to let the mysql database be in C:\Program Files\MySQL\MySQL server 5.0\data while we have our innodb specific data files in C:\DataCollector\Resources\ ? IOW (from my.ini): #Path to installation

mysql's mysql db in one place, other db's in another???

2006-07-15 Thread Les Schaffer
and, BTW, we are starting the service with --innodb-file-per-table in case this matters, les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Pivoting the result set.

2006-07-15 Thread Ow Mun Heng
Hi, I have a query that comes out like this. Program Status Param1 Param2 Param3 Param4 Param5 A 1 1.1 2.2 3.3 4.4 5.5 B 2 2.2 3.3 4.4 5.5 6.6 C 3

Re: Pivoting the result set.

2006-07-15 Thread Peter Brawley
Would like for the results to become pivoted and be transposed to look like this. There's a little step-by-step for this at http://www.artfulsoftware.com/queries.php under 'Pivot tables', 'Group column statistics in rows'. PB - Ow Mun Heng wrote: Hi, I have a query that comes out