"Reduce your overall MySQL memory footprint for system stability"

[Stephan]

MySQLTuner says:
"Reduce your overall MySQL memory footprint for system stability"

how can i do that in centos5?

[falko]

MySQLTuner should tell you which variables you should adjust.

[Stephan]

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries

somebody knows how to do it?

[falko]

What's in /etc/my.cnf?

[Stephan]

but even when i don't have anything on /etc/my.cnf i keep getting this message

2 quad cores + 10GB

[mysqld]
#local-infile=0
#external-locking
memlock
myisam_recover

skip-name-resolve

max_connect_errors = 1000000

max_connections = 10000

innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 4G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120


key_buffer = 32M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M

table_open_cache = 2048

sort_buffer_size = 8M
join_buffer_size = 8M
thread_concurrency = 32
thread_stack = 1M
transaction_isolation = REPEATABLE-READ

myisam_sort_buffer_size = 64M
table_cache = 5000
thread_cache_size = 700

wait_timeout = 10
connect_timeout = 10
interactive_timeout=10

max_heap_table_size = 64M
max_allowed_packet = 64M

query_cache_limit = 4M
query_cache_size =128M
query_cache_type = 1

#log
#log_warnings

[mysqld_safe]
# Increase the amount of open files allowed per process. Warning: Make
# sure you have set the global system limit high enough! The high value
# is required for a large number of opened tables
open-files-limit = 8192