MySQL Forums
Forum List  »  Performance

Re: speed of query/can index help?
Posted by: Ray Chambers
Date: June 30, 2009 08:08AM

mysql> show table status like 'syslogDAlert_data'\G
*************************** 1. row ***************************
Name: syslogDAlert_data
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1327
Avg_row_length: 301
Data_length: 400144
Max_data_length: 281474976710655
Index_length: 698368
Data_free: 0
Auto_increment: 1328
Create_time: 2009-06-29 10:36:09
Update_time: 2009-06-29 10:36:09
Check_time: 2009-06-29 10:36:11
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.02 sec)



* Is msgNum unique or not?
yes



What is the relationship between the two tables? 1:1? Or are there many rows in syslogDAlert_data for each row in the other table? (That's what it feels like.)
-------------------------------
my guess would be 1 syslogDAlert_data to many syslogD rows..



Is there only one distinct value of
syslogD.sev, syslogD.SDS_loghost, syslogDAlert_data.aCtion
for each value of syslogD.msgNum?
--------------------------------------
there can be 5million syslogD entries thaat are the same... but times entries will differ... the msgNum will always equal 1 specfic issue which is noted by the syslogDAlert_data.msgID.. so think of the syslogD.msgNum as a key pointing to syslogDAlert_data.msgID to find specfic information about that ID.




Your first posting showed 7,099,286 in syslogD; the SHOW TABLE STATUS shows 1,885,246 rows. Did you start over?
-------------------------------------
We did.. I made some performance changes to my code... and wanted to calc the # of rows i was inserting per second..

mysql> select count('*') from syslogD;
+------------+
| count('*') |
+------------+
| 3883128 |
+------------+
1 row in set (0.00 sec)



this table, once i get this worked out, can end up being pretty big..
my guess would, based on the need to keep data, it could grow to over 10million rows easily.. once i get this working.

Options: ReplyQuote


Subject
Views
Written By
Posted
4051
June 26, 2009 06:15PM
1890
June 26, 2009 08:56PM
1964
June 27, 2009 03:04AM
1822
June 27, 2009 10:39AM
1782
June 30, 2009 12:26AM
Re: speed of query/can index help?
1852
June 30, 2009 08:08AM
1926
June 30, 2009 10:36PM
1732
July 01, 2009 08:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.