… this 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 not exit but will terminate query being executed. This is great as so many queries assumed CTRL-C…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1…, in the EC2 console hit CTRL-A to select all text on the page and then CTRL-C to copy it. Paste this… my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the…} =~ m/^SELECT/i’ –execute h=passive After a bit I CTRL-C‘ed it and it printed out the analysis of the… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…) was down. I figured out that everything was waiting on MySQL, so I restarted it to see if that would fix… lost. Then I received an e-mail, saying “Backup failed: MySQL has gone away” or something to that effect. Eventually I… long to complete, so I aborted with Ctrl-C. In fact, in that version of MySQL, this only caused the client to exit…
Comment: MySQL Crash Recovery
October 11, 2007 By 26 Comments
It feels funny to read in the same page about MySQL‘s stability and then about all those table/engine corruption…, then I pressed Ctrl+C. Now, in 4.0.26 it’s a bad idea to do this. The MySQL server went away… it more rewarding and challenging/less frustrating. From my part, MySQL can go down or I myself being generous, let them…
Comment: MySQL Crash Recovery
October 12, 2007 By 26 Comments
dboyr, I never have seen CTRL-C on the user console to crash MySQL Server this is what I mean. So this is… be crash save. They WILL most likely become corrupted if MySQL Server crashes. However you do not have to use MyISAM…
Comment: MySQL 5.1 Command line client improvements
July 14, 2007 By 11 Comments
[...] 5.x – Finally improved client Looking at my favorite rss feeds today, I found this post on great MySQL Performance Blog: …if you press CTRL-C MySQL Command Line Client will not exit [...]
Comment: MySQL 5.1 Command line client improvements
June 20, 2007 By 11 Comments
[...] 5.x – KonaÄno unapreÄ‘en klijent Listajući svoje omiljene WebDev feed-ove, za oko mi je zapao jedan post na sjajnom MySQL Perfomance Blogu: …if you press CTRL-C MySQL Command Line Client will not [...]
