Hi, I'm installing mysql from source tarball (*.tar.gz ) version 3.23.41. For your Infomation, I'm installing MySQL on a storage server and connect it through my web server using Scsi controller. My problem are when user took a very long time to trying to retrieve data from MySQL server, even worst the connection reset. I tried to benchmark it on a stand alone web server with database and the connection is normal. When I do 'ps -ef | grep mysql', I get the following result: root 1310 1 0 Oct23 ? 00:00:00 sh /var/lib/mysql/bin/safe_mysql root 1336 1310 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 1338 1336 0 Oct23 ? 00:00:02 /var/lib/mysql/bin/mysqld --defa root 1339 1338 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 1807 1338 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 1843 1338 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 1978 1338 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 2239 1338 0 Oct23 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 4083 1338 0 Oct24 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 8859 1338 0 Oct25 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa root 9847 1338 0 01:23 ? 00:00:04 /var/lib/mysql/bin/mysqld --defa root 10503 1338 0 06:40 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa
May I know the different between 1) mysql 19204 737 0 09:54 ? 00:00:00 /usr/sbin/mysqld-max --basedir=/ AND THIS ONE 2) root 10503 1338 0 06:40 ? 00:00:00 /var/lib/mysql/bin/mysqld --defa Are they something wrong with my configuration on source installation? Attach together is my variables for the MySQL Server. Please reply ASAP. Thank you. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 --------------------------------------------------------------------- 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