http://www.phpwizard.net/
you gotta download it... it's seperate from php and mysql.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 11:08 AM
To: [EMAIL PROTECTED]
Subject: phpMyAdmin
I was reading through the list and found nu
MYISAM
improved performance. As well as doing maintenance on each table with
myisamchk.
Thanks again,
Ryan
-Original Message-
From: Ryan Hadley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 3:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Performance issues.
Maybe we're
this is what I came up with...
The Key_reads/Key_read_request = 0.002 (much less than you suggest so that
is good... I think)
However this one worries me a bit...
Key_write/Key_write_requests = 0.087 (way lower than 1)
Does this mean that I am sending WAY to many un-needed UPDATE requests?
---
I haven't had a chance to do so yet.
But, we offer 4 kinds of searches:
'$word%'
'%$word%'
'%$word'
and
'$word'
So some searches still won't use indexes.
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: T
Thanks for the quick response.
The response time is slow... and the mysqld processes are what is hogging up
the system.
We do have indexes on the fields, but from what I understand, when you use a
"LIKE" statement, it rarely uses an index.
-Ryan
-Original Message-
From: Kent Hoover [ma
Woah! 800,000 visits a day!? Wow... try 80,000.
-Original Message-
From: Ryan Hadley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: Performance issues.
I'm not much of a db admin so I really don't know how to get better
p
I'm not much of a db admin so I really don't know how to get better
performance out of our database... but it seriously needs some speeding up.
We have this huge dictionary... It's 272235 rows. We have to be able to
search through it.
We run about 800,000 visits a day.
Right now we're doing a
