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:
+---+--+--
crc problems with solaris tar and the
mysql sources.
Regards,
Dan Rowe
Easynet LTD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
I am having a similar sort of problem, 88k+ records (syslog entrys) doing a
select * from db group by host takes 2.5seconds select * where with a host
with 87k records takes 5.7seconds. CPU useage jumps up to to between 10 and
99.9% With a single proc linux box the exact same happened but with les
