Hi Suresh, Thanks, this link we already have but it has no information right from creating the raw disk partition.
Jeetendra Ranjan ----- Original Message ----- From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:12 PM Subject: Re: innodb_data_file_path Hi Jeetendra, Check the below url for details with the raw partition. http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna <sureshkumar...@gmail.com> wrote: Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan <jeetendra.ran...@sampatti.com> wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan ----- Original Message ----- From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan <jeetendra.ran...@sampatti.com> wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error "Starting MySQL.Manager of pid-file quit without updating file.[FAILED]" Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
