I recently found the MySQLStat page (http://www.mysqlstat.org/en). The
screen
shots look very appealing, but the code has not been updated for over 2
years.
Is anyone using this code with MySQL version 4? Is there another web
application
with similar or better functionality?
Thanks,
Jeff;
--
*
Hi
I have been running a master slave replication setup for the last few
years on mysql versions 3.23.36 (which was bundled with redhat 7.1 back
in the day).
Anyway, I finally convinced our boss to purchase a new server and we've
ended up installing mandrake 10 which comes complete with mysql 4.0
Are you sure this not because your query is cached by the MySQL query cache
now ? (try RESET QUERY CACHE before testing your query to be sure)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL P
Hey there
If I submit the following query:
SELECT * FROM mi_verdicts_search WHERE doctype = 'Verdict' AND (state =
'California: State Court' OR district = 'Circuit Court: Federal, Alaska'
OR appellate = 'US Supreme Court') AND speciality = 'Contracts'
When will a result be returned? When all of
Hello,
Now this I don't understand, now the query takes only 0.05s on any of
the two indexes.
I didn't do anything! Not even the analyze table I was going to try!
I'll keep you posted, thank you for the explanation, I understand the
reason for the filesort now.
Dirk.
Jocelyn Fournier wrote:
Hi,
Hi,
Well that's strange MySQL says more rows will be returned.
How many times does the query takes ?
And if you run ANALYZE TABLE on your table, does this change anything about
rows statistics ?
MySQL do not need filesort with this kind of index, because it can use the
index to retrieve the row i
Hello,
I added the index you said, but mysql (yes 4.x) still prefers using the
other index {put,front,topcategory,approvedby}.
And indeed, he uses the filesort. When I force into using your index, it
seems to be even slower (more rows but no filesort as you said)
But I have a question about that
Hi,
You can try to add an index on (put,front,topcategory,putdatetime) to avoid
MySQL has to do a filesorting on the data returned. (I assume you're using
MySQL 4.x)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: <[E
No, it doesn't improve the speed. I think that is because almost all
rows in that table are approved.
Are you also convinced that this is a very long time for such a query?
Or is it normal?
Andrew Kreps wrote:
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wrote:
with
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wrote:
>
> with indexes: id = primary, putdatetime, userid,
> {put,front,topcategory,approvedby} and review.
>
> If I want to know the 30 most recently added and approved items, I do
> the following simple query:
> SELECT id FRO
Hello,
I have this MyISAM table "story" (52MB):
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
+-+-+--+-+
Thanks Brent, your solution is the one that worked for me. In 4.0.20
there was no 'Super_priv' column however. ?
On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley <[EMAIL PROTECTED]> wrote:
> There probably is a "root" user, but it's not called root. You can name
> the "root" user whatever you
Caulfield, Linda wrote:
Hello,
I am trying to setup mysql and need some guidance -
thanks
Linda Caulfield
Software Quality Engineer
Global Hawk Program
Rancho Bernardo X4680
Phone:858.618.4680
Linda -
MySQL, 2d Ed., by Paul Dubois is hard to beat.
It provides a lot of guidance.
- offbyone
--
13 matches
Mail list logo
