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 taking up

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 table

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 MyISAM table

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

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 bug that under some circumstances tries

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: sbado, 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 . I want to

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 your compelete description about MySQL

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

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] Why that, usertime systemtime are data values

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: 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, you should run an analyize on your indexes (e.g

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. Ran optimize on a table, and after 10 minutes

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