…mysql command-line client? And did you know about the pager command…to be useful at the command line in the traditional Unix pipe-and-filter manner. What sort of goodies can we think of here? mysql…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…a script to rip through the file and parse it 10k lines at … is to think outside the box, even to think of things that seem “less …, such as maintenance and repair commands, that essentially negate the benefits …MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…place, we can begin. Open command line (shell) on the server and go to the directory where the …client’ ‘–with-comment=MySQL Community Edition (GPL)’ ‘–with-readline’ ‘CC=gcc’ ‘CFLAGS=-O2 -g -pipe -Wall -Wp,-…’t log queries which examine less than min_examined_row_limit rows to file. If you are …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…Pipes continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to…to return the data. In the real life applications performance is likely to be lower due to less…if you’re running script from command line otherwise APC cache will not work…
