… little handy feature today: mysql> insert into c select rand()*1000, sha1(rand()) from c; Query aborted by Ctrl+C ERROR 1317 (70100): Query execution was interrupted So now if you press CTRL-C MySQL Command Line Client will… so many queries assumed CTRL-C would also abort running query in previous MySQL versions and I’ve seen many monstrous queries…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… these figures. Queries/sec: 265 Traffic: 1Mb/sec Connections:259 ‘Aborted_clients‘, ’267108′ ‘Aborted_connects’, ’25997′ ‘Binlog_cache_disk_use’, ’145′ ‘Binlog_cache…/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Post: Announcing Percona XtraDB Cluster 5.5.28-23.7
November 15, 2012 By 9 Comments
… contains a comma-separated list of incoming (client) addresses in the cluster component. Multiple … in every use case. SQL statements aborted due to multi-master conflict can be…and with regular MySQL replication slave configured, could cause intermittent failure to start MySQL slave during…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… tcpdump traffic only from a small and representative subset of clients tcpdump a modulo of incoming ports (including port 3306, because… 30% when filtering only 4 out of hundreds of active clients). While this is lower than without the filter, it is… “$TMP/$LOCKFILE” ]; then echo “$self: lock file $LOCKFILE already exists, aborting” exit 1 fi # set trap to be sure tcpdump doesn…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…performance even with the increased number of client connections. New user statements have been …command line option innodb_changed_pages_limit. MySQL option handling would then shadow the …tracking initialization would fail. The server would abort on startup. Bug fixed #1083596 (Laurynas Biveinis…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… FLUSH TABLES WITH READ LOCK when slave applier needed to abort transaction that is on the way, caused the deadlock situation…, Percona-XtraDB-Cluster-server and Percona-XtraDB-Cluster-client would conflict with mysql and mysql-server packages. Bug fixed #1087506 (Ignacio Nin). Other…
Comment: Apache PHP MySQL and Runaway Scripts
May 21, 2008 By 20 Comments
… like scripts or MySQL calls and does not output anything to the browser neither automatic termination not connection_aborted() check seems to… as if no low level network send is attempted connection abort from client will not be discovered.” That’s normal for a… the browser but the server will know that the client is there. The MySQL SLEEP function gives me thoughts about possible SQL…
Comment: Apache PHP MySQL and Runaway Scripts
May 21, 2008 By 20 Comments
… fact it is quite close to MySQL case – if client is gone SELECT * FROM tbl; will be aborted virtually instantly while if temporary… decent performance. In most application running too long and user abort are exceptions rather than the normal flow. Also note there…_aborted() could in theory do that but it does not do it – which is good thing to keep in mind. MySQL SLEEP…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…, I am seriously facing connection abort very frequently in mysql server which starts increasing as I restart mysql service. Pl look into ini… Thanks!!! version: MySQL Server 5.0 INI setting : [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 log-bin=mysql-bin server…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result… If you do not fetch data for long enough MySQL Server may think client is dead and close connection. This well may… problems with table locks and other issues plus if script aborts it may be hard to restart. So it may be…
