… seen a situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will not shut…/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… Error in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr_posasmp/panel…_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… Error in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr_posasmp/panel…_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…connects…MySQL server’s limitation…openings in chess — the great chess players study openings…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…connections. New user statements have been introduced for handling the XtraDB changed page tracking log files… XtraDB used to print the open read view list without … option innodb_changed_pages_limit. MySQL option handling would then… innodb_changed_pages_limit option to innodb_max_changed_pages. Bug …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… and innodb_max_purge_lag will become…connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connection… Innodb tries to limit thread concurrency … showing details of file IO: ——– FILE I/O ——–… 1 read views open inside InnoDB Main thread…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit…131072 max_used_connections=0 max_threads=151 thread_count=0 connection…open+0×88)[0xefa248] /usr/lib/libgalera_smm.so(gcs_open+0x2c8… mysqld from pid file /var/lib/mysql/mysql1.pid ended…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…issuing LOAD DATA on 180MB file ( for 1989 year, 1st month…_length: 0 Data_length: 0 Max_data_length: 0 Index_length:…Month); ERROR 122 (HY000): Cannot open table handle for ontime. …c DESC LIMIT 10; 4.96 sec Query Q4: mysql> SELECT Carrier,… restarted mysqld but could not connect to mysqld anymore. In …
