List:General Discussion« Previous MessageNext Message »
From:Jeetendra Ranjan Date:January 4 2010 7:28am
Subject:Re: innodb_data_file_path
View as plain text  
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@stripped 
  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 <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 
      To: Jeetendra Ranjan 
      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 
            To: Jeetendra Ranjan 
            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