Maybe you could get some speed increase for you queries by setting the
record_buffer to a higher value. Because with fixed row length this
buffer fills up faster too. Although I doubt that you will gain a lot...

/rudy

-----Original Message-----
From: Alexander Schulz [mailto:[EMAIL PROTECTED] 
Sent: dinsdag 15 juli 2003 17:06
To: [EMAIL PROTECTED]
Subject: Re:Managing big tables

Thanks for your efforts, and in rudys last mail he confirms what i have 
feared, the io-overhead for reading the
extremely longer rows most probably causes these longer query-times. I 
think we will have to redesign our
table-structure, because we're already working on a (hardware-)raid, so 
the mysql-raid-option won't really be
an option. Perhaps the only way to get this damned big tables smaller in

appropriate time will be a solution
via merge-tables (if this does not slow down our productive queries on 
that table too much).

alex





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to