I follow http://dev.mysql.com/doc/refman/5.5/en/binary-installation.html and seems to be fine, but when I try to run mysql command-line I found this: # bin/mysql bin/mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory What I miss?
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… commands to enable vCache on the PCIe flash card (a Virident FlashMAX II) and set up the cache device with the command-line… to the appropriate sysctl setting; with vCache, there is a command-line binary which can modify many of the same parameters, but…
Comment: Percona Toolkit by example - pt-stalk
April 13, 2013 By 3 Comments
…] group with the mysql credentials. It’s just to avoid to add the user, password, socket, etc in the command line. This is optional, you can also 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: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine…-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
…://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache is hard to… oranges, means different server version. HS does not compile with MySQL 5.6 (yet). If you compare HS @ 5.5 with… simplistic PHP command line tests. However, apples and oranges – think of features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent…
Comment: Fun with the MySQL pager command
May 1, 2013 By 6 Comments
… quite right: it is also counting the header lines. I modified it as follows: mysql> pager grep -v ‘\-\+\-’ | grep -v ” Id[ |]*User…’ mysql> show processlist; 5 Sleep 2 Connect 1 Query 8 rows in set (0.00 sec) No more entries for ‘Command‘ or…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice… command line client works: it just outputs all results. It can be annoying but it is easily solved by using the pager command: mysql…, you will see a copy of your session. Conclusion The mysql command line client is not as glossy as most of the graphical…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 13 Comments
How many of you use the 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: 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… done on production. Moreover you can put tee=/logs/mysql.log in “mysql” section in my.cnf to have logging enabled automatically… the client. If you’re looking to log session beyond MySQL command line client you can check out “script” tool.
Post: MySQL and predictive option handling - beware
October 29, 2012 By 2 Comments
MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the… one today (thankfully on the test box). MySQL init Scripts use “stop” and “start” commands to start and stop the server while…@smt2:/var/lib/mysql# mysqladmin stop Slave stopped It would be quite confusing if mysqladmin would have “stop” command which does not…
