On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas todd_...@ssiresults.com wrote:
I'm looking for automation direction...
I've found many packages that sit on top of MySQL. For the purposes of
consistency I'd like to automate these installs.
I've been able to automate the install and
i asked about this once upon a time, and might need a little more
help here. a friend's mysql hosting provider lost an entire DB, but
has managed to recover and hand over the ibdata1 file (or at least
some portion of it).
when my friend popped into mysql, what he's seeing is that some of
I installed iostat and used it. It showed that my MySQL data is striped
over four devices. During my idle query each of those four devices has
about 25% utilization, which is consistent with the hypothesis that this
I/O is the bottleneck. It looks like case closed. I am looking into
better
mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A
I start mysql with the above command. Then I want to select the rows
from the result of the following query, provided that for any rows
that have the same symbol, chrom and strand should be the same
(basically, discard the rows that have the same
