…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression which caused innobackupex… detection did not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail. Bugs…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL. After…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and…
Comment: Percona Toolkit by example - pt-stalk
April 13, 2013 By 3 Comments
… a [client] group with the mysql credentials. It’s just to avoid to add the user, password, socket, etc in the command line. This… add these parameters in the command line.. Example of a file: [client] user = ptuser password = MyPass port = 3307 socket = /tmp/mysql_sandbox22585.sock Regards
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… the command line client works: it just outputs all results. It can be annoying but it is easily solved by using the pager command: mysql… to record the queries that you have executed. The command line client offers the tee command, which will log to a file the statements…, you will see a copy of your session. Conclusion The mysql command line client is not as glossy as most of the graphical tools…
Post: Logging your MySQL command line client sessions
July 8, 2008 By 10 Comments
… 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 13 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 23 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…
