|
Buenos días, A ver si alguin me da un poquito de luz.... tenemos un problemilla con un server que nos genera 15Gb de mysql-err.log en menos de 24h. El contenido es casi exclusivo: [...] 2016-04-06T06:22:41.283958Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284008Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284057Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284106Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284168Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284244Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284298Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284351Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284404Z 0 [ERROR] Error in accept: Bad file descriptor 2016-04-06T06:22:41.284469Z 0 [ERROR] Error in accept: Bad file descriptor [...] # ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 3914 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 65536 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 3914 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited # cat /proc/sys/fs/file-max 100142 # ulimit -Hn 65536 # ulimit -Sn 65536 # cat /etc/mysql/my.cnf # # The following options will be read by MySQL client applications. # Note that only client applications shipped by MySQL are guaranteed # to read this section. If you want your own MySQL client program to # honor these values, you need to specify it as an option during the # MySQL client library initialization. # [client] #password = [your_password] port = 3306 socket = /var/run/mysqld/mysqld.sock # *** Application-specific options follow here *** # # The MySQL server # [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB socket = /var/run/mysqld/mysqld.sock explicit_defaults_for_timestamp = TRUE bind-address = 0.0.0.0 #skip-networking # DATA STORAGE # datadir = /var/lib/mysql/ # CHARACTER # character-set-server = utf8 collation-server = utf8_general_ci skip-character-set-client-handshake lower_case_table_names = 1 # SAFETY # max_allowed_packet = 16M max_connect_errors = 1000000 skip_name_resolve sql_mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sysdate_is_now = 1 innodb = FORCE innodb_strict_mode = 1 # BINARY LOGGING # log-bin = /var/log/mysql/mysql-bin binlog_format = mixed relay-log = mysql-relay-bin expire-logs-days = 14 sync-binlog = 50 # LOGGING # log-error = /var/log/mysql/mysql-error.log #log-queries-not-using-indexes = 1 slow-query-log = 1 slow-query-log-file = /var/log/mysql/mysql-slow.log long_query_time = 5 # TIMEOUT # wait_timeout=300 # CACHES AND LIMITS # tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 0 query-cache-size = 0 max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 4096 back_log = 50 max_connect_errors = 10 max_allowed_packet = 128M binlog_cache_size = 1M read_buffer_size = 8M read_rnd_buffer_size = 32M sort_buffer_size = 16M join_buffer_size = 8M ft_min_word_len = 4 thread_stack = 192K transaction_isolation = READ-COMMITTED # Replicacion # server-id = 1 # *** MyISAM **** # key_buffer_size = 32M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 2G myisam_repair_threads = 1 myisam-recover-options = FORCE,BACKUP # *** INNODB *** # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 512M innodb-flush-log-at-trx-commit = 2 innodb-file-per-table = 1 innodb-buffer-pool-size = 450M #75% Memoria maxima innodb_data_file_path = ibdata1:10M:autoextend innodb_thread_concurrency = 16 innodb_log_buffer_size = 8M innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 #innodb_force_recovery = 3 innodb_fast_shutdown innodb_kill_idle_transaction = 300 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Only allow UPDATEs and DELETEs that use keys. #safe-updates [myisamchk] key_buffer_size = 512M sort_buffer_size = 512M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 8192 Debian GNU/Linux 8.3 (jessie) + Server version: 5.7.10-3-log Percona Server (GPL), Release '3', Revision '63dafaf' Gracias de antemano, un saludo! -- __ _ _ _ _ _ _ _ _ /\/|_ __ | _| | ___ ___| |_(_)_ __ | |_| |__ ___ ___| |__ ___| | |/\/| | |_ | | || |/ _ \/ __| __| | '_ \| __| '_ \ / _ \/ __| '_ \ / _ \ | | / __|_) | | || | (_) \__ \ |_| | | | | |_| | | | __/\__ \ | | | __/ | | \__ \_| | | ||_|\___/|___/\__|_|_| |_|\__|_| |_|\___||___/_| |_|\___|_|_| ( (_) | |__|YmVydHVjb0Bsb3N0aW50aGVzaGVsbC5uZXQgMHhEODlENzQ3RCBiM3IyYzAK==|_| |__| |