How to increase mysql server performance?

OS: NW 6.5 SP5
Mysql server 4.0.26 (mysqld_safe, default configuration)
Hardware: 2 x 3G Xeon, 4GB RAM, RAID 10

Select and insert operations on this powerful server works most slowly than 
on workstation under Linux with 1 CPU and 1GB of RAM and Mysql 5.0.

Mysql system variables on server and workstation are mostly identical:
(this is config from workstation, values are mostly similar with server)
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

For example, 'load data infile' execution time -
Powerful server - 60 min
Workstation - 10 min

How to find a bottleneck and increase performance? 

Hi Serg,
it would be fair only if you compare against same mysql version, so 
download mysql 5 for NetWare, and test with that please...

Guenter.


"Serg" <skoltogyanREMOVETHIS@mail.ru> wrote in
news:VodOg.3610$lb5.76@prv-forum2.provo.novell.com: 

> OS: NW 6.5 SP5
> Mysql server 4.0.26 (mysqld_safe, default configuration)
> Hardware: 2 x 3G Xeon, 4GB RAM, RAID 10
> 
> Select and insert operations on this powerful server works most slowly
> than on workstation under Linux with 1 CPU and 1GB of RAM and Mysql 5.0.
> 
> Mysql system variables on server and workstation are mostly identical:
> (this is config from workstation, values are mostly similar with server)
> key_buffer = 16M
> max_allowed_packet = 1M
> table_cache = 64
> sort_buffer_size = 512K
> net_buffer_length = 8K
> read_buffer_size = 256K
> read_rnd_buffer_size = 512K
> myisam_sort_buffer_size = 8M
> 
> For example, 'load data infile' execution time -
> Powerful server - 60 min
> Workstation - 10 min
> 
> How to find a bottleneck and increase performance? 
> 
> 
> 

> Hi Serg,
> it would be fair only if you compare against same mysql version, so
> download mysql 5 for NetWare, and test with that please...
Sorry.
This work enviromet server.
This test (upgrade to mysql5) impossible at  this time..

Ma by exist any info - How incrise perfomance MySQL on the NW6.5Sp5 ??

This operation:
use sdntsk;
LOAD DATA INFILE 'sysdata:\\inet.csv'
INTO TABLE inet   FIELDS ENCLOSED BY '"' 
(id,impid,dt,ip,bytes,url,file,login);

SLOWLY  !!! more then 90 min..!!!!

inet.csv hav size: 1533M

On the NW6.5 was renamed sys:\mysql to sys:\mysql1
And install mysql5.0.24.a

After this on the NW6.SP5 import flarge file (1.5G) = 16 Min
(import on the simple linux ws with ide hda = 10 min).

But...
1. In the new mysql5.0.24a i can not found directory:
sys:/mysql/java  with mysql-connector-java*

2. I do not know - how upgrade old Mysql databases to the New.

Serg

Hi Serg,
"Serg" <skoltogyanREMOVETHIS@mail.ru> wrote in
news:UBxOg.4545$lb5.923@prv-
forum2.provo.novell.com:

> On the NW6.5 was renamed sys:\mysql to sys:\mysql1
> And install mysql5.0.24.a
> 
> After this on the NW6.SP5 import flarge file (1.5G) = 16 Min
> (import on the simple linux ws with ide hda = 10 min).
well, that's now way better, and closer to Linux....

> But...
> 1. In the new mysql5.0.24a i can not found directory:
> sys:/mysql/java  with mysql-connector-java*
you can just copy over your existing directory from 4.0.2x

> 2. I do not know - how upgrade old Mysql databases to the New.
take a look here:
http://www.gknw.de/phpbb/viewforum.php?f=23
its not complete, but a good starting point.

greetz, Guenter.