innodb_data_file_path
am 04.01.2010 05:46:01 von jeetendra.ranjan
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=gcdmg-mysql-2@m.gmane.org
Re: innodb_data_file_path
am 04.01.2010 05:58:36 von sureshkumarilu
--00504502af14ed96fc047c4f92ce
Content-Type: text/plain; charset=ISO-8859-1
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@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=sureshkumarilu@gmail.com
>
>
--
Thanks,
Suresh Kuna
--00504502af14ed96fc047c4f92ce--
Re: innodb_data_file_path
am 04.01.2010 06:04:31 von jeetendra.ranjan
------=_NextPart_000_0022_01CA8D29.7FF468A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks Suresh for your response.
MySQL is already installed and will update you with the error log =
details.
Thanks
Jeetendra Ranjan
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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 =
wrote:
Hi,
I am using MySQL 5.0.85-community on Fedora 8.
When i set=20
innodb_data_home_dir =3D
innodb_data_file_path =3D /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw=20
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
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
--=20
Thanks,
Suresh Kuna
------=_NextPart_000_0022_01CA8D29.7FF468A0--
Re: innodb_data_file_path
am 04.01.2010 06:27:09 von jeetendra.ranjan
------=_NextPart_000_0029_01CA8D2C.A9555620
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=3Dip-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=20
Jeetendra Ranjan
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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 =
wrote:
Hi,
I am using MySQL 5.0.85-community on Fedora 8.
When i set=20
innodb_data_home_dir =3D
innodb_data_file_path =3D /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw=20
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
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
--=20
Thanks,
Suresh Kuna
------=_NextPart_000_0029_01CA8D2C.A9555620--
Re: innodb_data_file_path
am 04.01.2010 06:36:44 von sureshkumarilu
--001636ed657c52a9fe047c501b85
Content-Type: text/plain; charset=ISO-8859-1
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@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.ranjan@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=sureshkumarilu@gmail.com
>>
>>
>
>
> --
> Thanks,
> Suresh Kuna
>
>
--
Thanks
Suresh Kuna
MySQL DBA
--001636ed657c52a9fe047c501b85--
Re: innodb_data_file_path
am 04.01.2010 07:42:15 von sureshkumarilu
--00504502ad20a532c8047c510515
Content-Type: text/plain; charset=ISO-8859-1
Hi Jeetendra,
Check the below url for details with the raw partition.
http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.ht ml
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna 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@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.ranjan@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=sureshkumarilu@gmail.com
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Suresh Kuna
>>
>>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
--
Thanks
Suresh Kuna
MySQL DBA
--00504502ad20a532c8047c510515--
Re: innodb_data_file_path
am 04.01.2010 08:07:26 von jeetendra.ranjan
------=_NextPart_000_003C_01CA8D3A.ABEE2110
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Suresh,
Thanks, this link we already have but it has no information right from =
creating the raw disk partition.
Jeetendra Ranjan
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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.ht ml
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna =
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 =
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=3Dip-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=20
Jeetendra Ranjan
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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 =
wrote:
Hi,
I am using MySQL 5.0.85-community on Fedora 8.
When i set=20
innodb_data_home_dir =3D
innodb_data_file_path =3D =
/dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw=20
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
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
--=20
Thanks,
Suresh Kuna
--=20
Thanks
Suresh Kuna
MySQL DBA
--=20
Thanks
Suresh Kuna
MySQL DBA
------=_NextPart_000_003C_01CA8D3A.ABEE2110--
Re: innodb_data_file_path
am 04.01.2010 08:15:00 von sureshkumarilu
--00504502ad53c120cb047c517aee
Content-Type: text/plain; charset=ISO-8859-1
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@sampatti.com> 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
> *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.ht ml
>
> Thanks
> Suresh Kuna
> MySQL DBA
>
> On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna 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@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.ranjan@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=sureshkumarilu@gmail.com
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Suresh Kuna
>>>
>>>
>>
>>
>> --
>> Thanks
>> Suresh Kuna
>> MySQL DBA
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
>
--
Thanks
Suresh Kuna
MySQL DBA
--00504502ad53c120cb047c517aee--
Re: innodb_data_file_path
am 04.01.2010 08:28:30 von jeetendra.ranjan
------=_NextPart_000_0045_01CA8D3D.9D06A3E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is the second step and before that we have to stop the server and =
set the parameter in my.cnf =20
innodb_data_home_dir =3D
innodb_data_file_path =3D /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw =20
and when i restart the server it is giving error=20
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]"
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
Sent: Monday, January 04, 2010 12:45 PM
Subject: Re: innodb_data_file_path
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 =
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 -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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.ht ml
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna =
wrote:
Jeetendra,
Give the MySQLD user permissions to the new directory which you =
are specifying.=20
On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan =
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=3Dip-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=20
Jeetendra Ranjan
----- Original Message -----=20
From: Suresh Kuna=20
To: Jeetendra Ranjan=20
Cc: mysql@lists.mysql.com=20
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 =
wrote:
Hi,
I am using MySQL 5.0.85-community on Fedora 8.
When i set=20
innodb_data_home_dir =3D
innodb_data_file_path =3D =
/dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw=20
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
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
--=20
Thanks,
Suresh Kuna
--=20
Thanks
Suresh Kuna
MySQL DBA
--=20
Thanks
Suresh Kuna
MySQL DBA
--=20
Thanks
Suresh Kuna
MySQL DBA
------=_NextPart_000_0045_01CA8D3D.9D06A3E0--