List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 4 2010 7:15am
Subject:Re: innodb_data_file_path
View as plain text  
Try this  :   /dev/sda3:10Graw;/dev/sda1:5Graw
Change the newraw to raw and start the MySQL.
and paste the error log  ouput.

Thanks
Suresh Kuna
MySQL DBA

On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan <
jeetendra.ranjan@stripped> wrote:

>  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 <sureshkumarilu@stripped>
> *To:* Jeetendra Ranjan <jeetendra.ranjan@stripped>
> *Cc:* mysql@stripped
> *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 <sureshkumarilu@stripped>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.ranjan@stripped> 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 <sureshkumarilu@stripped>
>>> *To:* Jeetendra Ranjan <jeetendra.ranjan@stripped>
>>> *Cc:* mysql@stripped
>>> *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.ranjan@stripped> 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=1
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Suresh Kuna
>>>
>>>
>>
>>
>> --
>>  Thanks
>> Suresh Kuna
>> MySQL DBA
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
innodb_data_file_pathJeetendra Ranjan4 Jan
  • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
    • Re: innodb_data_file_pathSuresh Kuna4 Jan
      • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
    • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan