… about very helpful but often forgotten about “Pager” feature of command line client. There is another one which falls into the same list… enabled automatically when you start the client. If you’re looking to log session beyond MySQL command line client you can check out “script” tool…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 10 Comments
… mysql command-line client? And did you know about the pager command you can give it? It’s pretty useful. It tells mysql to pipe the output of your commands through… at the command line in the traditional Unix pipe-and-filter manner. What sort of goodies can we think of here? mysql> pager…
Post: MySQL 5.1 Command line client improvements
June 16, 2007 By 11 Comments
Just found this little handy feature today: mysql> insert into c select rand()*1000, sha1(rand()) from c; … execution was interrupted So now if you press CTRL-C MySQL Command Line Client will not exit but will terminate query being executed. This… assumed CTRL-C would also abort running query in previous MySQL versions and I’ve seen many monstrous queries left running…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… did this as command line client is known to optimize queries sometimes by skipping “unnecessary” comments. So here is the command line run: mysql> select /* my… not use MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about MySQL 5.0…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… as the underlying storage for the virtual machines. Baseline: The MySQL command line client was used to execute the a script file containing the…, the results and response times were captured with the T command. The queries were executed on a single database schema containing… the output was captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime_one password= port=5029 column=date…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
… the system can look like while this process is ongoing: mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host | db | Command | Time | State | Info… 6 can’t even log in because it was a MySQL command-line client that wasn’t started with -A, and it’s trying… LOCK command completes and sends its response to the client that issued it. Holding the lock The final part of this command is…
Comment: MySQL Query Cache WhiteSpace and comments
March 25, 2008 By 9 Comments
… the mysql command line client now has an *option* to pass comments to the server, but it’s disabled by default: http://bugs.mysql.com/bug.php?id=26215 I’m running the 5.0.56 client and server, and from the command line, my…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
… | 3 | 0 | +———-+——-+——–+————-+ 1 row in set (0.00 sec) This command lists all non-temporary tables in the table-cache, showing… it is being used. Note however if you’re starting MySQL Command line client without “-A” option it opens all tables in the active…
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 [...]
