sluggish mysql5

[yoda]

ok, my laptop, Dell inspiron 9100 has windows XP and Mysql 5. My developement server has LFS and mysql 5.
My server is giving me a slugish responce compaired to my laptop.

:example
Identical database on laptop and server..... 82 tables and aprox 700mb of data
My laptop displays the tables for the database with less than a 1 second delay in Mysqladmin on my laptop.
The server takes 25 seconds to display the tables in mysqladmin on my laptop.

Surely having the 100mb connection their shouldn't make that much diference?????

I'm using my-huge.cnf config file for linux and the default one for windows.

No other traffic is going through that server, server is running apache with PHP but their is 99.5% processor usage free. server has 1gb of ram, laptop has 1.5gb.

Any surgestions?

 

[riddlermarc]

Is it worth trying the mysql benchmark suite? http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html

Might give you a couple of hints?

 

[yoda]

I don't seem to be able to run the tests..... I'm not sure why....

Crash-me reports....

Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i686-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl .) at ./crash-me line 45.
BEGIN failed--compilation aborted at ./crash-me line 45.

However, I re-ran the mysql test and it produced the following...

Logging: ./mysql-test-run --extern
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST RESULT
-------------------------------------------------------
alias [ pass ]
alter_table [ pass ]
analyse [ pass ]
analyze [ pass ]
ansi [ pass ]
archive [ pass ]
archive_gis [ pass ]
auto_increment [ pass ]
backup [ pass ]
bdb-alter-table-1 [ skipped ]
bdb-alter-table-2 [ skipped ]
bdb-crash [ skipped ]
bdb-deadlock [ skipped ]
bdb [ skipped ]
bdb_cache [ skipped ]
bdb_gis [ skipped ]
bench_count_distinct [ pass ]
bigint [ pass ]
binary [ pass ]
binlog [ skipped ]
blackhole [ pass ]
bool [ pass ]
bulk_replace [ pass ]
case [ pass ]
cast [ pass ]
check [ pass ]
client_xml [ pass ]
comments [ pass ]
compare [ pass ]
compress [ pass ]
connect [ pass ]
consistent_snapshot [ pass ]
constraints [ pass ]
count_distinct [ pass ]
count_distinct2 [ pass ]
count_distinct3 [ pass ]
create [ pass ]
create_select_tmp [ pass ]
csv [ pass ]
ctype_big5 [ skipped ]
ctype_collate [ pass ]
ctype_cp1250_ch [ skipped ]
ctype_cp1251 [ pass ]
ctype_cp932 [ skipped ]
ctype_cp932_binlog [ skipped ]
ctype_cp932_notembedded [ skipped ]
ctype_create [ pass ]
ctype_eucjpms [ skipped ]
ctype_euckr [ skipped ]
ctype_gb2312 [ skipped ]
ctype_gbk [ skipped ]
ctype_latin1 [ pass ]
ctype_latin1_de [ pass ]
ctype_latin2 [ pass ]
ctype_latin2_ch [ skipped ]
ctype_many [ skipped ]
ctype_mb [ pass ]
ctype_recoding [ pass ]
ctype_sjis [ skipped ]
ctype_tis620 [ skipped ]
ctype_uca [ skipped ]
ctype_ucs [ skipped ]
ERROR: /src/mysql-5.0.21/mysql-test/var/run/master.pid was not created in 400 seconds; Aborting

Any ideas?