Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Unanswered: Red Hat 5.5 MYSQL 5.0.77 slow to import

    Hi,

    We are importing a 600MB database into My SQL version 5.0.77 on Red Hat 5.5.

    It's taking 11 hours to import this data.

    We tried it with My SQL 5.1 as well with the same results.

    The OS is sitting on a blade server with 12GM RAM + 8GB Swap and 2.83MHZ Dual Core Proc.

    I am a UNIX Admin, but our DBA's aren't able to shed any light on this.

    We tried on Ubuntu 10.04 running on a desktop and it took 163 minutes to complete! This was using My SQL 5.1.

    The rpm's look like this;

    mysql-5.0.77-4.el5_4.2
    php-mysql-5.2.6-1.el5.remi
    mysql-server-5.0.77-4.el5_4.2

    So, why is it taking so long to complete?

    Cheers,

  2. #2
    Join Date
    Mar 2008
    Posts
    136
    please put here variables in my.cnf
    Regards
    Pawan Kumar

  3. #3
    Join Date
    Jul 2010
    Posts
    2
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    # Disabling symbolic-links is recommended to prevent assorted security risks;
    # to do so, uncomment this line:
    # symbolic-links=0

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •