show index from gwarp;
mysql>
+---+++--+-+---+
-+--++-+
-> | Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Comment |
->
+---+
Subject: Re: pls help !!
On Wed, 2001-10-31 at 08:52, kmlau wrote:
> hi all,
>
>Let me to introduce somethings first, we use mysql for a logging system
> and take about max 150 000 records hourly. And we need to take a period of
> data for analyzing.
I haven't followed the
| 618 | NULL | NULL | |
+-+--+-+
--+-+---+---+-+-
++
3 rows in set (0.00 sec)
Would all experts give me any advices ?
regards,
kmlau
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: FW: pls help for index problem
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TAB
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I al
timerecord = '010902'
table type possible_keyskey key_len ref rows Extra
gw ALL timerecord 8313193 where used
*remark: The total records in the table gw are 8313193 !
regards,
kmlau
(I have already read the official
mestamp(10),
KEY esnindex (esn, timerecord),
KEY timerecordindex (timerecord)
);
regards,
kmlau
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear all,
i used mysql on linux 7.1. And i discovered mysql not free the memory .
pls advise !1
1:24am up 1 day, 10:11, 2 users, load average: 1.13, 1.26, 1.31
65 processes: 63 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 4.2% user, 1.3% system, 0.0% nice, 93.3% idle
CPU1 stat
