I am having serious problems with Mysql .. He is consuming 2GB of ram to start approximately
[!!] Maximum possible memory usage: 17.4G (229% of installed RAM)
By using mysql tunner tells me this: Total buffers: 1.4G global + 20.4M per thread (800 max threads)
And when the processes of my pc I have this
Used free shared buffers total cached
Mem: 7939472 5929620 2009852 0 7120 1027896
- / + Buffers / cache: 4894604 3044868
Swap: 3997680 0 3997680
--------------------------------------------------------------
AMD Athlon(tm) II X4 605e Processor, 4 cores
8 Gb Ram
Debian 64 Bits , Java 7 Ultima version de mysql
-Xmx8192m -Xms4096m -Xmn2048m -XX:PermSize=256m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts
Now the problem I think lies in my.cnf
Code: Select all
## The MySQL database server configuration file.## You can copy this to one of:# - "/etc/mysql/my.cnf" to set global options,# - "~/.my.cnf" to set user-specific options.## One can use all long options that the program supports.# Run program with --help to get a list of available options and with# --print-defaults to see which it would actually understand and use.## For explanations see# http://dev.mysql.com/doc/mysql/en/serve ... ables.html # This will be passed to all mysql clients# It has been reported that passwords should be enclosed with ticks/quotes# escpecially if they contain "#" chars...# Remember to edit /etc/mysql/debian.cnf when changing the socket location.[client]port = 3306socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs# The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed.[mysqld_safe]socket = /var/run/mysqld/mysqld.socknice = 0open-files-limit = 4192 [mysqld]## * Basic Settings#user = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplanguage = /usr/share/mysql/englishskip-external-locking## Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.bind-address = 0 # The default storage engine that will be used when create new tables whendefault-storage-engine=INNODB # Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections = 800table_cache = 2048query_cache_size = 128Mquery_cache_type = 0tmp_table_size = 64Mmax_heap_table_size = 32Mmemlockthread_concurrency = 8thread_cache_size = 100max_allowed_packet = 16Mread_buffer_size = 128Kread_rnd_buffer_size = 16Mjoin_buffer_size = 2Msort_buffer_size = 2Mlow-priority-updatestransaction_isolation = READ-COMMITTED #*** MyISAM Specific optionsmyisam_max_sort_file_size = 100Gmyisam_sort_buffer_size = 64Mkey_buffer_size = 384M # *** INNODB Specific options ***innodb_additional_mem_pool_size = 16Minnodb_buffer_pool_size = 1024Minnodb_data_file_path = ibdata1:10M:autoextendinnodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 16Minnodb_log_files_in_group = 2innodb_log_buffer_size= 16Minnodb_max_dirty_pages_pct = 90innodb_flush_method = O_DIRECTinnodb_lock_wait_timeout = 120innodb_file_per_table = 1innodb_support_xa = 0innodb_checksums = 0innodb_doublewrite = 0 skip-federated [mysqldump]quickmax_allowed_packet = 16M [mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates [mysqlhotcopy]interactive-timeout ## * IMPORTANT: Additional settings that can override those from this file!# The files must end with '.cnf', otherwise they'll be ignored.#!includedir /etc/mysql/conf.d/