RE: Managing big tables

2003-07-16 Thread Rudy Metzger
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] Se

RE: Managing big tables

2003-07-15 Thread Rudy Metzger
re analyze could be handy. -Original Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 16:24 To: Rudy Metzger Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Managing big tables Sorry rudy, but I can not understand what you tr

Re: Managing big tables

2003-07-15 Thread Veysel Harun Sahin
al Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Managing big tables http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little

RE: Managing big tables

2003-07-15 Thread Rudy Metzger
thing completely different. Cheers /rudy -Original Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Managing big tables http://www.mysql.com/doc/en/Data_size.html [

RE: Managing big tables

2003-07-15 Thread Rudy Metzger
ete records from one your and optimize this hear only). Cheerio /rudy -Original Message- From: Alexander Schulz [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 14:35 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Managing big tables Hello, i've got a little problem, we&#x

Re: Managing big tables

2003-07-15 Thread Veysel Harun Sahin
http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspa

RE: Managing big tables

2003-07-15 Thread Simon Green
time?? Simon -Original Message- From: Alexander Schulz [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 13:35 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Managing big tables Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on

Managing big tables

2003-07-15 Thread Alexander Schulz
Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by th