RE: phpMyAdmin

2001-02-14 Thread Ryan Hadley
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

RE: Performance issues.

2001-02-07 Thread Ryan Hadley
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

RE: Performance issues.

2001-02-06 Thread Ryan Hadley
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

RE: Performance issues.

2001-02-06 Thread Ryan Hadley
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

RE: Performance issues.

2001-02-06 Thread Ryan Hadley
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