In a message dated 9/9/03 7:53:59 PM Eastern Daylight Time, [EMAIL PROTECTED] writes:
> By "partitioning", you mean having one table divided across N > partitions? Yes, I do. > > Such a feat isn't directly possible with MySQL, however you can create N > tables instead of 1, and use a table of Type=RAID on the master to > "unify" them for purposes of queries that need to access data from many > partitions. I've read about using symbolic links, but only for using multiple data directories, not splitting a file (not to mention, across more than one node). Admittedly, I am not a Linux/*nix guru, just adventurous and doing research soliciting opinions/ideas before I dive in. Since MySQL doesn't directly support this, any ideas on doing it at the OS level to 'trick' MySQL into believing its all in a single directory as a single table? It's looking more like I may have to build a DBsmart API to select the partition/machine containing the data I need. I recall a group of sharpsters at Temple U. did something similar to that. /t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]