tag:blogger.com,1999:blog-8575059197193667898.post2010218413943536742..comments2023-08-20T03:33:44.741-07:00Comments on Dave's Stuff: When MySQL splashes back too muchDave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8575059197193667898.post-63105880816988051702008-11-29T08:23:00.000-08:002008-11-29T08:23:00.000-08:00yep! I use the \P abbreviation to turn it on and ...yep! I use the <BR/><BR/>\P <BR/><BR/>abbreviation to turn it on and off. It's actually very useful, and you can use something like "more" or "less" or even "grep". For example, recently I did:<BR/><BR/>\P grep root<BR/>SHOW PROCESSLIST;<BR/>\P<BR/><BR/>to be able to see all the processes owned by root on a 5.0 server. The 2nd \P will revert it back to stdout.<BR/><BR/>very, very useful. That and ending commands with \G instead of ; helps (vertical mode, for those that don't know what it is, try it with SHOW PROCESSLIST\G sometime).Sheeri K. Cabralhttps://www.blogger.com/profile/13990877688502800403noreply@blogger.com