xxx_cache - unsigned value

Discussion in 'Web Server' started by postcd, Apr 26, 2014.

  1. postcd

    postcd Member

    Messages:
    78
    Likes Received:
    6
    Trophy Points:
    8
    My var/log/mysqld.log shows:

    Code:
    140422 19:28:50  mysqld started
    140422 19:28:50 [Warning] option 'thread_cache_size': unsigned value 16777216 adjusted to 16384
    140422 19:28:50 [Warning] option 'table_cache': unsigned value 2147483648 adjusted to 524288
    140422 19:28:50 [Warning] Changed limits: max_open_files: 65535  max_connections: 200  table_cache: 32662
    140422 19:28:52 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.96'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    140424 11:37:50 [Note] /usr/libexec/mysqld: Normal shutdown
    
    140424 11:37:56 [Note] /usr/libexec/mysqld: Shutdown complete
    
    140424 11:37:56  mysqld ended
    Please how can i adjust above limits or what is the issue?

  2. ryanvade

    ryanvade Administrator Staff Member Staff Writer

    Messages:
    1,346
    Likes Received:
    447
    Trophy Points:
    83
    Are you experiencing any problems with MySQL?
  3. postcd

    postcd Member

    Messages:
    78
    Likes Received:
    6
    Trophy Points:
    8
    thx, yes i discovered this because i was unable to create a mysql database from my Kloxo control panel..
  4. ryanvade

    ryanvade Administrator Staff Member Staff Writer

    Messages:
    1,346
    Likes Received:
    447
    Trophy Points:
    83
  5. postcd

    postcd Member

    Messages:
    78
    Likes Received:
    6
    Trophy Points:
    8
    So you mean when i get error:
    I need to add following values into /etc/my.cnf?:

    thread_cache_size = 16M
    table_cache = 524M
    max_open_files = 65535

    the values that mysql autoadjusted to and mentioned in bytes?

    and restart mysql?

Share This Page