xxx_cache - unsigned value

P

postcd

Guest
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?
 


thx, yes i discovered this because i was unable to create a mysql database from my Kloxo control panel..
 

So you mean when i get error:
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

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?
 

Staff online


Top