I am currently running Mysql 3.23.41 on a E250, 2x 400mhz proc with half a gig of memory, 6 9.1gig scsi disks in raid5 and Solaris 7. The database i have a database with 88365 records and expanding daily (it holds syslog messages for various servers)
Table desc: +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | sdate | date | YES | | NULL | | | stime | time | YES | | NULL | | | shost | varchar(128) | YES | | NULL | | | smsg | text | YES | | NULL | | | id | int(10) unsigned | | MUL | NULL | auto_increment | +-------+------------------+------+-----+---------+----------------+ Doing a simple query e.g. select * from syslogTB group by shost; takes a long time to give a result: 2.13 sec Any ideas? Thanks Dan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
