lack of a primary key was the problem.
I am surprised the problem didnt show up in 3.23
but did in 4.12
Thanks for the suggestions!
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok I appear to have narrowed down the issue.
it appears to be the last table I had listed
named 'user_account1':
mysql> describe user_account1;
+-+--+--+-++---+
| Field | Type | Null | Key | Default| Extra |
+--
Im running a 2.8Ghz celeron P4, 1Gbyte RAM on
a 160Gb HD (IDE).
mysql> show variables;
+-++
| Variable_name | Value
|
+--
Hello-
I have a user list of about 200 entries
My original config was Fedora Core 3, Mysql 3.23
I upgraded today to Fedora Core 4 which comes with
MySQL 4.12. AFter updating all the packages etc
and setting up the website I run again, I notice
that I had slow query's during searches.
More in