How to reduce data by averaging ???

2001-07-12 Thread Nemholt, Jesper Frank
Hi! I have various tables more or less similar to this : mysql> desc disk; +--+---+--+-+-+- --+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-

RE: CPU usage running mysql

2001-05-21 Thread Nemholt, Jesper Frank
> -Original Message- > From: David Allen [mailto:[EMAIL PROTECTED]] > Sent: lunes, 21 de mayo de 2001 14:36 > To: Simon Green; [EMAIL PROTECTED] > Subject: Re: CPU usage running mysql > > > Hello again! > > Do you know if there is any way I can see what the mysqld is > doing? If it is

RE: Having success with 20 million rows

2001-05-10 Thread Nemholt, Jesper Frank
> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: jueves, 10 de mayo de 2001 6:00 > To: Christian Jaeger; David J. Potter; [EMAIL PROTECTED] > Subject: Re: Having success with 20 million rows > > > At 11:00 PM +0200 5/9/01, Christian Jaeger wrote: > >Was the tab

RE: 64MB Limit on MyISAM indexes?

2001-04-20 Thread Nemholt, Jesper Frank
> -Original Message- > From: Jeff Brewer [mailto:[EMAIL PROTECTED]] > Sent: viernes, 20 de abril de 2001 18:24 > To: MySQL Mail List > Subject: 64MB Limit on MyISAM indexes? > > > I've got tables in ISAM format whose indexes are way over 64 > MB. However, > when I try to create a MyISA

RE: Unaligned address crash on Tru64

2001-04-09 Thread Nemholt, Jesper Frank
Hi! I have tested a bit today. Various logfiles are at : http://www.dassic.dk/~jfn/mysql/ I found that after compiling with full debugging, I got the error that one of the my.cnf parameters was too little and should be increased on the server. The default is 1 MB. I tried to increase it to 16 M

RE: Unaligned address crash on Tru64

2001-04-07 Thread Nemholt, Jesper Frank
> -Original Message- > From: Sasha Pachev [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 07, 2001 6:54 PM > To: Nemholt, Jesper Frank > Cc: [EMAIL PROTECTED] > Subject: Unaligned address crash on Tru64 > > > Jesper: > > The problem is apparently a

Signal 11 crash when running 3.23.36 in slave mode on Tru64

2001-04-06 Thread Nemholt, Jesper Frank
Hi! I've run into a problem with a replication setup. I have a 4 CPU EV5.6 AS4100 running a master database. MySQL is 3.23.36, OS is Tru64 4.0F patchkit 4. MySQL is compiled with Compaq CC & C++ with the recommended compiler options mentioned in INSTALL-SOURCE. This master database runs without

RE: Dual Processor and MySQL !

2001-04-01 Thread Nemholt, Jesper Frank
> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: domingo, 01 de abril de 2001 15:07 > To: Nemholt, Jesper Frank; [EMAIL PROTECTED] > Subject: RE: Dual Processor and MySQL ! > > > Hi , > > Thank you very much for yo

RE: Dual Processor and MySQL !

2001-04-01 Thread Nemholt, Jesper Frank
> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: sábado, 31 de marzo de 2001 17:09 > To: [EMAIL PROTECTED] > Subject: Dual Processor and MySQL ! > > > Hi , > > Sorry for this question may be this question asked before but > I can't find > it . >

RE: How to index this properly (to make it go faster) ?

2001-03-27 Thread Nemholt, Jesper Frank
> -Original Message- > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] > Sent: martes, 27 de marzo de 2001 10:00 > To: Nemholt, Jesper Frank > Cc: '[EMAIL PROTECTED]' > Subject: Re: How to index this properly (to make it go faster) ? > [clip] > >

RE: Mysql in a 4-way / 2 GByte server / raid 5

2001-03-27 Thread Nemholt, Jesper Frank
> -Original Message- > From: Rafael Martinez [mailto:[EMAIL PROTECTED]] > Sent: martes, 27 de marzo de 2001 15:28 > To: [EMAIL PROTECTED] > Subject: Mysql in a 4-way / 2 GByte server / raid 5 > > > Hello > > I am thinking to install our DB server in a 4-way machine with > Intel Xeon pro

RE: How to index this properly (to make it go faster) ?

2001-03-24 Thread Nemholt, Jesper Frank
> -Original Message- > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] > Sent: sabado, 24 de marzo de 2001 23:31 > To: Nemholt, Jesper Frank > Cc: '[EMAIL PROTECTED]' > Subject: Re: How to index this properly (to make it go faster) ? > > First,

How to index this properly (to make it go faster) ?

2001-03-24 Thread Nemholt, Jesper Frank
Hi! I have this table : mysql> describe proc; +-+---+--+-+ -+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+ -+---+

RE: Memory problems/bug ?

2001-03-12 Thread Nemholt, Jesper Frank
> -Original Message- > From: Nemholt, Jesper Frank > Sent: viernes, 09 de marzo de 2001 19:52 > To: '[EMAIL PROTECTED]' > Subject: Memory problems/bug ? > > > Hej! > > Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC. &g

Memory problems/bug ?

2001-03-09 Thread Nemholt, Jesper Frank
Hej! Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC. Ran optimize on a table, and after 10 minutes : 010307 17:00:00 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or