I realize that there is no way for me to split out the data and log files on a multi data node system. This is not good when it comes to getting the most out of disk based performance. How hard would it be to specify at log and a data path in the config.ini that would allow users to point these files to different disks? Example if each system had 4 drives (/data /data1 /data2 /data4) [ndbd] Id: 4 HostName: ndb09 DataPath: . DiskDataPath: /data LogGroupPath: /data1 [ndbd] Id: 5 HostName: ndb07 DataPath: . DiskDataPath: /data LogGroupPath: /data1 [ndbd] Id: 6 HostName: ndb09 DataPath: . DiskDataPath: /data2 LogGroupPath: /data4 [ndbd] Id: 7 HostName: ndb07 DataPath: . DiskDataPath: /data2 LogGroupPath: /data4 Jonathan Miller Austin, Texas USA Senior Quality Assurance Developer MySQL AB www.mysql.com -----Original Message----- From: Jimmy Guerrero [mailto:jguerrero@mysql.com] Sent: Thursday, January 19, 2006 4:19 PM To: 'Jonathan Miller' Subject: RE: I asked Robin what his thoughts were on the matter... <<Should you have the flexibilty in the config file to specify where your data and log files go to perhaps take advantage of multiple spindles and get better I/O on multi-node hosts?>> Absolutely. Our PS guys have the same faulty attitude and think everyone buys RAID and no one buys JBOD anymore. They're wrong. Tons still use JBOD. Further, all the competition allows for such assignments.
