Questions;
1. Is there a way to decrease random seeks? E.g. mysqld config
parameters, increase some buffer/cache sizes?
2. Optimize table: is there a way to rearrange data so that random
seeks are minimized?
3. If we have to live with large number of random seeks does anyone
know how the underlying FS can be optimized?
What is the EXPLAIN output of each?
Have you tried
analyze table x;
optimize table x;
On a 100GB, these might table a while. You probably want to LOCK the
table before running them.
Is it MyISAM or Innodb ?
--
------------------------------------------------------------------------
Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
1024D/A79997FA F357 0FDD 2301 6296 690F 6A47 D55A 7172 A799 97F
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
