Re: Mysql openBSD Copying to tmp table

2004-09-07 Thread Egor Egorov 
"Mevershosting.nl" <[EMAIL PROTECTED]> wrote:

> Anyone here have any qlue ?

We had a couple of dissatisfactions trying to run MySQL on OpenBSD. 

See http://bulk.fefe.de/scalability/





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




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

Mysql openBSD Copying to tmp table

2004-09-07 Thread Mevershosting.nl 
Hi all,

Let me first say i am new to this list, but i did search all the
internet for an answer for my problems.

I have the following situation:

OpenBSD 3.4 with Mysql 4.0.20 (It does not matter which version, the
problem is on all)

There is a forum running on this machine dedicated, (2,6 Ghz 1GB
internal mem)

The forum runs quick until somebody searches the forum, the process list
shows a item which has the: Copying to tmp table state

This takes ages, at least 200 seconds


I tested with all kinds of config in my.cnf but nothing seems to help at
all..


Now i moved the DB over to a Redhad Linux and MySQL 3.23.54, and the
same search takes about 2 seconds !!

this is a few 1000% faster then the openBSD machine.

I allready tried making the config of the OpenBSD machine the same as
the one from the linux machine but even that does not help..


I figure the must be something really wrong with the combination of
OpenBSD and Mysql..

Anyone here have any qlue ?

Thanx in advance for all help..

Richard
Mevers

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