Re: confirm unsubscribe to mysql@lists.mysql.com

2005-06-14 Thread Richard Bennett
On Wednesday 15 June 2005 01:57, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > removed from the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/u/mysql/42af6ed786f34b14/richard.bennett=skynet.be > > This confirmation ser

Re: mysql optimizing large table

2004-10-22 Thread Richard Bennett
On Friday 22 October 2004 11:10, Mechain Marc wrote: > If you don't want to have those error messages: > > Increase the value of "Open File" using ulimit shell command. > > Do a ulimit -a to see the current value > Do a ulimit -n newvalue to increase it > > You can also modify the /etc/limits file

Re: mysql optimizing large table

2004-10-22 Thread Richard Bennett
Hi, On Thursday 21 October 2004 22:00, Dathan Vance Pattishall wrote: > My.cnf.huge is not good enough for your system specs. Calculate the Key > efficiency from the show status command. I bet the key efficiency is less > then 90% or so. By my count it is 99.88, the status output is: Key_blocks_u

mysql optimising large table

2004-10-21 Thread Richard Bennett
Hi, I have a table containing logfiles in mysql v4.0, myISAM. The table has about 8.5 million records. I'm using the my_huge.cnf file on mandrake10 Linux with 1 gig ram and 250gig HD space. Some Info:  Space usage : Type    Usage Data    3,063   MB Index   660,855 KB Total   3,708   MB  R