And no performance diff. Note that you're benchmarks only show a 20M
addition overhead. We're about 60x too slow for these drives so I'm
not
sure what could be going on here :-/
I know of a site that encountered a similar performance issue:
The OS was reading in a lot more data from the disk th
Actually, I DID want to use an "IN" and not a "BETWEEN". What I was
doing was picking the two boundary times around a given point in time
so once I got those numbers, I wanted to get both records.
Ah, yes, I see I didn't really understand it the first time --
and using IDs instead of timestamps i
, where the call
as
stored as a line between the start point and the stop point, and the
query
is treated as a search for lines containing a certain point.)
- JD
--
John David Duncan, Consulting Engineer
MySQL AB, www.mysql.com
Office: +1 415 664-7396
--
MySQL General Mailing List
For li
Hi,
key_reads is usually a small fraction of key_read_requests,
but in the case of the server below, key_reads is actually
GREATER than key_read_requests. Can anyone explain what would
cause that to happen?
- JD
mysql> show status like 'key%';
++---+
| Variable_name
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
- JD
-
Before posting, plea
Hello,
I am wondering about the case where a client sends
mysql_query("commit")
but never gets a response.
Is the transaction complete, or not? Perhaps the "commit" was lost in the
network -- but, on the other hand, perhaps the server committed the
transaction and the reply was lost in the net
-----
John David Duncan
Systems Administrator
Great Schools, Inc.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
