Re: innodb_data_file_path
This is the second step and before that we have to stop the server and set the parameter in my.cnf innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and when i restart the server it is giving error Starting MySQL.Manager of pid-file quit without updating file.[FAILED]" - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com 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 - 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 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=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 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 -- Thanks Suresh Kuna MySQL DBA
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 < jeetendra.ran...@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.html > > 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.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 > > -- Thanks Suresh Kuna MySQL DBA
Re: innodb_data_file_path
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 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=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 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
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 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
Re: innodb_data_file_path
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
Re: innodb_data_file_path
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 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
Re: innodb_data_file_path
Thanks Suresh for your response. MySQL is already installed and will update you with the error log details. 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 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
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