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 s
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
bette
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
t
