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
st = 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?
- Original Message -
From: "Jim Beigel" [EMAIL PROTE
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
performance
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
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: Tuesday, February 06, 2001 7:26 PM
To: 'Ryan Hadley