Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    8

    Unanswered: performance problem ..

    Hi All,

    We have a table which is having 45 Million Records. Queries running on this table are taking long time to give the result. We are using Innodb on Linux redhat OS.

    Can any one give me some tips to improve the performance.

    Regards,
    sekhar

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: performance problem ..

    Originally posted by sekhartd
    Hi All,

    We have a table which is having 45 Million Records. Queries running on this table are taking long time to give the result. We are using Innodb on Linux redhat OS.

    Can any one give me some tips to improve the performance.

    Regards,
    sekhar
    Can you give more details? SQL statement, create table statement and indexes, my.cnf and variables, hardware, etc...

    45 million records is nothing exceptional as long as you have the right indexes and machine to do the job...

  3. #3
    Join Date
    Sep 2002
    Posts
    8
    OS is Redhat Linux
    And we have two indexes on this table.
    select count(*) is taking around 4000 Seconds.

  4. #4
    Join Date
    Sep 2002
    Posts
    8
    And server configuration is 1 GB Ram - Dual CPUs - 80 GB Hd
    MySql parameters are :

    InnodB_buffer_pool : 1000M
    Key_buffer: 750 M
    Record_buffer: 200M

  5. #5
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1
    Originally posted by sekhartd
    And server configuration is 1 GB Ram - Dual CPUs - 80 GB Hd
    MySql parameters are :

    InnodB_buffer_pool : 1000M
    Key_buffer: 750 M
    Record_buffer: 200M
    If you have a unique index on this table, I'd suggest you try:

    SELECT COUNT(indexed_column) FROM TABLE;

Posting Permissions

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