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
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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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 is
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,
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
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)
To request this thread, e-mail [EMAIL