Re: SAN and ibdata files

2007-10-06 Thread Dan Nelson
In the last episode (Oct 06), Ace said: > Hi Experts, > > You all know the size problems with ibdata and log files. We plan to > move those files to SAN to have maximum storage possible. We did so with > configuration changes in my.cnf files to save log and ibdata files on SAN > location. Bu

Re: do I need two tables or one will do just fine?

2007-10-06 Thread John Meyer
Afan Pasalic wrote: hi, I have a employees table (first name, last_name, address, city, state, zip, phone,...). though, I got a requested to add additional info about people, like phone_extension, zip+4, nick, DOB... that will not be used very often. what would be better solution: a) add these

Re: Connect To Foreign Tables

2007-10-06 Thread Rob Wultsch
Have you guys thought about trying to use a Federated table? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html Probably not exactly the solution you want, but maybe useful. On 10/6/07, Werner Van Belle <[EMAIL PROTECTED]> wrote: > > Hello, > > On Friday 05 October 2007 01:11:35

SAN and ibdata files

2007-10-06 Thread Ace
Hi Experts, You all know the size problems with ibdata and log files. We plan to move those files to SAN to have maximum storage possible. We did so with configuration changes in my.cnf files to save log and ibdata files on SAN location. But got following error - InnoDB: Unable to lock /ops

Re: Connect To Foreign Tables

2007-10-06 Thread Werner Van Belle
Hello, On Friday 05 October 2007 01:11:35 James Card wrote: > The application I'm working on uses MySQL 5.0.41 and we also need to > retrieve some data from a SQL-Server database in another department. > SQL-Server has a feature (that I haven't tested) that allows it to make an > ODBC connection