--- Jeff Lacki <[EMAIL PROTECTED]> wrote:
>
+-+--+--+-++---+
> | Field | Type | Null | Key |
> Default| Extra |
>
+-+--+--+-++---+
> | id | bigint(20) |
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]
Jeff Lacki wrote:
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| Ext
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.
Maybe you had configuration file with different
settings. Nevertheless, send the information about
your RAM size, the output of SHOW VARIABLES,
configuration file, table definitions (use SHOW CREATE
TABLE), EXPLAIN output for your query, and list should
help you.
Jeff Lacki <[EM
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
