I use MySQL version 4.1.18 with redhat-linux-gnu (i686). I have created a InnoDB database consisting of 210 GB ibdata files. I used InnoDB to allocate more memory and speed up the load. I want use it for read-only purpose and it works fine with one MySQL server instance.
I am trying to run multiple instance of MySQL server on the same data files, but i get the following error when I start second MySQL server instance on the same data files (ibdata*). i would greatly appreciate any pointers on how to avoid this error. thanks, Ralph COMMAND ------------------------------------------- mysqld_safe --defaults-file=/home/savaj/adsale4/my.cnf --user=adsale --read-only --skip-grant-tables --skip-external-locking --skip-locking Error --------------------------------------------- InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 060718 16:32:14 InnoDB: Unable to open the first data file InnoDB: Error in opening /mnt/adsale/adsale4/ibdata1 060718 16:32:14 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 060718 16:32:14 [ERROR] Can't init databases __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]