Please Help: MYSQL Runtime Information

Discussion in 'MySQL' started by deriklogov, Jul 23, 2009.

0
  1. #1
    I got those from phpmyadmin:

    All those variables phpmyadmin marking in red, I think that means some optimization required. What could be done to fix those ? I am really need your help to figure this out

    Handler_read_rnd 1,883 k
    Handler_read_rnd_next 1,830 M
    Created_tmp_disk_tables 4,914
    Key_reads 30 M
    Key_writes 110 M
    Opened_tables 247 k
    Table_locks_waited 572
     
    deriklogov, Jul 23, 2009 IP
  2. LordMagik

    LordMagik Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Please post main configuration file and your hw configuration (CPU, RAM)
     
    LordMagik, Sep 23, 2009 IP