Hi - this is a repost [sorry] We have installed MYSQL Ver 8.23 Distrib 3.23.54, for sun-solaris2.8 on sparc from a binary onto a 6 processor server with 6 gig of ram but we are seeing very slow imports. A 16M export takes 7 minutes, a 60M export takes over an hour.
I have tuned my.cnf but performance seems to be very sluggish - anyone got any thoughts? Also I am slightly confused by the flags that appear to be started with mysql - /global/mysqldg/mysql_01/mysql-3.23.54a-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-file=/global/mysqldg/mysql_01/mysql-3.23.54a-sun-solaris2.8 -sparc/data/my.cnf --basedir=/global/mysqldg/mysql_01/mysql-3.23.54a-sun-solaris2.8-sparc --datadir=/usr/local/mysql/data --user=mysql --pid-file=/tmp/mysql.pid does this means that mysql is reading my.cnf from $basedir/data - this isn't specified in in the startup script - could it be compiled into the binary? Thanks Dave -- David Campbell :: Granada Sport and Interactive Email :: [EMAIL PROTECTED] Direct :: +44(0)20 7578 4415 Support :: +44(0)20 7578 4392 ********************************************************************** Please visit the official Granada website at www.granadamedia.com for the latest company news. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Thank you. ********************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php